Count duplicates in a column of numbers

A

Alain Dekker

Hi,

Is there any Excel function that will highlight/count any duplicates in a
long column of numbers?

I've got a long list (300 odd) that I belive to all be unique numbers, and
I'd like to know if they really are all unique. Whats' the best way?

Thanks,
Alain
 
R

Ron Rosenfeld

Hi,

Is there any Excel function that will highlight/count any duplicates in a
long column of numbers?

I've got a long list (300 odd) that I belive to all be unique numbers, and
I'd like to know if they really are all unique. Whats' the best way?

Thanks,
Alain
Click to expand...


=sum(if(frequency(match(A1:A300,A1:A300,0)match(A1:A300,A1:A300,0))>0,1))

Or download Laurent Longre's morefunc.xll and use his COUNTDIFF function.

http://longre.free.fr/english/


--ron
 
Top