Identifying duplicates in a column

  • Thread starter Thread starter jer101
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates by groups 6
Duplicates Deletion ? 2
Finding Duplicate Cell Entries 6
Duplicate data 2
Identify Duplicates that are not identical 4
Identify Duplicates in a List 1
Identifying duplicate rows 2
duplicate numbers in a column 2

Back
Top