Identifying duplicates in a column

J

jer101

Is there a feature in Excel that identifies duplicate numbers in
column? I have a worksheet with about 1200 lines of data, and I nee
to identify all lines with duplicates in, for example, column C . Ho
would I do that
 
D

Domenic

jer101 said:
*Is there a feature in Excel that identifies duplicate numbers in
column? I have a worksheet with about 1200 lines of data, and I nee
to identify all lines with duplicates in, for example, column C .
How would I do that? *
Click to expand...

Hi,

You can use a helper column to identify duplicates.

Place the following formula in a column, say D1, and copy down as fa
as you need to:

=IF(COUNTIF($C$1:$C$10,C1)>1,"Duplicate","Not a Duplicate")

Hope this helps
 
Top