Conting unique values

[kort]

Hello

i whant to cont all the unique values inn column b, where the value in column a = cell d3

please help
kort

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=SUM(IF(FREQUENCY(IF(A2:A100=D3,IF(B2:B100<>"",MATCH("~"&B2:B100,B2:B100&"",0))),ROW(B2:B100)-ROW(B2)+1)>0,1))

 

[T. Valko]

Hello

i whant to cont all the unique values inn column b, where the value in column a = cell d3

please help
kort

Try this array formula**:

=SUM(IF(FREQUENCY(IF(A2:A10=D3,MATCH(B2:B10,B2:B10,0)),ROW(B2:B10)-ROW(B2)+1),1))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Assumes there are no empty cells within the data range of column B.

 

[kort]

THANKS PROBLEM SOLVD