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)
<tbody>
</tbody>
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>