List of duplicates needed

[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

 

[JE McGimpsey]

See

http://cpearson.com/excel/duplicat.htm

 

[Myrna Larson]

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","")

 

[lindy51]

I have used his formula
=IF(COUNTIF(Range1,???)>1,"Duplicate","")
and I have never been able to get it to work.

 

[JE McGimpsey]

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 ??? ?