Identify MAX Date for each employee

Ronald Anderson

I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that?

The unique identifier is the Emp Id.

FMLA_ Modified Duty.xlsx

Nick Korna

Hi @Ronald Anderson,

You can absolutely do this:

=IF(MAX(COLLECT([Leave End]:[Leave End], [Emp ID]:[Emp ID], [Emp ID]@row)) = [Leave End]@row, 1, 0)

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

Nick Korna

Hi @Ronald Anderson,

You can absolutely do this:

=IF(MAX(COLLECT([Leave End]:[Leave End], [Emp ID]:[Emp ID], [Emp ID]@row)) = [Leave End]@row, 1, 0)

Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!

Ronald Anderson

Works perfectly!

Thank you.