Estatefinds
Board Regular
- Joined
- Sep 14, 2015
- Messages
- 169
So I need a macro that will run in which the data in column DC the first digit will be placed for example the number 6 then it will look in the next column labeled row 2 for the next digit higher which would be 13 then I t would look in the next column labeled row3 the next number higher which would be 14, then to the next column labeled row 4, the next number would be 15, then to the next column labeled row 5 the next number higher up would be 24; Until five numbers make up the combination. The combiations will only be made left to right until all possible combinations are resulted in column GC13.
Then it would start at lowest number in column DD for example will start with the number 1 and result all combinations into column GD13.
<tbody>
</tbody>6-13-14-15-24
6-13-26-33-35
and so on
also no number can be used from the same Column meaning a value from row 1 be used with a row 1 value the combinations will be built from smallest value to largest left to right only.
Thank you!
Sincerely Dennis
Then it would start at lowest number in column DD for example will start with the number 1 and result all combinations into column GD13.
6 | 1 | 4 | 2 | 9 | 19 | 5 | 32 | 18 | 7 | 3 | 28 | 31 | 11 | 20 | ||||||||||||||||||||
8 | 13 | 10 | 15 | 24 | 21 | 12 | ||||||||||||||||||||||||||||
17 | 30 | 14 | 16 | 33 | 27 | 22 | ||||||||||||||||||||||||||||
23 | 26 | 25 | 35 | 29 | ||||||||||||||||||||||||||||||
34 | ||||||||||||||||||||||||||||||||||
Row 1 | Row 2 | Row 3 | Row 4 | Row 5 | Row 6 | Row 7 | Row 8 | Row 9 | Row 10 | Row 11 | Row 12 | Row 13 | Row 14 | Row 15 | Row 16 | Row 17 | Row 18 | Row 19 | Row 20 | Row 21 | Row 22 | Row 23 | Row 24 | Row 25 | Row 26 | Row 27 | Row 28 | Row 29 | Row 30 | Row 31 | Row 32 | Row 33 | Row 34 | Row 35 |
<tbody>
</tbody>
6-13-26-33-35
and so on
also no number can be used from the same Column meaning a value from row 1 be used with a row 1 value the combinations will be built from smallest value to largest left to right only.
Thank you!
Sincerely Dennis