Need Macro to count repeat clients

J

Jman

I have used this formula and it works well until after 1000 cells down it
causes excel to freeze i guess since it has to check constantly everytime i
enter a new name.

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

Is there a maco that does the same thing.
 
Top