To find duplicates in XL sheet?

I

Ina Andersson

After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?
 
M

Mike H

Hi

Select your data (in this example A1 - A100) then click

Format|conditional format
select formula is
enter this formula
=COUNTIF($A$1:$A$100,A1)>1
Pick a colour and duplicates will be hughlighted.

Mike
 
Top