Spreadsheet: 731754d1620564066-formula-for-creating-number-combinations-from-two-tables-combining-numbers-adding-green-ones-ans
Sheet: combining numbers

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 1 without copies of numbers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st combination out of SETS |  |  |  |  |  |  |  | Identical numbers with 2nd combination plus
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GREEN numbers:     ONLY appear in Tab. 1 |  |  |  |  |  | Identical numbers with those in Table 2
 |  |  |  |  |  |  |  |  |  |  |  |  | SET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SET | Assigned NUMBERS |  |  |  |  |  |  | green ([NAME]. 1)
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 12 | 24 | 38 | 45 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 28 | 31 | 33 | 49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 9 | 10 | 19 | 20 | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 3 |  | 26 | 29 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 11 | 14 |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 23 |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 37 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 6 |  | 15 |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 40 |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 1 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 2 | 21 |  | 39 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 25 | 32 | 42 | 47
 |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 without copies of numbers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd combination out of SETS |  |  |  |  |  |  |  | Identical  numbers with 1st combination plus
 |  |  |  |  |  |  |  |  |  |  |  |  |  | GREEN numbers:     ONLY appear in [NAME]. 2 |  |  |  |  |  | Identical numbers with those in Table 1
 |  |  |  |  |  |  |  |  |  |  |  |  | SET |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SET | Assigned NUMBERS |  |  |  |  |  |  | green ([NAME]. 2)
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 8 | 23 | 24 | 39 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 12 | 14 | 18 | 38 | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 19 | 31 | 32 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 25 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 | 17 | 27 | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5 | 6 | 13 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1 |  | 26 |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 34 | 37 | 43 | 48
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 9 | 11 |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 10 |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 28 |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | 15