How would I go about calculating the unique values in Column A based on the criteria that Column B is not blank (any text at all)? In other words, in this example, the formula should output 2.
<tbody>
</tbody>
Any help would be appreciated. Thank you in advance!
Column A | Column B |
1 | No |
2 | Yes |
2 | |
3 |
<tbody>
</tbody>
Any help would be appreciated. Thank you in advance!