ExcelBanter - Need Macro to count repeat clients

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need Macro to count repeat clients (https://www.excelbanter.com/excel-discussion-misc-queries/181486-need-macro-count-repeat-clients.html)

Jman

Need Macro to count repeat clients

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.

All times are GMT +1. The time now is 10:44 AM.