Connect with us

MARKETING

How to Highlight Duplicates in Google Sheets [Step-by-Step]

Published

on

Duplicate data is the bane of spreadsheet solutions, especially at scale. Given the volume and variety of data now entered by teams, it’s possible that duplicate data in tools like Google Sheets may be relevant and necessary, or it could be a frustrating distraction from the primary purpose of spreadsheet efforts.

The potential problem raises a good question: How do you highlight duplicates in Google Sheets?

We’ve got you covered with a step-by-step look at how to highlight duplicates in Google Sheets, complete with images to make sure you’re on the right track when it comes to de-duplicating your data.

Highlighting Duplicate Data in Google Sheets

Google Sheets is a free, cloud-based alternative to proprietary spreadsheet programs and — no surprise, since it’s Google we’re dealing with — offers a host of great features to help streamline data entry, formatting, and calculations.

Advertisement

blank google sheets for highlighting duplicate data

Google Sheets has all the familiar functions: File, Edit, View, Format, Data, Tools, etc. and makes it easy to quickly enter your data, add formulas for calculations, and discover key relationships. What Sheets doesn’t have, however, is an easy way to find and highlight duplicates.

While other spreadsheet tools, such as Excel, have built-in conditional formatting tools that can pinpoint duplicate data in your sheet, Google’s solution requires a little more manual effort.

Step-by-Step: How to Highlight Duplicates in Google Sheets (With Pictures)

So how do you automatically highlight duplicates in Google Sheets? While there’s no built-in tool for this purpose, you can leverage some built-in functions to highlight duplicate data.

Here’s a step-by-step guide:

Step 1: Open your spreadsheet.

Step 2: Highlight the data you want to check.

Advertisement

Step 3: Under “Format”, select “Conditional Formatting.”

Step 4: Select “Custom formula is.”

Step 5: Enter the custom duplicate checking formula.

Step 6: Click “Done” to see the results.

Step 1: Open your spreadsheet.

First, head to Google Sheets and open the spreadsheet you want to check for duplicate data.

how to highlight duplicate data in google sheets: open spreadsheet

Step 2: Highlight the data you want to check.

Next, left-click and drag your cursor over the data you want to check to highlight it.

how to highlight duplicate data in google sheets:  select data

Step 3: Under “Format”, select “Conditional Formatting.”

Now, head to “Format” in the top menu row and select “Conditional Formatting”. You may get a notification that says “cell is not empty” — if so, click on it, and you should see this:

Advertisement

how to highlight duplicate data in google sheets: open conditional formatting options

Step 4: Select “Custom formula is.”

Next, we need to create a custom formula. Under “Format cells if”, select the drop-down menu and scroll down to “Custom formula is”.

how to highlight duplicate data in google sheets: select custom formula is

Step 5: Enter the custom duplicate checking formula.

To search for duplicate data, we need to enter the custom duplicate checking formula, which for our column of data looks like this:

=COUNTIF(A:A,A1)>1

This formula searches for any text string that appears more than once in our selected data set, and by default will highlight it in green. If you prefer a different color, click on the small paint pot icon in the formatting style bar and select the color you prefer.

how to highlight duplicate data in google sheets: insert formula

Step 6: Click “Done” to see the results.

And voilà — we’ve highlighted the duplicate data in Google Sheets.

how to highlight duplicate data in google sheets: result

How to Highlight Duplicates in Multiple Rows and Columns

If you’ve got a larger data set to check, it’s also possible to highlight data duplicates in multiple columns or rows.

Advertisement

This starts the same way as the duplicate checking process above — the only difference is that you change the data range to include all the cells you want to compare.

In practice, this means entering an expanded data range in the Conditional format rules menu and the custom format box. Let’s use the example above as a starting point, but instead of just searching column A for duplicates, we’re going to search across three columns: A, B, and C, and also across rows 1-10.

how to highlight duplicate data in google sheets: data with multiple rows

When we enter our conditional format rules, Apply to Range becomes A1:C10 and our custom formula becomes:

=COUNTIF($A$2:G,Indirect(Address(Row(),Column(),)))>1

This will highlight all duplicates across all three columns and all 10 rows, making it easy to spot data doppelgangers:

how to highlight duplicate data in google sheets in multiple rows and columns: result

Dealing With Duplicates in Duplicates in Google Sheets

Can you highlight duplicates in Google Sheets? Absolutely. While the process takes more effort than some other spreadsheet solutions, it’s easy to replicate once you’ve done it once or twice, and once you’re comfortable with the process you can scale up to find duplicates across rows, columns, and even much larger data sets.

Advertisement

business google sheets templates

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

MARKETING

Trends in Content Localization – Moz

Published

on

Trends in Content Localization - Moz

Multinational fast food chains are one of the best-known examples of recognizing that product menus may sometimes have to change significantly to serve distinct audiences. The above video is just a short run-through of the same business selling smokehouse burgers, kofta, paneer, and rice bowls in an effort to appeal to people in a variety of places. I can’t personally judge the validity of these representations, but what I can see is that, in such cases, you don’t merely localize your content but the products on which your content is founded.

Sometimes, even the branding of businesses is different around the world; what we call Burger King in America is Hungry Jack’s in Australia, Lays potato chips here are Sabritas in Mexico, and DiGiorno frozen pizza is familiar in the US, but Canada knows it as Delissio.

Tales of product tailoring failures often become famous, likely because some of them may seem humorous from a distance, but cultural sensitivity should always be taken seriously. If a brand you are marketing is on its way to becoming a large global seller, the best insurance against reputation damage and revenue loss as a result of cultural insensitivity is to employ regional and cultural experts whose first-hand and lived experiences can steward the organization in acting with awareness and respect.

Source link

Advertisement
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

How AI Is Redefining Startup GTM Strategy

Published

on

How AI Is Redefining Startup GTM Strategy

AI and startups? It just makes sense.

(more…)

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

More promotions and more layoffs

Published

on

More promotions and more layoffs

For martech professionals salaries are good and promotions are coming faster, unfortunately, layoffs are coming faster, too. That’s according to the just-released 2024 Martech Salary and Career Survey. Another very unfortunate finding: The median salary of women below the C-suite level is 35% less than what men earn.

The last year saw many different economic trends, some at odds with each other. Although unemployment remained very low overall and the economy grew, some businesses — especially those in technology and media — cut both jobs and spending. Reasons cited for the cuts include during the early years of the pandemic, higher interest rates and corporate greed.

Dig deeper: How to overcome marketing budget cuts and hiring freezes

Be that as it may, for the employed it remains a good time to be a martech professional. Salaries remain lucrative compared to many other professions, with an overall median salary of $128,643. 

Advertisement

Here are the median salaries by role:

  • Senior management $199,653
  • Director $157,776
  • Manager $99,510
  • Staff $89,126

Senior managers make more than twice what staff make. Directors and up had a $163,395 median salary compared to manager/staff roles, where the median was $94,818.

One-third of those surveyed said they were promoted in the last 12 months, a finding that was nearly equal among director+ (32%) and managers and staff (30%). 

PX3zocqNZfzMbWNEZhW9dZnAgkdPrLW8fjkrbVrcEkrNJpJiXrVKkjlQ0Tzuj8YKh Ht9HTEvmxDDt0ZsntfYiZHS0NJ7zEZ 6yMT3OjZajbaXBFV1D2Pk5euJeHKdRuzOzM5ZUxwNtsVNaiIbNrd Q

Extend the time frame to two years, and nearly three-quarters of director+ respondents say they received a promotion, while the same can be said for two-thirds of manager and staff respondents.

Dig deeper: Skills-based hiring for modern marketing teams

Employee turnover 

In 2023, we asked survey respondents if they noticed an increase in employee churn and whether they would classify that churn as a “moderate” or “significant” increase. For 2024, given the attention on cost reductions and layoffs, we asked if the churn they witnessed was “voluntary” (e.g., people leaving for another role) or “involuntary” (e.g., a layoff or dismissal). More than half of the marketing technology professionals said churn increased in the last year. Nearly one-third classified most of the churn as “involuntary.”

FIHUBtZJfK3IzbyZl C6WXBPTE64Gzg1URDzQUXCrD8YkAPZS7mmjpmAAiuhhheJUE4dGVcn6e9XW87ogLVz0Ya4rqHwB8WfXTHS W0hRW7yEdr2bQNjlTwnXvNhMv9NZ092pq1ws7lu DYqLV8i6fcFIHUBtZJfK3IzbyZl C6WXBPTE64Gzg1URDzQUXCrD8YkAPZS7mmjpmAAiuhhheJUE4dGVcn6e9XW87ogLVz0Ya4rqHwB8WfXTHS W0hRW7yEdr2bQNjlTwnXvNhMv9NZ092pq1ws7lu DYqLV8i6fc

Men and Women

Screenshot 2024 03 21 124540Screenshot 2024 03 21 124540

This year, instead of using average salary figures, we used the median figures to lessen the impact of outliers in the salary data. As a result, the gap between salaries for men and women is even more glaring than it was previously.

In last year’s report, men earned an average of 24% more than women. This year the median salary of men is 35% more than the median salary of women. That is until you get to the upper echelons. Women at director and up earned 5% more than men.

Methodology

The 2024 MarTech Salary and Career Survey is a joint project of MarTech.org and chiefmartec.com. We surveyed 305 marketers between December 2023 and February 2024; 297 of those provided salary information. Nearly 63% (191) of respondents live in North America; 16% (50) live in Western Europe. The conclusions in this report are limited to responses from those individuals only. Other regions were excluded due to the limited number of respondents. 

Advertisement

Download your copy of the 2024 MarTech Salary and Career Survey here. No registration is required.

Get MarTech! Daily. Free. In your inbox.

Source link

Advertisement
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

Follow by Email
RSS