Search for duplicate entries in a column of numbers

[Eán]

What is the easiest formula to use when looking for duplicates in a column?

Please and thank you.

 

[Shane Devenshire]

Hi,

Something like

=COUNTIF(A$1:A$100,A1)

Copy this down, anytime the value is greater than 1 you have a duplicate.
Apply an autofilter to this formula column for greater than 1.

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/Duplicates.aspx