Methods to Spotlight Duplicated Cells in Google Sheets

by DS | Jan 25, 2024 | Etcetera | 0 comments

Are you in search of a approach to merely decide reproduction content material subject material on your Google Sheets, particularly in large datasets? Fortunately, there’s a easy approach. By the use of adjusting a few simple settings, you’ll automatically highlight reproduction content material subject material/knowledge on your decided on color. Then, come to a decision whether or not or to not keep or delete the ones duplicates. It’s rather simple.

Proper right here’s the step-by-step knowledge to surroundings it up.

Table of Contents

Highlight Reproduction Knowledge in Google Sheets

Suppose you’ve a spreadsheet with a column of names in Column B and need to pinpoint the duplicates. Instead of manually scanning each and every identify, Google Sheets can automatically highlight them for you.

To concentrate on duplicated knowledge in Column B of Google Sheets, you’ll use Conditional Formatting with a custom designed components.

Proper right here’s the way you’ll do it:

Make a selection the entire Column B by the use of clicking on its header.

Navigate to the menu and make a selection Structure > Conditional formatting.

Inside the “Conditional structure regulations” sidebar at the correct, under the “Structure cells if” dropdown, make a choice “Custom designed components is“.

Input the following components: =countif(B:B, B1)>1. This components calculates how often the cost in each and every cell of Column B turns out in the entire column. If a worth turns out more than once, the formatting you choose it will be applied to those cells.

Make a selection your desired formatting style, like background color, for the reproduction cells, and then click on on “Completed“.

In case you’ve completed the ones steps, any cell in Column B with a worth that appears more than once somewhere else throughout the column it will be highlighted throughout the style you made a decision on.

Every other Simple Way…

There’s however each and every different simple approach to spot duplicated knowledge. Merely hover over a cell in column B, click on on on the arrow, and make a selection to sort the entire column each A-Z or Z-A alphabetically.

Once sorted, any duplicated knowledge, if supply, it will be grouped together. Then again, without highlighting, this however requires slightly of visual scanning to identify the duplicates.

Come throughout and Delete Reproduction Knowledge

If your primary purpose is simply to return throughout and delete all reproduction knowledge, without the need for highlighting, follow the ones steps.

First, make a selection or highlight Column B. Then, navigate all the way through the menu: move to Knowledge > Knowledge cleanup > Remove duplicates.