Have no idea where to begin.
In column (DIGIT) are values ranging from 1-36; in column (SKIPS) are values that range from 0-XXX
Using the skip values for 5 digits, create the combination that equals a sum, that will be input.
Example combination 2-8-9-10-13 = 2,7,8,0,16= sum 33; each sum will have more than 1 combination.
Excel 2007
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
In column (DIGIT) are values ranging from 1-36; in column (SKIPS) are values that range from 0-XXX
Using the skip values for 5 digits, create the combination that equals a sum, that will be input.
Example combination 2-8-9-10-13 = 2,7,8,0,16= sum 33; each sum will have more than 1 combination.
Excel Workbook | ||||||
---|---|---|---|---|---|---|
T | U | V | W | |||
4 | DIGIT | HIT | SKIPS | SKIPSUMS | ||
5 | 1 | 332 | 5 | 28 | ||
6 | 2 | 317 | 6 | 27 | ||
7 | 3 | 302 | 7 | 34 | ||
8 | 4 | 313 | 0 | 32 | ||
9 | 5 | 271 | 7 | 31 | ||
10 | 6 | 337 | 6 | 25 | ||
11 | 7 | 326 | 3 | 36 | ||
12 | 8 | 285 | 7 | 26 | ||
13 | 9 | 301 | 8 | 35 | ||
14 | 10 | 310 | 0 | 23 | ||
15 | 11 | 305 | 17 | 24 | ||
16 | 12 | 315 | 2 | 30 | ||
17 | 13 | 298 | 16 | 33 | ||
18 | 14 | 307 | 1 | 29 | ||
19 | 15 | 297 | 3 | 37 | ||
20 | 16 | 306 | 6 | 20 | ||
SKIPSUMS |
Cell Formulas | ||
---|---|---|
Range | Formula | |
U5 | =COUNTIF($B$14:$F$2216,$T5) | |
U6 | =COUNTIF($B$14:$F$2216,$T6) | |
U7 | =COUNTIF($B$14:$F$2216,$T7) | |
U8 | =COUNTIF($B$14:$F$2216,$T8) | |
U9 | =COUNTIF($B$14:$F$2216,$T9) | |
U10 | =COUNTIF($B$14:$F$2216,$T10) | |
U11 | =COUNTIF($B$14:$F$2216,$T11) | |
U12 | =COUNTIF($B$14:$F$2216,$T12) | |
U13 | =COUNTIF($B$14:$F$2216,$T13) | |
U14 | =COUNTIF($B$14:$F$2216,$T14) | |
U15 | =COUNTIF($B$14:$F$2216,$T15) | |
U16 | =COUNTIF($B$14:$F$2216,$T16) | |
U17 | =COUNTIF($B$14:$F$2216,$T17) | |
U18 | =COUNTIF($B$14:$F$2216,$T18) | |
U19 | =COUNTIF($B$14:$F$2216,$T19) | |
U20 | =COUNTIF($B$14:$F$2216,$T20) |
#VALUE!
Last edited: