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)

Order no.	Status
101	good
101	good
102	bad
103	good
104	bad
103	good
101	bad
102	bad
105	good

<tbody>
</tbody>

 

[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.