Count number of unique values based on criteria in other rows

[arjun0405]

Hey Guys,

I am new to writing formula. Can you guys help me with the below problem? Thanks.
I want to write a formula in separate cells, where it shows the unique values of column A when a criteria is selected in Column B.
Eg.
Cell 1: good: 3 (101,101,103,103,105)
Cell2: bad: 3 (102,104,101,102)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Order no.[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]good[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]good[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]bad[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]good[/TD]
[/TR]
[TR]
[TD]104[/TD]
[TD]bad[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]good[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]bad[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]bad[/TD]
[/TR]
[TR]
[TD]105[/TD]
[TD]good[/TD]
[/TR]
</tbody>[/TABLE]

 

[nardagus]

Hmmm. It seems you don't want to calculate anyting. Wouldn't Autofilter suffice then?

 

[arjun0405]

my situation is, i need to write a formula instead of using Autofilter.

 

[nardagus]

Hmmm. I won't help you with this... I don't know of a way to concat values into one cell without using UDF (user defined function)...

 

[arjun0405]

Thanks Nard.
I read some posts and it seems that array formula needs to be used.

 

[nardagus]

If you get a formula please post it here. Thx.