how many duplicates do i have?

[bmwbuyer2007]

Hello,

Back again with another one for you,

I have information in column o from 2:65505 with loads of numbers, is there a formula which can tell how many of these numbers are duplicates please ?

Thanks all,

looking forward to your responses...

 

[SteveO59L]

Use a Pivot table to summarise them

 

[Richard Schollar]

Perhaps:

=COUNTA(O2:O65505)-SUMPRODUCT((O2:O65505<>"")/COUNTIF(O2:O65505,O2:O65505&""))

 

[bmwbuyer2007]

Thanks Rich, works a treat mate !