J
Jman
: I need a macro that counts duplicates names only.
Bill Gates
Bill Gates
Chris Max
Chris Max
Chris Max
I want the end result to be = 2 repeats.
I have used this formula and it works well until after 1000 cells down it
causes excel to freeze.
John Doe=SUMPRODUCT((A1:A65530<>"")/COUNTIF(A1:A65530,A1:A65530&""))-SUMPRODUCT(--(COUNTIF(A1:A65530,A1:A65530)=1))
Bill Gates
Bill Gates
Chris Max
Chris Max
Chris Max
I want the end result to be = 2 repeats.