Forum Discussion
Solved
Creating sports wrist play call sheet arm band
Hi, I coach softball and I am trying to learn how to create a play call sheet for my player's wristbands that they wear during the games. I will signal the play to the catcher and she will relay...
BigWheels8 maybe amit_bhola solution is good enough, that would be great. But for the fun of it I worked out a sheet that might be useful. you can easily print it to both show the grid and the definitions of the numbers/letters and easily change and it guarantees that every possible combination is used at least once (assuming the grid is large enough). File attached.
BigWheels8 , There are formulas like RANDBETWEEN and CONCATENATE which can help. The RANDBETWEEN formula uses numbers, but using HLOOKUP formula, you can return an alphabet. See attached file for sample.
By pressing F9, the values will change to create a new combination.
=CONCATENATE(HLOOKUP(RANDBETWEEN(1,5),$C$4:$G$5,2,FALSE),RANDBETWEEN(1,4))
amit_bhola - thank you for the formula ideas and especially the sample spreadsheet. I am going to play with it and familiarize myself with these formulas.