I have the table below. I would like to count the number of unique values in Column A where the value in Column B = "FALSE", while also with the final count, remove duplicates/don't count duplicates.
The result for this would be a count of 2. The counts of Bob and False would only be counted once.
<tbody>
</tbody>
Appreciate any help with this!
The result for this would be a count of 2. The counts of Bob and False would only be counted once.
ow\Col | A | B | C | D | E | F | G | H |
1 | NAMES | 1000 | 1001 | 1001-002 | 1001-003 | 1001 | ||
2 | Bob | FALSE | FALSE | TRUE | FALSE | 3 | ||
3 | Bob | FALSE | FALSE | TRUE | FALSE | Bob | ||
4 | Dave | TRUE | TRUE | TRUE | FALSE | Dave | ||
5 | Dave | FALSE | FALSE | FALSE | Alex | |||
6 | Alex | TRUE | FALSE | FALSE | FALSE |
<tbody>
</tbody>
Appreciate any help with this!
Last edited: