Counts unique values based on 2 criteria in other columns (200.000 records)

Posted to microsoft.public.excel.programming

JS SL

external usenet poster

Posts: 49

Counts unique values based on 2 criteria in other columns(200.000 records)

Claus,

Thx.
I found the issue. I've got two brothers in de list in column N.
The names in the list are written as 'last name, first name'.
I'd skipped one of them and then it works.
In future I will set another letter in front of one of them.

regards, Johan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode 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
Sum unique values based on criteria	yshridhar	Excel Worksheet Functions	4	April 29th 08 05:29 AM
Count Unique records based on the Criteria in another colum	Rajat	Excel Worksheet Functions	1	December 1st 06 12:46 AM
Count Unique records based on the Criteria in another colum	Rajat	Excel Worksheet Functions	0	November 30th 06 03:43 AM
Count Unique records based on the Criteria in another colum	Ron Coderre	Excel Worksheet Functions	0	November 29th 06 06:28 PM
how to count unique values in excel based on criteria	Jorge	Excel Worksheet Functions	2	April 13th 05 02:56 PM

All times are GMT +1. The time now is 04:30 AM.

Menu

About Us