Forum Discussion

Danger_SF's avatar
Danger_SF
Brass Contributor
Jan 04, 2022
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 does that in a worksheet with 28,000 rows and 400 different names. Keep in mind, I don't want the formula to pay any attention to the time that is built in to the date format. Just the date itself.

 

Can this be done?

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jan 04, 2022

    Danger_SF 

    =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.

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jan 04, 2022

    Danger_SF 

    =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.

Resources