List of duplicates needed

  • Thread starter Thread starter Will Fleenor
  • Start date Start date
W

Will Fleenor

I have 120 numbers in cells c1:c120. There are some duplicates in the list.
How can I get a list of the duplicates?

Thanks,
Will Fleenor
 
In column D, put this formula

=IF(COUNTIF($C$1:$C1,$C1)=1,"","X")

and copy down through D120.

For the first occurrence, the cell will appear blank. For later duplicates,
you see an X; e.g. if the same value appears in C10 and C100, D10 will look
blank and D100 will contain an X.

If you want to flag ALL duplicates (i.e. an X in both D10 and D100 in the
above example)

=IF(COUNTIF($C$1:$C$120,$C1)>1,"X","")
 
I have used his formula
=IF(COUNTIF(Range1,???)>1,"Duplicate","")
and I have never been able to get it to work.
 
What exactly does "have never been able to get it to work" mean? Wrong
results? No results? Errors?

What have you substituted for Range1 and ??? ?
 
Back
Top