Formula for multiple MAX date conditions
Hi,
I'm trying to create a formula that looks at the MAX date and of the MAX dates it finds (because there could be multiple entries with that date), look at the row with the MAX #'s associated with those MAX dates to check a box. I came up with this and I'm getting an Invalid error
=IF(AND(MAX([Date Only]:[Date Only]), MAX([Text #]:[Text #])), 1, 0)
Thanks in advance!
Answers
-
What about using a modified date column? When you use a MAX formula on that it will also compare the time so if they're the same date it will go with the result that's the most recent time of that day.
-
The problem with Modified Date is it updates ALL the rows when you save the sheet so it turns all the rows to the same modified date/time. I'm using it and copying it to another sheet and locking it when it's added. I've also separated the date and the time because when I do the max of the modified date, it things ALL of them are the most recent if they there are multiple rows with the same date.
-
Sorry I meant to say when I don't separate the date and time, it won't look at them separately and checks all the rows with the same dates.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!