corresponding value for specific cells

  1. Walter18
    Walter18
    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 .
  2. Walter18
    Walter18
    kindly help on this
  3. shivya
    shivya
    For this, you should use vlookup or offset.

    Please attach your excel sheet so that i can help your better.
  4. shivya
    shivya
    i checked, there is no option to attach your worksheet so please mention the value with column name
Results 1 to 4 of 4

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1