Lookup Which Players In Game During Time Stamped Event

Louren

New Member
Joined
Sep 25, 2014
Messages
15
After much searching on this forum, I have decided to post and hope someone is able to help. I have players' shifts tagged, with a start time and an end time.

StartDurationEnd
GRETZKY1020010EVH20:0000:1019:50
SAKIC1020010EVH20:0000:1019:50
YZERMAN1020010EVH20:0000:1019:50
LEMIEUX1020014EVH20:0000:1419:46
MESSIER1020014EVH20:0000:1419:46
ROY10200305EVH20:0005:0514:55

<colgroup><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>

And then I have events during the game with time stamped data.

119:51SHFor19:511951
119:33SHPenalty19:331933
119:26SHFor19:261926
119:04SHPenalty19:04194
118:53SHAgainst18:531853
118:46SHPenalty18:461846

<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>

Ideally, next to the time stamped event, I want it to return the 6 players that were in the game when that event happened. In the actual file there will be many more players with their shifts tagged than the five I used for an example there.

Hope someone can help, thanks!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,109,380
Messages
5,528,357
Members
409,817
Latest member
JiNXX9500

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top