Show only records for selected value from multiple columns

Y

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
59
Hi,

Firstly, let me say that I am very grateful for the support that has been provided from these forums over the time I have been around. I have a long way to go in understanding Excel, but the help that has been provided has been wonderful, and has helped me learn.

This is my last challenge for my referee statistics workbook. The aim is to be able to create a list of games for a selected referee, by formula. The result will be printed and handed to the person requesting the results.

I want to select all games refereed for a selected referee from up to 6 "games slots"

Consider this source data:

Code: 
[TABLE="width: 1316"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]Slot 1[/TD]
[TD="colspan: 4"]Slot 2[/TD]
[TD="colspan: 4"]Slot 3[/TD]
[TD="colspan: 4"]Slot 4[/TD]
[TD="colspan: 4"]Slot 5[/TD]
[TD="colspan: 4"]Slot 6[/TD]
[TD]Game[/TD]
[TD][/TD]
[TD][/TD]
[TD]My[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]DOW[/TD]
[TD]Game Date[/TD]
[TD]Sess[/TD]
[TD]Venue[/TD]
[TD]Gndr[/TD]
[TD]Pattern[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Type[/TD]
[TD]Injury[/TD]
[TD]Eval[/TD]
[TD]Grade[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6/06/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GBGGGG[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]19[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD]18[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]21[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9/06/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]NGBGG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]22[/TD]
[TD]B[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]20[/TD]
[TD]B[/TD]
[TD]13[/TD]
[TD]5[/TD]
[TD]31[/TD]
[TD]AR[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]13/06/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GBBGGG[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]CR[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]BR[/TD]
[TD]16[/TD]
[TD]6[/TD]
[TD]19[/TD]
[TD]C[/TD]
[TD]18[/TD]
[TD]RS[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]16/06/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]BBGGG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]33[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]20[/TD]
[TD]C[/TD]
[TD]14[/TD]
[TD]5[/TD]
[TD]26[/TD]
[TD]AR[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]20/06/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GBGGBG[/TD]
[TD]2[/TD]
[TD]42[/TD]
[TD]C[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD]18[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]23/06/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]BGGGB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]20[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]22[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]21[/TD]
[TD]BR[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]27/06/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGBBGG[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD]39[/TD]
[TD]C[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]18[/TD]
[TD]6[/TD]
[TD]37[/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]30/06/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GGBGB[/TD]
[TD]2[/TD]
[TD]22[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]1[/TD]
[TD]20[/TD]
[TD]BR[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]22[/TD]
[TD]C[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]14/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]BGGGB[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]25[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]21[/TD]
[TD]B[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]20[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]17/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NGG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]A[/TD]
[TD]10[/TD]
[TD]2[/TD]
[TD]26[/TD]
[TD]C[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]18/07/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GBGGBW[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]16[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]21/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GBGGB[/TD]
[TD]4[/TD]
[TD]20[/TD]
[TD]B[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]22[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]AR[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]24/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]25/07/2012[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SF[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]25/07/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGWBB[/TD]
[TD]4[/TD]
[TD]39[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]6[/TD]
[TD]44[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD]16[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]28/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GGBBB[/TD]
[TD]1[/TD]
[TD]25[/TD]
[TD]C[/TD]
[TD]11[/TD]
[TD]3[/TD]
[TD]22[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]31/07/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1/08/2012[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GF[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1/08/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGBBB[/TD]
[TD]3[/TD]
[TD]41[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]19[/TD]
[TD]C[/TD]
[TD]14[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]SSSSS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]22[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8/08/2012[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]GGN[/TD]
[TD]4[/TD]
[TD]36[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD]6[/TD]
[TD]10[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8/08/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGBBB[/TD]
[TD]3[/TD]
[TD]41[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]19[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]BGBGG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]20[/TD]
[TD]C[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]22[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]BR[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]14/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15/08/2012[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]GGN[/TD]
[TD]4[/TD]
[TD]13[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15/08/2012[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGNNN[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD]4[/TD]
[TD]30[/TD]
[TD]C[/TD]
[TD]12[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]18/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]BGBGG[/TD]
[TD]3[/TD]
[TD]20[/TD]
[TD]C[/TD]
[TD]10[/TD]
[TD]3[/TD]
[TD]21[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]3[/TD]
[TD]22[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]21/08/2012[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]NNN[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]22/08/2012[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]GGN[/TD]
[TD]4[/TD]
[TD]36[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD]5[/TD]
[TD]13[/TD]
[TD]CR[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]

On a separate sheet I select a referee name, which then grabs the first, last and total games and also the referee number, which is needed to match the above "Ref" column. For Example, I want to list all games refereed with P. Morgan (Ref # 1). I may have refereed more than one game with him in a session (so his ref number will appear in more than one time slot).

This is an example of what the output will look like..

Code: 
[TABLE="width: 845"]
<tbody>[TR]
[TD]Select Referee:[/TD]
[TD="colspan: 3"]P. Morgan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Referee #:[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]First Game:[/TD]
[TD="colspan: 3, align: right"]6/06/2012[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Grade:[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Last Game:[/TD]
[TD="colspan: 3, align: right"]21/08/2013[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ave Games per week:[/TD]
[TD="colspan: 2"]0.57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total Games:[/TD]
[TD][/TD]
[TD="colspan: 2"]36[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Slot 1[/TD]
[TD="colspan: 3"]Slot 2[/TD]
[TD="colspan: 3"]Slot 3[/TD]
[TD="colspan: 3"]Slot 4[/TD]
[TD="colspan: 3"]Slot 5[/TD]
[TD="colspan: 3"]Slot 6[/TD]
[/TR]
[TR]
[TD]Game Date[/TD]
[TD]Venue[/TD]
[TD]Day[/TD]
[TD]Type[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[TD]Age[/TD]
[TD]Gr[/TD]
[TD]Crt[/TD]
[/TR]
[TR]
[TD="align: right"]6/06/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/06/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/06/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]18/07/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]B[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25/07/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11/08/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15/08/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]22/08/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25/08/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/09/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17/10/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]GR[/TD]
[TD]14[/TD]
[TD]CR[/TD]
[TD]4[/TD]
[TD]14[/TD]
[TD]C[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/10/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]GR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/10/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]GR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/11/2012[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14/11/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]28/11/2012[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]A[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]14[/TD]
[TD]B[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2/02/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6/02/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]13/02/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/02/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]14[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]16[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23/02/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/02/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]14[/TD]
[TD]BR[/TD]
[TD]4[/TD]
[TD]16[/TD]
[TD]C[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16/03/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/04/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]GR[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]1[/TD]
[TD]13[/TD]
[TD]C[/TD]
[TD]3[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/05/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4/05/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11/05/2013[/TD]
[TD]O[/TD]
[TD]Sat[/TD]
[TD]RS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]15/05/2013[/TD]
[TD]K[/TD]
[TD]Wed[/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD]12[/TD]
[TD]CR[/TD]
[TD]3[/TD]
[TD]14[/TD]
[TD]C[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Right now I use the following to collect the data, but this does not work.. (Note the 0 0 0 in some slots).

Column A; hidden formula:

Code: 
IF(Games!B5="","",IF(Games!J5=$K$2,ROWS($1:1),
  IF(Games!N5=$K$2,ROWS($1:1),
    IF(Games!R5=$K$2,ROWS($1:1),
      IF(Games!V5=$K$2,ROWS($1:1),
        IF(Games!Z5=$K$2,ROWS($1:1),
          IF(Games!AD5=$K$2,ROWS($1:1),"")
))))))

and to grab the relevant data..

Code: 
IF(ROWS($1:1)>COUNT($A$8:$A$1880),"",
  IF(INDEX(Games!$J:$J,SMALL($A$8:$A$1880,ROWS($1:1))+4)=$K$2,INDEX(Games!L:L,SMALL($A$8:$A$1880,ROWS($1:1))+4),"")
)

Any help is greatly appreciated.

For this spreadsheet, this will hopefully be the last challenge. Sorry for the length of the post.

thanks
Tanya
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
This formula in column A confirmed with Ctrl+Shift+Enter and copied down will return the row numbers that contain the referee in K2:

=IFERROR(SMALL(IF(Games!J$5:J$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1,IF(Games!N$5:N$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1,IF(Games!R$5:R$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1,IF(Games!V$5:V$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1,IF(Games!Z$5:Z$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1,IF(Games!AD$5:AD$34=$K$2,ROW(Games!B$5:B$34)-ROW(Games!B$5)+1)))))),ROWS($1:1)),"")

You can use that as an index into your Games data.
 
Upvote 0
Hi Andrew,

thanks for your reply. Your formula works equally as well as the formula I had previously. They both seemed correct.

However, I found the problem why the game data was incorrect..

An error in the second formula, which you couldn't see because I only posted one.. I foolishly used J$:$J for the column reference for all 6 slots, instead of the relevant column for each slot (So I had J, J, J, J, J, J whereas it should have been J, N, R, V, Z, AD).

A situation of staring at the data too long.. Couldn't see the forest for the trees.

Thanks for your help.
 
Upvote 0
The difference between your formula and mine is that yours leaves gaps in the list, whereas the list returned by mine is contiguous.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
Complex Move data from two spreadsheets with similar data in different columns to a specific column in an existing spreadsheet(Sheet 3)
Replies
0
Views
100
JMC57
J
N
  • Question
Counting specific entries based on various conditions
2
Replies
13
Views
457
Newbienew
N
N
  • Question
Marco, IFS and XLOOKUP but certainly happy to be wrong
Replies
2
Views
122
N0t Y0urs
N
S
  • Solved
Date time to Date conversion
Replies
4
Views
144
Peter_SSs
Peter_SSs
S
  • Solved
need all in the same row if we have a letter
Replies
6
Views
122
MARK858
MARK858

Forum statistics

Threads
1,214,622
Messages
6,120,580
Members
448,972
Latest member
Shantanu2024

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top