Return latest result for work schedule

[FRIED0101]

Hey All.

I have a formula which I use for updating work schedule for our employees, it identifies when someone has put in either planned or unplanned leave.
This works well if the entry only appears once, but if they applied for leave and decided not take that leave and return to work the formula isn't smart enough and ignores the latest entry for that same day/person.


Here is my formula that I use.

=IF(OR(O$9="",O$9<44564,$B13=""),"",IFERROR(INDEX(Leave_Type,MATCH(O$9&" "&$B13,Leave_Outcome,0)),MID($C13,MOD(DAYS(O$9,44564),LEN($C13))+1,1)))


Also see attached spreadsheet for reference.


Any adjustments that would work would be greatly appreciated.



Many Thanks
Danny

[Aussiebear]

Firstly, your post doesn't really explain what you are doing, so please re submit your question. Have a good think about what it is that you are requesting and imagine it from our perspective. You refer to a formula that you use but don't indicate cell/s this formula resides in.