Count duplicates in a column of numbers

[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

 

[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

=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

 

[bsmith]

You can use the advanced filter settings to display unique values only