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.