+ Reply to Thread
Results 1 to 6 of 6

Create chronological starttime timesheet from a schedule that returns name from same row

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    4

    Create chronological starttime timesheet from a schedule that returns name from same row

    I am trying to sort a timesheet from a schedule in chronological order where names are unique but start times are often the same (example below but because of this I couldn't use vlookup). For the timesheet I've used =IFERROR(SMALL(B$3:B$9,1),"") on each line and just changed the k value (in this example 1 to 7) to sort the starts in order. Is there any way to use index to then return the names and end times associated with the start time? There will never be more than 5 start times the same so I did try an index function but it often returned false for me when the schedule changed (names/start times/end times)

    NAME START END
    Tom 12:00 15:00
    Chris 10:00 16:00
    Peter 10:00 14:30
    Jenn 10:00 11:00
    Nolan 10:00 12:00
    Nancy 9:30 12:00
    Alanna 10:00 16:00
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Create chronological starttime timesheet from a schedule that returns name from same r

    Let me know if this is what you were looking for. It seems to update correctly when I change some of the times around.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-19-2014
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    4

    Re: Create chronological starttime timesheet from a schedule that returns name from same r

    Thanks - The time sorts great but what I can't get is the names and end times from the rows to fill. In the example spreadsheet I highlighted in yellow what I need the help with. Vlookup doesn't work when the times are the same (always uses same return name/end time). Somehow I need to index row but given that the starttime column changes I can't seem to get it with any array I'm aware of...

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Create chronological starttime timesheet from a schedule that returns name from same r

    On which sheet? I filled in the yellow cells on Sheet2 (I3:I9 & K3:K9).

  5. #5
    Registered User
    Join Date
    08-19-2014
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    4

    Re: Create chronological starttime timesheet from a schedule that returns name from same r

    Amazing! Thanks

  6. #6
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Create chronological starttime timesheet from a schedule that returns name from same r

    If your request has been satisfied, please mark the thread as "Solved".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. create daily schedule using master task schedule
    By DCO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2012, 01:08 PM
  2. Replies: 1
    Last Post: 11-13-2012, 06:48 AM
  3. Create chronological table from daily updates
    By shockeymoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2011, 11:45 AM
  4. Work Schedule Timesheet
    By Qin in forum Excel General
    Replies: 10
    Last Post: 03-15-2010, 08:19 PM
  5. [SOLVED] Create patient schedule based on master therapist schedule
    By PapaBear in forum Excel General
    Replies: 8
    Last Post: 10-12-2005, 12:05 AM

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