"Jman" wrote: I need a macro that counts duplicates names only.

I have used this formula and it works well until after 1000 cells down it
causes excel to freeze.

=SUMPRODUCT((A1:A65530<"")/COUNTIF(A1:A65530,A1:A65530&""))-SUMPRODUCT(--(COUNTIF(A1:A65530,A1:A65530)=1))

John Doe
Bill Gates
Bill Gates
Chris Max
Chris Max
Chris Max

I want the end result to be = 2 repeats.


Is there a macro that does the same thing?