Finding duplicates

[Foss]

Hi there all,

Is there a function I can use to look throught a column of
data for duplicate values?

Cheers,
Foss

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

 

[DDM]

Foss, take a look at Chip Pearson's formula for tagging dupes:
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Foss]

Thanks very much, I can certainly use that to make
something work!

Cheers,
Foss

 

[Foss]

Thanks very much, I can certainly use that to make
something work!

Cheers,
Foss

 

[Bob Phillips]

Put this formula in B1

=IF(COUNTIF($A$1:$A1,a1)>1,"Duplicate","")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)