Find duplicates

[gronnies]

I'm having difficulties finding a way to locate duplicates in a particular column. I have Excel 2003. Any help is greatly appreciated!

[NBVC]

You want to highlight dupes?

Is so, select the column and go to Format|Conditional Formatting..

Select Formula Is and enter formula:

=COUNTIF($A$1:$A$100,$A1)>1 where A1:A100 is the column Range selected.

Click Format and choose from the Pattern tab.

If you just want a formula... you can put that same formula in a new column, say B2 and copy down.. TRUE means it is a value that is duplicated.

If you want to only id the duplicates and not the first occurance, then formula would be: =COUNTIF(A$1:A1,A1)>1 copied down.

[gronnies]

Thanks a million!!!

[darkyam]

One last option if you're trying to get rid of dupes is to highlight the list, go to Advanced Filter, select Unique records only, then either filter in place or send the unique values list to a new location.

[NBVC]

or if you used formula: =COUNTIF(A$1:A1,A1)>1

Data|Filter|Autofilter and filter for TRUE

Then delete those rows!