Ashhu
Active Member
Hello
I am trying to fetch Entry and Exit time details of particular person. I am able to fetch the Entry details without any issue using Index and Match by considering the multiple conditions namely, Name and Date. But the problem I am facing is to fetch Exit or last entry made by person. I am unable to face do match of last event logged.
Please see attached sheet. I have log sheet from B2:D20, I will manually pick name in cell C24 and Date in C25, I am am able to fetch the IN details in cell C27 but last entered details in cell C28 is not able to fetch. Please guide and help.
I am trying to fetch Entry and Exit time details of particular person. I am able to fetch the Entry details without any issue using Index and Match by considering the multiple conditions namely, Name and Date. But the problem I am facing is to fetch Exit or last entry made by person. I am unable to face do match of last event logged.
Please see attached sheet. I have log sheet from B2:D20, I will manually pick name in cell C24 and Date in C25, I am am able to fetch the IN details in cell C27 but last entered details in cell C28 is not able to fetch. Please guide and help.