Need formula to count based on a single criteria match in another column, that removes duplicate results in the count

[freeb1893]

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.


[TABLE="class: cms_table_grid"]
<tbody>[TR]
[TD]ow\Col[/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]NAMES[/TD]
[TD]

1000​

[/TD]
[TD]

1001​

[/TD]
[TD]

1001-002​

[/TD]
[TD]

1001-003​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

1001​

[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Bob[/TD]
[TD]

FALSE
​

[/TD]
[TD]

FALSE​

[/TD]
[TD]

TRUE​

[/TD]
[TD]

FALSE​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Bob[/TD]
[TD]

FALSE​

[/TD]
[TD]

FALSE​

[/TD]
[TD]

TRUE​

[/TD]
[TD]

FALSE​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Bob[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Dave[/TD]
[TD]

TRUE​

[/TD]
[TD]

TRUE​

[/TD]
[TD]

TRUE​

[/TD]
[TD]

FALSE​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dave[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Dave[/TD]
[TD]FALSE[/TD]
[TD]

FALSE​

[/TD]
[TD]

FALSE​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alex[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]Alex[/TD]
[TD]

TRUE​

[/TD]
[TD]

FALSE​

[/TD]
[TD]

FALSE​

[/TD]
[TD]

FALSE​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Appreciate any help with this!