Need help with a formula
=IF([Pay Period Ending Date (PPE)]@row = MAX(COLLECT([Pay Period Ending Date (PPE)]:[Pay Period Ending Date (PPE)], Department:Department, =Department@row)), 1)
Right now this is checking the flag in 2 rows that have the same date in the column Pay Period Ending Date (PPE). I have another column called [Created] that captures the date and time. I would like to include this in the formula so in this case when it finds 2 that are the same, then it will select the one that is the newest or most recent in the [Created] column. To put it another way, I need the max from above and then the max from the subset. Any suggestions? It needs to be integrated into the current formula because of the additional logic on the spreadsheet and the way data is being collected so I cannot just tell it to look at created date alone.
Help Article Resources
Check out the Formula Handbook template!