Posted to microsoft.public.excel.misc

external usenet poster

Posts: 110

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Repeat Clients Visits only	Jman	Excel Discussion (Misc queries)	5	March 27th 08 10:53 PM
How to count duplicate or repeat values	Roshlin	Excel Discussion (Misc queries)	12	January 28th 08 10:55 PM
Repeat a Macro	Victoria[_3_]	Excel Worksheet Functions	1	September 25th 07 07:11 PM
Repeat Macro	tvkodde26	Excel Worksheet Functions	5	October 19th 05 07:37 PM
Getting a macro to repeat	Hru48	Excel Discussion (Misc queries)	2	August 18th 05 07:27 PM

All times are GMT +1. The time now is 06:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us