Posted to microsoft.public.excel.misc

external usenet poster

Posts: 110

I need a macro instead of a formula.

"Jman" wrote: I need a macro that counts duplicates names only.

I have used this formula and it works well until after 1000 cells down it
causes excel to freeze.

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

John Doe
Bill Gates
Bill Gates
Chris Max
Chris Max
Chris Max

I want the end result to be = 2 repeats.

Is there a macro that does the same thing?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Formula or Macro	Meadowlark	Excel Discussion (Misc queries)	5	February 27th 08 03:59 PM
Formula or Macro	M Hebert	Excel Discussion (Misc queries)	2	June 27th 07 01:24 PM
Need formula or Macro Help	Atomic	Excel Worksheet Functions	1	April 26th 07 05:38 PM
Macro Formula for Max value	El Bee	Excel Worksheet Functions	4	December 8th 06 04:08 PM
Formula / Macro Help	BSLAUTOMATION	Excel Discussion (Misc queries)	3	August 31st 05 08:09 PM

All times are GMT +1. The time now is 09:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us