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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eán" wrote:

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

Please and thank you.