i have a sheet in where in i have the log in time aux codes and log out time - is there any way or any formula that i can use to get the corresponding calue for log in and log out for example - 02-02-2016 11:24 log in 02-02-2016 11:24 aux code 02-02-2016 11:24 aux code 02-02-2016 11:55 aux code 02-02-2016 21:00 log out -i want a formula that if i need the corresponding value for log in and log out instead of using a filter .
Assuming the data starts in row 2 and is in columns A:C the following formula will work: =IF(ISNUMBER(IF(C2="Log In",MATCH("log out",C2:$C$100,0),"")),INDEX(B2:$B$100,IF(C2="Log In",MATCH("log out",C2:$C$100,0),""),1),"") Extend beyond Cell C100 and B100 if you have to.