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 .
kindly help on this
For this, you should use vlookup or offset. Please attach your excel sheet so that i can help your better.
i checked, there is no option to attach your worksheet so please mention the value with column name