How do i locate/highlight duplicates ?

L

Lizardking

I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks
 
B

Bob Phillips

Well show us what it is and explain what happens.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
G

Gareth - Network analyst.

Lizardking said:
I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a
conditional format for this purpose but for some reason it doesn't work.

Any help would be much appreciated.

Thanks
Click to expand...


Assuming the column A is the First column you wanna highlight items.

Select the column.
Then goto your conditional formatting.
Change the Cell Value is to Formula is and type in the following

=IF(COUNTIF($A:$A, A1)>1,TRUE,FALSE)

Then select the format buttom then Pattern and select your color.
then ok
and Bingo you got the Duplicated Values highlighted :p Hope this helps you
out...

just change the A to the letter of the column your working with...
 
Top