I have a employee table that shows employee name and last login to the system. Employee can login through computer 1 thru 5. So the data looks like this
NAME COMPUTER1 COMPUTER2 COMPUTER3 COMPUTER4 FIRST LOGIN JOHN Tue Mar 25 08:45:13 PDT 2014 Tue Mar 25 08:45:13 PDT 2014 Tue Mar 25 08:45:13 PDT 2014 Tue Mar 25 08:45:13 PDT 2014 Should show value from cell B2 MARY Tue Mar 25 08:45:13 PDT 2014 Should show value from cell C3 KEVIN Tue Mar 25 08:45:13 PDT 2014 Should show value from cell E4 HANLEY Tue Mar 25 08:45:13 PDT 2014 Tue Mar 25 08:45:13 PDT 2014 Should show value from cell C5 ERIC Tue Mar 25 08:45:13 PDT 2014 Should show value from cell B6
So from the above excel, I want to just pick the first login irrespective of which system. User can login from two systems at a same time, so just like above same timestamp could end up across two different cells.
I am currently using below formula, but its not working when the first timestamp is in column 3, 4 or 5. It's only working when value is in column 1.
=INDEX(B2:E2,MATCH("*",B2:E2,0))
Please help.
Bookmarks