Spreadsheet: 690697d1597240707-combinations-to-ignore-blanks-combination-match-issue-based-on-random-variables-test_file_v2_reply
Sheet: Excercise 1

 | Table A | [NAME] | [NAME] | [NAME] | [NAME] | G2 | G2 | G2 | G2 | G3 | G3 | G3 |  | Criteria | C1 | C2 | [NAME] | C4 | C5 | C6 |  | Condition
 |  | A | A | A | A | A | B | B | B | B | B | B |  | 1 | A | C | E | H | H | G |  | A
 | AA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | E | D | C | H | H | H |  | B
 |  | C | C | C | C | C | D | D | D | D | D | D |  | 3 | A | A | D | E | F | B |  | C
 | AB | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 4 | B | E | F | F | F | C |  | D
 |  | E | E | E | E | E | F | F | F | F | F | F |  | 5 | E | E | B | B | A | A |  | E
 | AC | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 |  | 6 | B | E | F | F | F | C |  | F
 |  | G | G | G | G | G | H | H | H | H | H | H |  | 7 | E | E | B | B | A | A |  | G
 | AD | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 |  | 8 | B | E | F | F | F | C |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | E | E | B | B | A | A
 |  | Table 1 |  |  |  |  |  |  |  |  |  |  |  | 10 | B | E | F | F | F | C
 |  | C1 | C2 | [NAME] | C4 | C5 | C6 |  |  |  |  |  |  | 11 | E | E | B | B | A | A
 | Row 1 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | B | E | F | F | F | C
 | Row 2 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | E | E | B | B | A | A
 | Row 3 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | B | E | F | F | F | C
 | Row 4 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | E | E | B | B | A | A
 | Row 5 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | B | E | F | F | F | C
 | Row 6 |  |  |  |  |  |  |  |  |  |  |  |  | 17 | A | B | F | E | F | G
 | Row 7 |  |  |  |  |  |  |  |  |  |  |  |  | 18 | A | B | F | E | F | G
 | Row 8 |  |  |  |  |  |  |  |  |  |  |  |  | 19 | A | B | F | E | F | G
 | Row 9 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | A | B | F | E | F | G
 | Row 10 |  |  |  |  |  |  |  |  |  |  |  |  | 21 | A | B | F | E | F | G
 | Row 11 |  |  |  |  |  |  |  |  |  |  |  |  | 22 | A | B | F | E | F | G
 | Row 12 |  |  |  |  |  |  |  |  |  |  |  |  | 23 | A | B | F | E | F | G
 | Row 13 |  |  |  |  |  |  |  |  |  |  |  |  | 24 | D | C | F | G | H | A
 | Row 14 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | D | C | F | G | H | A
 | Row 15 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | D | C | F | G | H | A
 | Row 16 |  |  |  |  |  |  |  |  |  |  |  |  | 27 | D | C | F | G | H | A
 | Row 17 |  |  |  |  |  |  |  |  |  |  |  |  | 28 | D | C | F | G | H | A
 | Row 18 |  |  |  |  |  |  |  |  |  |  |  |  | 29 | D | C | F | G | H | A
 | Row 19 |  |  |  |  |  |  |  |  |  |  |  |  | 30 | A | C | E | H | H | G
 | Row 20 |  |  |  |  |  |  |  |  |  |  |  |  | 31 | A | C | E | H | H | G
 | Row 21 |  |  |  |  |  |  |  |  |  |  |  |  | 32 | A | C | E | H | H | G
 | Row 22 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | A | C | E | H | H | G
 | Row 23 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | A | C | E | H | H | G
 | Row 24 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | A | C | E | H | H | G
 | Row 25 |  |  |  |  |  |  |  |  |  |  |  |  | 36 | C | G | H | E | B | B
 | Row 26 |  |  |  |  |  |  |  |  |  |  |  |  | 37 | C | G | H | E | B | B
 | Row 27 |  |  |  |  |  |  |  |  |  |  |  |  | 38 | C | G | H | E | B | B
 | Row 28 |  |  |  |  |  |  |  |  |  |  |  |  | 39 | C | G | H | E | B | B
 | Row 29 |  |  |  |  |  |  |  |  |  |  |  |  | 40 | C | G | H | E | B | B
 | Row 30 |  |  |  |  |  |  |  |  |  |  |  |  | 41 | C | G | H | E | B | B
 | Row 31 |  |  |  |  |  |  |  |  |  |  |  |  | 42 | C | G | H | E | B | B
 | Row 32 |  |  |  |  |  |  |  |  |  |  |  |  | 43 | C | G | H | E | B | B
 | Row 33 |  |  |  |  |  |  |  |  |  |  |  |  | 44 | C | G | H | E | B | B
 | 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 | No Duplicates in one row (Highlighted in "Yellow") - Choose next avaiable number instead
 |  | 2 | Row 1 to Row 50 should not repeat meaning no same row duplicated