Hola internet excel gurus, need your help again. Here's a simplified
mock-up of the data that got dumped on my lap:

ColA | ColB
Bob | Yes
Bob | Yes
Beth | Yes
Beth | Yes
Beth | Yes

Phil | No
Phil | No
Phil | No
Jane | Pending


I need to count the number of uniques values in Column A who have a
'Yes' in Column B. So in the example above, I'm hoping to get "2" (Bob
Yes, Beth Yes). Note the empty row between Beth and Phil - there are
some empty cells in this data.

I feel like I'm dancing around the correct formula but can't seem to
wrap my head around it correctly. Thanks!