Results 1 to 5 of 5

Using the Index and Match Functions with a Like Function

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Texas, San Antonio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Using the Index and Match Functions with a Like Function

    Hello all,

    What I am trying to do is use a index, match and like to help me find a reps break and lunch. A rep has 2 breaks of 15 minutes and a lunch of 30 minutes. I know that a reps time will not always be exactly 15 or 30 minutes. So what I did was build a field which finds the difference in time for me to use as a reference. What I want to do is have 2 cells where I can enter my time range and build three index, match, like functions to help me find the Reps log in, log out and the date. The problem is i am not having any success with my attempts.

    Attached is my worksheet:

    Thanks
    Attached Files Attached Files
    Last edited by Coldsteel; 07-14-2010 at 08:30 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1