I apologize if this has been covered, I tried searching and did not find anything.
I have a spreadsheet where column B is a four digit number and column H are different dates. What I'm trying to do is count all dates that are 90 days in the past and greater, but only for the unique numbers in column B.
The two pieces of code that I currently have are:
=COUNTIF(H3:H1000,"<="&TODAY()-90)
=SUM(IF(FREQUENCY(B3:B1000, B3:B1000)>0,1))
I just need a way to combine the two so it only counts column H if column B is a unique number. Any help with this would be greatly appreciated!
Bookmarks