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.
In C2:
=COUNT(UNIQUE(FILTER($A$2:$A$781, $B$2:$B$781=B2)))
Fill down.
Thanks Hans.
Can you help with formulas for the two orange cells on the attached please?