Hello, RAM1950 here and I am a newbie with my first question. Any help is greatly appreciated. The Texas Lottery has
a 5 number game called Cash 5 with numbers 1-35 (324632 permutations) On sheet 2 column A rows are numbered
1- 324632. ROW 1 col. D =1 col. E=2 col. F=3 col. G=4 col. H=5. This goes all the way down to row 324632 where
col. D=31 col. E=32 col. F=33 col. G=34 col. H=35. In sheet 1, I would like to put a row number in R1CA and call up
matching numbers in columns D-H. from sheet 2. Right now I am using the index/match function . I have a scoring system on the
numbers in each column and score will be located R1CJ. I would like to check all permutations and find the best scoring
100 listed. Row numbers would go in column L, row 1-100. The numbers matching column L would go into columns O-S.
Is there a way to automate this? Once again, thank you for any help.
a 5 number game called Cash 5 with numbers 1-35 (324632 permutations) On sheet 2 column A rows are numbered
1- 324632. ROW 1 col. D =1 col. E=2 col. F=3 col. G=4 col. H=5. This goes all the way down to row 324632 where
col. D=31 col. E=32 col. F=33 col. G=34 col. H=35. In sheet 1, I would like to put a row number in R1CA and call up
matching numbers in columns D-H. from sheet 2. Right now I am using the index/match function . I have a scoring system on the
numbers in each column and score will be located R1CJ. I would like to check all permutations and find the best scoring
100 listed. Row numbers would go in column L, row 1-100. The numbers matching column L would go into columns O-S.
Is there a way to automate this? Once again, thank you for any help.