Forum Discussion
Creating sports wrist play call sheet arm band
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.
ingizmo , looking up colors is difficult (It is possible by using macros, but a bit complicated so i am avoiding it).
For looking up values in a column, Mr. mtarler has already given a solution.
There is a middle solution which i propose which looks up colors as well - if it suits your purpose.
(Well in reality, it actually masks the colors of "not found" cells to white, but the effect is same). However, the compromise is that this implementation doesn't arrange the results for one pitch in one column, but rather it arranges it in a rectangular grid same as original.
See attached File and press [F9] to generate new combinations.
The next question is what/how/why are you making colors? So are all F1 have the same color? or is it like amit did above with a random array of colors?
So depending on the answer, another option is to assign colors using conditional formatting and depending on how the formula is designed use that same formula to assign the same coloring for the 'matching' cell (easy if all 'F1' are green, ... , and harder if based on row/column since additional column/row would be needed to identify what row/col the look-up value came from.)
- I use the colors as another way to call a pitch. I use the color and the left column. So in your example above in the latest response, I could say '10, 0' or 'Pink 0' to call the upper left pitch 'C2'. Each color is unique to a pitch. I don't use the same pitch in the same cell two games in a row so I am always changing them, I appreciate your time and really appreciate your help!
