count unique values of 2 columns with criteria

**kbalasub** · 02-15-2013, 01:46 AM

Hi Fotis,
Thanks for the solution. But I have some difficulties. The no.of rows running to 10,000 and so it is difficult to copy down. Is there a formula to count the unique values(with text) with multiple criteria?

Bala

**Marcol** · 02-15-2013, 06:52 AM

Originally Posted by kbalasub

Hi Fotis,
... Is there a formula to count the unique values(with text) with multiple criteria?

Bala

Try using Dynamic Names, this workbook uses Fotis' idea, but for 2003, you can use IFERROR() in the formula

Formula:

=IFERROR(INDEX(Tester,SMALL(IF(ISNA(MATCH(Tester,$F$1:F1,0)),IF(Helper=1,ROW(Tester)-ROW($B$2)+1)),1))),"")

Either way these are CSE arrays, and must be confirmed with Ctrl+Shift+Enter not just Enter.

Hopefully this should work for any length your data table might be.

Does this work for you?

[EDIT]
Server to busy ... try again later
More crashes causing errors!
When are the "Tech Wizards" going to stop f***ing about, this has been going on for weeks now.
Can they really be this incontinent, sorry, incompetent? ...