Searching for duplicates (#2)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
THANK YOU SO MUCH!!!
That worked great!

Patti said:
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.
Click to expand...
 
Back
Top