About Us

John Black

In article , says...

John Black;1606387 Wrote:
In article ,
says...-

=SUMPRODUCT(1/COUNTIF(A1:A4,A1:A4))-

I don't really get how this works?

John Black

It sum 1 for every single string, 1/2 for every double string, 1/3 for
every triple string, and so on.
So that the sum report the total number of different strings.

Thanks, that's clever. But I found many descriptions of COUNTIF on the web but I still can't
figure out what it means to have the condition field be a range of cells?

John Black

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
remove duplicates	asol	Excel Programming	1	May 5th 10 10:24 PM
How to remove row duplicates	SNAP TO GUIDES DON''T SNAP	Excel Discussion (Misc queries)	1	September 10th 08 10:28 PM
remove duplicates macro ending sub	Susan	Excel Programming	8	September 22nd 06 12:58 PM
remove duplicates	jeff quigley	Excel Programming	1	June 9th 05 03:13 PM