Spreadsheet: 690652d1597223470-combinations-to-ignore-blanks-combination-match-issue-based-on-random-variables-test_file
Sheet: Excercise 1.1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Set 3
 | Table A | [NAME] | [NAME] | [NAME] | [NAME] | G2 | G2 | G2 | G2 | G3 | G3 | G3 |  | Criteria | C1 | C2 | [NAME] | C4 | C5 | C6 |  | Condition |  | Set 1 | Set 2 | Set 3 | Choose | Index |  |  | Data Sets
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | A | C | E | H | H | G |  | A |  | 1 | 2 | 3 |  |  |  |  | 1 | A
 | AA |  |  |  |  |  |  |  |  |  |  |  |  | 2 | E | D | C | H | H | H |  | B |  | 3 | 4 | 5 |  |  |  |  | 2 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | A | A | D | E | F | B |  | C |  | 5 | 6 | 7 |  |  |  |  | 3 | A
 | AB |  |  |  |  |  |  |  |  |  |  |  |  | 4 | B | E | F | F | F | C |  | D |  | 8 | 9 | 10 |  |  |  |  | 4 | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | E | E | B | B | A | A |  | E |  | 9 | 10 | 11 |  |  |  |  | 5 | A
 | AC |  |  |  |  |  |  |  |  |  |  |  |  | 6 | B | E | F | F | F | C |  | F |  | 12 | 12 | 13 |  |  |  |  | 6 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | E | E | B | B | A | A |  | G |  | 13 | 14 | 15 |  |  |  |  | 7 | B
 | AD |  |  |  |  |  |  |  |  |  |  |  |  | 8 | B | E | F | F | F | C |  | H |  | 14 | 15 | 16 |  |  |  |  | 8 | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | E | E | B | B | A | A |  |  |  | 15 |  |  |  |  |  |  | 9 | B
 |  | Table 1 |  |  |  |  |  |  |  |  |  |  |  | 10 | B | E | F | F | F | C |  |  |  | 16 |  |  |  |  |  |  | 10 | B
 |  | C1 | C2 | [NAME] | C4 | C5 | C6 |  |  |  |  |  |  | 11 | E | E | B | B | A | A |  |  |  | 17 |  |  |  |  |  |  | 11 | B
 | Row 1 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | B | E | F | F | F | C |  |  |  | 18 |  |  |  |  |  |  | 12 | C
 | Row 2 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | E | E | B | B | A | A |  |  |  | 20 | 21 | 22 |  |  |  |  | 13 | C
 | Row 3 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | B | E | F | F | F | C |  |  |  | 21 | 22 | 23 |  |  |  |  | 14 | C
 | Row 4 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | E | E | B | B | A | A |  |  |  | 22 | 23 | 24 |  |  |  |  | 15 | C
 | Row 5 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | B | E | F | F | F | C |  |  |  | 35 | 36 | 37 |  |  |  |  | 16 | C
 | Row 6 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | A | B | F | E | F | G |  |  |  | 36 | 37 | 38 |  |  |  |  | 17 | D
 | Row 7 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | A | B | F | E | F | G |  |  |  | 39 | 39 | 40 |  |  |  |  | 18 | D
 | Row 8 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | A | B | F | E | F | G |  |  |  | 42 | 42 | 41 |  |  |  |  | 19 | D
 | Row 9 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | A | B | F | E | F | G |  |  |  | 44 | 43 | 43 |  |  |  |  | 20 | D
 | Row 10 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | A | B | F | E | F | G |  |  |  |  |  |  |  |  |  |  | 21 | D
 | Row 11 |  |  |  |  |  |  |  |  |  |  |  |  | 22 | A | B | F | E | F | G |  |  |  |  |  |  |  |  |  |  | 22 | D
 | Row 12 |  |  |  |  |  |  |  |  |  |  |  |  | 23 | A | B | F | E | F | G |  |  |  |  |  |  |  |  |  |  | 23 | E
 | Row 13 |  |  |  |  |  |  |  |  |  |  |  |  | 24 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 24 | E
 | Row 14 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 25 | E
 | Row 15 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 26 | E
 | Row 16 |  |  |  |  |  |  |  |  |  |  |  |  | 27 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 27 | E
 | Row 17 |  |  |  |  |  |  |  |  |  |  |  |  | 28 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 28 | F
 | Row 18 |  |  |  |  |  |  |  |  |  |  |  |  | 29 | D | C | F | G | H | A |  |  |  |  |  |  |  |  |  |  | 29 | F
 | Row 19 |  |  |  |  |  |  |  |  |  |  |  |  | 30 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 30 | F
 | Row 20 |  |  |  |  |  |  |  |  |  |  |  |  | 31 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 31 | F
 | Row 21 |  |  |  |  |  |  |  |  |  |  |  |  | 32 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 32 | F
 | Row 22 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 33 | F
 | Row 23 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 34 | G
 | Row 24 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | A | C | E | H | H | G |  |  |  |  |  |  |  |  |  |  | 35 | G
 | Row 25 |  |  |  |  |  |  |  |  |  |  |  |  | 36 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 36 | G
 | Row 26 |  |  |  |  |  |  |  |  |  |  |  |  | 37 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 37 | G
 | Row 27 |  |  |  |  |  |  |  |  |  |  |  |  | 38 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 38 | G
 | Row 28 |  |  |  |  |  |  |  |  |  |  |  |  | 39 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 39 | H
 | Row 29 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 40 | H
 | Row 30 |  |  |  |  |  |  |  |  |  |  |  |  | 41 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 41 | H
 | Row 31 |  |  |  |  |  |  |  |  |  |  |  |  | 42 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 42 | H
 | Row 32 |  |  |  |  |  |  |  |  |  |  |  |  | 43 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 43 | H
 | Row 33 |  |  |  |  |  |  |  |  |  |  |  |  | 44 | C | G | H | E | B | B |  |  |  |  |  |  |  |  |  |  | 44 | H
 | Row 34 |  |  |  |  |  |  |  |  |  |  |  |  | 45 | A | C | E | H | H | G
 | Row 35 |  |  |  |  |  |  |  |  |  |  |  |  | 46 | A | C | E | H | H | G
 | Row 36 |  |  |  |  |  |  |  |  |  |  |  |  | 47 | A | C | E | H | H | G
 | Row 37 |  |  |  |  |  |  |  |  |  |  |  |  | 48 | A | C | E | H | H | G
 | Row 38 |  |  |  |  |  |  |  |  |  |  |  |  | 49 | A | C | E | H | H | G
 | Row 39 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | A | C | E | H | H | G
 | Row 40
 | Row 41
 | Row 42
 | Row 43
 | Row 44
 | Row 45
 | Row 46
 | Row 47
 | Row 48
 | Row 49
 | Row 50
 | * Grouped rows fo ease of use
 |  | Fix Errors - Table 2
 |  | 1 | Table 2 rows should use only numbers visible in Table B - Therefore Choose only numbers that are visible in "Table B" or from "Column AB"
 |  | 2 | No Duplicates in one row (Highlighted in "Yellow") |  |  |  |  | (same as Exercise 1)
 |  | 3 | Replace "#[NAME]!" Error with next available value. Its basically missing criteria value, if error find the next available number from "Table B"
 |  | 4 | Row 1 to Row 50 should not repeat meaning no same row duplicated |  |  |  |  |  |  | (same as Exercise 1)