Excel Formula - Lookup Functions - How to Match Data

[ricky82]

Hi All;
I had been trying to get the first login and last logout based on country however i had failed. Was trying to use some combination but looks like doesn't work. Any expertise can help me out here please...Attach is the excel file..

[FDibbins]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[ricky82]

Hi all;
I'm trying to figure out how to obtain matching the country and dates as well login/logout time


- Need to match country to fetch first Start Timestamp & last End Timestamp
- to return value of hh:mm AM/PM only from the matching.


Was trying to use this below but cant seems to get the last logout time. However my earlier data has time only but now its combined date and time...


{=IFERROR(IF($G13="OD","OD",IF($G13="RD","RD",IF($G13="Leave","Leave",IF($G13="","",INDEX('Login Data'!$F:$F,MATCH(1,(TRIM('Login Data'!$A:$A)=TRIM($C13))*('Login Data'!$E:$E=$G$2),0)))))),"")}