Methods to Spotlight Duplicated Cells in Google Sheets

Are you on the lookout for a strategy to simply determine replica content material for your Google Sheets, specifically in massive datasets? Thankfully, there’s a simple method. By means of adjusting a couple of easy settings, you’ll robotically spotlight replica content material/information for your selected colour. Then, make a decision whether or not to stay or delete those duplicates. It’s slightly easy.

Right here’s the step by step information to atmosphere it up.

Spotlight Replica Information in Google Sheets

Assume you’ve a spreadsheet with a column of names in Column B and want to pinpoint the duplicates. As an alternative of manually scanning every title, Google Sheets can robotically spotlight them for you.

To focus on duplicated information in Column B of Google Sheets, you’ll use Conditional Formatting with a customized formulation.

Right here’s how you’ll do it:

Choose all the Column B by means of clicking on its header.

Navigate to the menu and make a choice Layout > Conditional formatting.

Within the “Conditional layout laws” sidebar at the proper, below the “Layout cells if” dropdown, select “Customized formulation is“.

Enter the next formulation: =countif(B:B, B1)>1. This formulation calculates how steadily the price in every cellular of Column B seems in all the column. If a price seems greater than as soon as, the formatting you select will probably be implemented to these cells.

Choose your required formatting taste, like background colour, for the replica cells, after which click on “Finished“.

If you’ve finished those steps, any cellular in Column B with a price that looks greater than as soon as in different places within the column will probably be highlighted within the taste you decided on.

Any other Easy Approach…

There’s but every other easy strategy to spot duplicated information. Simply hover over a cellular in column B, click on at the arrow, and make a choice to type all the column both A-Z or Z-A alphabetically.

As soon as looked after, any duplicated information, if provide, will probably be grouped in combination. Alternatively, with out highlighting, this nonetheless calls for somewhat of visible scanning to spot the duplicates.

Come across and Delete Replica Information

In case your number one objective is just to come across and delete all replica information, with out the desire for highlighting, observe those steps.

First, make a choice or spotlight Column B. Then, navigate throughout the menu: cross to Information > Information cleanup > Take away duplicates.