How do I find the duplicates in a column of data? Boy I'd
love to know.
thanks

Greg

one way is to use conditional formatting. Assume you want to check column
C. Select the whole column and choose Format | Conditional Formatting ...

Change the Condition to "Formula is" and enter: =COUNTIF(C:C,C1)>1 into the
box. Change the font or the background to a suitable highlight colour and
press OK.

Wherever/whenever you have a duplicate entry it will change colour

Regards

Trevor


"greg" <(E-Mail Removed)> wrote in message
news:106101c3fb65$278df7f0$(E-Mail Removed)...
> How do I find the duplicates in a column of data? Boy I'd
> love to know.
> thanks

Hi
have a look at
http://www.cpearson.com/excel/duplic...tingDuplicates
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

greg wrote:
> How do I find the duplicates in a column of data? Boy I'd
> love to know.
> thanks