finding duplicates
Posted by tracy on January 28, 2002 8:55 AM
Is there an easy way to find duplicates in a long list of data? I've rigged it, but wonder if there isn't an easier way.
Posted by Mark W. on January 28, 2002 9:16 AM
=COUNTIF($A$2:$A$10,A2)>1 will return TRUE for
any duplicates in cell range, A2:A10.
Posted by Brian on January 28, 2002 6:48 PM
tracy,
try putting the formula as a conditional formatting and set font color to whatever color. All dupes will appear as that color. This tip courtesy of Aaron Blood's web page.
