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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,114,068
Messages
5,545,798
Members
410,708
Latest member
SanTrapGamer
Top