Spreadsheet: 203502d1357147303-help-need-an-advanced-filter-to-do-this-matching-combos
Sheet: Sheet2

1 | 2 | 3 | 4 | 5 | 6
1 | 2 | 3 | 4 | 5 | 7
1 | 2 | 3 | 4 | 5 | 8
1 | 2 | 3 | 4 | 5 | 9
1 | 2 | 3 | 4 | 5 | 10 |  |  | Scrol down and read text
1 | 2 | 3 | 4 | 5 | 11
1 | 2 | 3 | 4 | 5 | 12
1 | 2 | 3 | 4 | 5 | 13
1 | 2 | 3 | 4 | 5 | 14
1 | 2 | 3 | 4 | 5 | 15
1 | 2 | 3 | 4 | 5 | 16
1 | 2 | 3 | 4 | 5 | 17
1 | 2 | 3 | 4 | 5 | 18
1 | 2 | 3 | 4 | 5 | 19
1 | 2 | 3 | 4 | 5 | 20
1 | 2 | 3 | 4 | 5 | 21
1 | 2 | 3 | 4 | 5 | 22
1 | 2 | 3 | 4 | 5 | 23
1 | 2 | 3 | 4 | 5 | 24
1 | 2 | 3 | 4 | 5 | 25
1 | 2 | 3 | 4 | 5 | 26
1 | 2 | 3 | 4 | 5 | 27
1 | 2 | 3 | 4 | 5 | 28
1 | 2 | 3 | 4 | 5 | 29
1 | 2 | 3 | 4 | 5 | 30
1 | 2 | 3 | 4 | 5 | 31
1 | 2 | 3 | 4 | 5 | 32
1 | 2 | 3 | 4 | 5 | 33
1 | 2 | 3 | 4 | 5 | 34
1 | 2 | 3 | 4 | 5 | 35
1 | 2 | 3 | 4 | 5 | 36
1 | 2 | 3 | 4 | 5 | 37
1 | 2 | 3 | 4 | 5 | 38
1 | 2 | 3 | 4 | 5 | 39
1 | 2 | 3 | 4 | 5 | 40
1 | 2 | 3 | 4 | 5 | 41
1 | 2 | 3 | 4 | 5 | 42
1 | 2 | 3 | 4 | 5 | 43
1 | 2 | 3 | 4 | 5 | 44
1 | 2 | 3 | 4 | 5 | 45
1 | 2 | 3 | 4 | 5 | 46
1 | 2 | 3 | 4 | 5 | 47
1 | 2 | 3 | 4 | 5 | 48
1 | 2 | 3 | 4 | 5 | 49
1 | 2 | 3 | 4 | 5 | 50 |  | 5 |  | <-- and here the same, only 5 numbers macth exception is 5th numbers which is 5 instead of 6
1 | 2 | 3 | 4 | 6 | 7 |  | 5 |  | <-- ONLY 5 NUMBERS MATCH
1 | 2 | 3 | 4 | 6 | 8 |  | 5
1 | 2 | 3 | 4 | 6 | 9 |  | 5
1 | 2 | 3 | 4 | 6 | 10 |  | 5
1 | 2 | 3 | 4 | 6 | 11 |  | 5
1 | 2 | 3 | 4 | 6 | 12 |  | 5
1 | 2 | 3 | 4 | 6 | 13 |  | 5
1 | 2 | 3 | 4 | 6 | 14 |  | 5
1 | 2 | 3 | 4 | 6 | 15 |  | 5 |  |  | scrol down and read text
1 | 2 | 3 | 4 | 6 | 16 |  | 5
1 | 2 | 3 | 4 | 6 | 17 |  | 5
1 | 2 | 3 | 4 | 6 | 18 |  | 5
1 | 2 | 3 | 4 | 6 | 19 |  | 5
1 | 2 | 3 | 4 | 6 | 20 |  | 5
1 | 2 | 3 | 4 | 6 | 21 |  | 5
1 | 2 | 3 | 4 | 6 | 22 |  | 5
1 | 2 | 3 | 4 | 6 | 23 |  | 5
1 | 2 | 3 | 4 | 6 | 24 |  | 5
1 | 2 | 3 | 4 | 6 | 25 |  | 5
1 | 2 | 3 | 4 | 6 | 26 |  | 5
1 | 2 | 3 | 4 | 6 | 27 |  | 5
1 | 2 | 3 | 4 | 6 | 28 |  | 5
1 | 2 | 3 | 4 | 6 | 29 |  | 5
1 | 2 | 3 | 4 | 6 | 30 |  | 5
1 | 2 | 3 | 4 | 6 | 31 |  | 5
1 | 2 | 3 | 4 | 6 | 32 |  | 5
1 | 2 | 3 | 4 | 6 | 33 |  | 5
1 | 2 | 3 | 4 | 6 | 34 |  | 5
1 | 2 | 3 | 4 | 6 | 35 |  | 5
1 | 2 | 3 | 4 | 6 | 36 |  | 5
1 | 2 | 3 | 4 | 6 | 37 |  | 5
1 | 2 | 3 | 4 | 6 | 38 |  | 5
1 | 2 | 3 | 4 | 6 | 39 |  | 5
1 | 2 | 3 | 4 | 6 | 40 |  | 5
1 | 2 | 3 | 4 | 6 | 41 |  | 5
1 | 2 | 3 | 4 | 6 | 42 |  | 5
1 | 2 | 3 | 4 | 6 | 43 |  | 5
1 | 2 | 3 | 4 | 6 | 44 |  | 5
1 | 2 | 3 | 4 | 6 | 45 |  | 5
1 | 2 | 3 | 4 | 6 | 46 |  | 5
1 | 2 | 3 | 4 | 6 | 47 |  | 5
1 | 2 | 3 | 4 | 6 | 48 |  | 5
1 | 2 | 3 | 4 | 6 | 49 |  | 5
1 | 2 | 3 | 4 | 6 | 50 |  | True |  | <[NAME] (ALL 6 NUMBERS)
1 | 2 | 3 | 4 | 7 | 8
1 | 2 | 3 | 4 | 7 | 9
1 | 2 | 3 | 4 | 7 | 10
1 | 2 | 3 | 4 | 7 | 11 |  |  | And so on, for each combo from Sheet1.
1 | 2 | 3 | 4 | 7 | 12
1 | 2 | 3 | 4 | 7 | 13 |  |  | Now go on sheet 3
1 | 2 | 3 | 4 | 7 | 14
1 | 2 | 3 | 4 | 7 | 15
1 | 2 | 3 | 4 | 7 | 16
1 | 2 | 3 | 4 | 7 | 17
1 | 2 | 3 | 4 | 7 | 18
1 | 2 | 3 | 4 | 7 | 19
1 | 2 | 3 | 4 | 7 | 20
1 | 2 | 3 | 4 | 7 | 21
1 | 2 | 3 | 4 | 7 | 22
1 | 2 | 3 | 4 | 7 | 23
1 | 2 | 3 | 4 | 7 | 24
1 | 2 | 3 | 4 | 7 | 25
1 | 2 | 3 | 4 | 7 | 26
1 | 2 | 3 | 4 | 7 | 27
1 | 2 | 3 | 4 | 7 | 28
1 | 2 | 3 | 4 | 7 | 29
1 | 2 | 3 | 4 | 7 | 30
1 | 2 | 3 | 4 | 7 | 31
1 | 2 | 3 | 4 | 7 | 32
1 | 2 | 3 | 4 | 7 | 33
1 | 2 | 3 | 4 | 7 | 34
1 | 2 | 3 | 4 | 7 | 35
1 | 2 | 3 | 4 | 7 | 36
1 | 2 | 3 | 4 | 7 | 37
1 | 2 | 3 | 4 | 7 | 38
1 | 2 | 3 | 4 | 7 | 39
1 | 2 | 3 | 4 | 7 | 40
1 | 2 | 3 | 4 | 7 | 41
1 | 2 | 3 | 4 | 7 | 42
1 | 2 | 3 | 4 | 7 | 43
1 | 2 | 3 | 4 | 7 | 44
1 | 2 | 3 | 4 | 7 | 45
1 | 2 | 3 | 4 | 7 | 46
1 | 2 | 3 | 4 | 7 | 47
1 | 2 | 3 | 4 | 7 | 48
1 | 2 | 3 | 4 | 7 | 49
1 | 2 | 3 | 4 | 7 | 50
1 | 2 | 3 | 4 | 8 | 9
1 | 2 | 3 | 4 | 8 | 10
1 | 2 | 3 | 4 | 8 | 11
1 | 2 | 3 | 4 | 8 | 12
1 | 2 | 3 | 4 | 8 | 13
1 | 2 | 3 | 4 | 8 | 14
1 | 2 | 3 | 4 | 8 | 15
1 | 2 | 3 | 4 | 8 | 16
1 | 2 | 3 | 4 | 8 | 17
1 | 2 | 3 | 4 | 8 | 18
1 | 2 | 3 | 4 | 8 | 19
1 | 2 | 3 | 4 | 8 | 20
1 | 2 | 3 | 4 | 8 | 21
1 | 2 | 3 | 4 | 8 | 22
1 | 2 | 3 | 4 | 8 | 23
1 | 2 | 3 | 4 | 8 | 24
1 | 2 | 3 | 4 | 8 | 25
1 | 2 | 3 | 4 | 8 | 26
1 | 2 | 3 | 4 | 8 | 27
1 | 2 | 3 | 4 | 8 | 28
1 | 2 | 3 | 4 | 8 | 29
1 | 2 | 3 | 4 | 8 | 30
1 | 2 | 3 | 4 | 8 | 31
1 | 2 | 3 | 4 | 8 | 32
1 | 2 | 3 | 4 | 8 | 33
1 | 2 | 3 | 4 | 8 | 34
1 | 2 | 3 | 4 | 8 | 35
1 | 2 | 3 | 4 | 8 | 36
1 | 2 | 3 | 4 | 8 | 37
1 | 2 | 3 | 4 | 8 | 38
1 | 2 | 3 | 4 | 8 | 39
1 | 2 | 3 | 4 | 8 | 40
1 | 2 | 3 | 4 | 8 | 41
1 | 2 | 3 | 4 | 8 | 42
1 | 2 | 3 | 4 | 8 | 43
1 | 2 | 3 | 4 | 8 | 44
1 | 2 | 3 | 4 | 8 | 45
1 | 2 | 3 | 4 | 8 | 46
1 | 2 | 3 | 4 | 8 | 47
1 | 2 | 3 | 4 | 8 | 48
1 | 2 | 3 | 4 | 8 | 49
1 | 2 | 3 | 4 | 8 | 50
 | and many more (all combos)