Formula to return count of unique values in one column, for each different value in another column

[aldousjg]

Hi all,

I'm having trouble with a formula which needs to return a count of unique names found in one column for each unique combination of number and date found in two other columns. Hopefully this example explains it a bit better:

So for the combination of 123 and 01/01/2000, there is one unique name in the Names column and a value of 1 is returned, but for the combination of 456 and 03/03/2000, there are three unique names in the names column and a value of 3 is returned.

My actual dataset is a few thousand rows and I would now be able to specify actual values of number or date in a formula.

Could anyone help?

Thank you,

 

[maabadi]

You Can Use Countifs that have multiple criteria range and Criteria for each Range.

 

[mart37]

count unique items with 2 conditions.xlsx
	D
2	2
Blad1

Cell Formulas
Range	Formula
D2	D2	=SUM(IF(--FREQUENCY(IF(($A$2:$A$16&"|"&$B$2:$B$16=A2:A2&"|"&B2:B2),MATCH($C$2:$C$16,$C$2:$C$16,0)),IF(($A$2:$A$16&"|"&$B$2:$B$16=A2:A2&"|"&B2:B2),MATCH($C$2:$C$16,$C$2:$C$16,0)))>0,1))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

Another option

=ROWS(UNIQUE(FILTER($C$2:$C$1000,($A$2:$A$1000=A2)*($B$2:$B$1000=B2))))