Forum Discussion
Solved
Counting unique values in two columns
How do I count how many total unique names are associated with a unique date? See attached. I'd like to assign a number in the highlighted cell next to each name, indicating the number of unique ...
In C2:
=COUNT(UNIQUE(FILTER($A$2:$A$781, $B$2:$B$781=B2)))
Fill down.
Thank you, as always.