Forum Discussion
Solved
Count of unique dates in a column
Good afternoon! See attached. If you manually count the unique DATES in column A associated with the name "John Doe" in column B, you count 17 unique dates. I'm looking for a formula that doe...
=SUM(N(IF(C1:C21=F1,MATCH(IF(C1:C21=F1,D1:D21),IF(C1:C21=F1,D1:D21),)=ROW(1:21))))
Is this what you want to do? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.
=SUM(N(IF(C1:C21=F1,MATCH(IF(C1:C21=F1,D1:D21),IF(C1:C21=F1,D1:D21),)=ROW(1:21))))
Is this what you want to do? Enter formula as arrayformula with ctrl+shift+enter if you don't work with Office365 or 2021.
- Nice job! That worked. Thank you!
