Locate Duplicates

G

Gary

Hi,

I have a list of names in a column, i want to check if there are any names
repeated. What would be the best way to do it?

Thanks
Gary
 
G

Gary''s Student

Use Conditional Formatting:

Let's say your data is in column F. Set Conditional format for F1 to
Formula is:
=COUNTIF(F:F,F1)>1 and pick a distinctive background color. Then copy the
format down the column.

Duplicates will then standout.
 
Top