I need to find the last log OUT time on a certain date for a certain person. This is dues to multiple sign-outs on same day at different times and i want to find the last time. My current formula always returns the first time which is great for the start time but not so good for the end time.
Start times and Finish times are on separate sheets
This is my Formula for the start time
=IFERROR(INDEX(tbl_in[[#All],[Timestamp]],MATCH(1,(tbl_in[/B][[#All],[DATE]]='Times Check'!$AL$1)*(tbl_in[[#All],[1st Initial/Last Name]]='Times Check'!$A3),0)),"")
This is my formula for finish time
=IFERROR(INDEX(tble_out[[#All],[Timestamp]],MATCH(1,(tble_out[[#All],[DATE]]='Times Check'!$AL$1)*(tble_out[[#All],[1st Initial/Last Name]]='Times Check'!$A3),0)),"")
Where
AL = DATE
A3 = persons name.
So, i am matching the date and the person's name at present but as above it always returns the first value where i need it to return the last value on that day for that person.
Snap of the OUT spread sheet.
Screenshot_1.jpg
Any help appreciated
Bookmarks