I have data about login & logout times by agent. I need to be able to see it by agent name so I can decipher if they came in late, left early, or even logged in that day. I also need to see multiple references if they exist (logged in at 3pm - out at 3:30, in at 3:40), or if they log in on day 1, and log out on day 2 (logged in at 4pm day 1, out at 1am day 2)
I've been working with the Index function but I'm not matching against the correct reference, it appears to be matching against the first row and going down - which shows my ignorance with index, small, and row.
=INDEX($A$9:$C$125,MIN(IF($B$9:$B$125=$G$7,ROW($B$9:$B$125)),ROW(1:1)),1)
I am assuming that is because the actual data I want to match is in row 13, and i'm starting at 1, but thought it would start the match by the agent name.
Bookmarks