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
Bookmarks