Searching for duplicates (#2)

[Guest]

Thanks for the link to the website below. I have been trying to follow the
instructions on how to highlight duplicate entries but it is not working.
The instructions say to highlight the range and then select conditional
formatting. Change option to "Formula Is" and enter the following formula:
=IF(COUNTIF(Range1, A5)>1,TRUE,FALSE)
I selected a green fill for the cells that are duplicates but it is not
working. (I entered the first two rows as the same that way I can make sure I
did it correctly.)
Can someone please walk me through this?



Hi
see:
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates

 

[Patti]

This is the formula I use:

=countif($A$1:$A$50,A1)>1

where your range is the $A$1:$A$50 and the first cell is
the A1.

 

[Guest]

THANK YOU SO MUCH!!!
That worked great!

This is the formula I use:

=countif($A$1:$A$50,A1)>1

where your range is the $A$1:$A$50 and the first cell is
the A1.