Search for duplicate entries in a column of numbers
 

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

Please and thank you.

Search for duplicate entries in a column of numbers
 

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.

Search for duplicate entries in a column of numbers
 

See:

http://www.cpearson.com/excel/Duplicates.aspx
--
Gary''s Student - gsnu200839


"Eán" wrote:

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

Please and thank you.