Spreadsheet: 859022d1707490498-looking-for-a-way-to-automate-scheduling-duos-into-different-squads-sample-scheduling-bsweet0us-
Sheet: Qualifiers

Team Member 1 | Team Member 2 |  | Index | Value | L2:AG2 numbers: 1 - |  | Teams/Squad | 4 | Squads
[NAME] | [NAME] |  | 1 | [NAME] |  | Squad | Index | Team Member 1 | Team Member 2 | Count 1 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | [NAME] |  | 1 | [NAME]
[NAME] | [NAME] |  | 2 | [NAME]
 |  |  | 2 | [NAME]
[NAME] | Briley Scantland |  | 3 | [NAME]
 |  |  | 3 | [NAME]
[NAME] | Nate Apgar |  | 4 | [NAME]
[NAME] | [NAME] |  | 4 | Briley Scantland
[NAME] | [NAME] |  | 5 | [NAME]
 |  |  | 5 | Nate Apgar
[NAME] | [NAME] |  | 6 | [NAME]
 |  |  | 6 | [NAME]
Bobbi [NAME] | [NAME] |  | 7 | [NAME]
 |  |  | 7 | [NAME]
[NAME] | [NAME] |  | 8 | [NAME]
[NAME] | [NAME] |  | 8 | [NAME]
[NAME] | [NAME] |  | 9 | Bobbi [NAME]
[NAME] | [NAME] |  | 9 | [NAME]
 |  |  | 10 | [NAME]
[NAME] | [NAME] |  | 10 | [NAME]
 |  |  | 11 | [NAME]
[NAME] | [NAME] |  | 11 | [NAME]
[NAME] | [NAME] |  | 12 | [NAME]
 |  |  | 12 | [NAME]
[NAME] | [NAME] |  | 13 | [NAME]
[NAME] | [NAME] |  | 13 | [NAME]
 |  |  | 14 | [NAME]
[NAME] | [NAME] |  | 14 | [NAME]
[NAME] | [NAME] |  | 15 | [NAME]
 |  |  | 15 | [NAME]
[NAME] | [NAME] |  | 16 | [NAME]
[NAME] | [NAME] |  | 16 | [NAME]
[NAME] | [NAME] |  | 17 | [NAME]
[NAME] | [NAME] |  | 17 | [NAME]
 |  |  | 18 | [NAME]
[NAME] | [NAME] |  | 18 | [NAME]
 |  |  | 19 | [NAME]
[NAME] | Chase Kincaid |  | 19 | [NAME]
[NAME] | Nate Apgar |  | 20 | [NAME]
 |  |  | 20 | [NAME]
[NAME] | [NAME] |  | 21 | [NAME]
[NAME] | [NAME] |  | 21 | [NAME]
[NAME] | [NAME] |  | 22 | [NAME]
[NAME] | Nate Stults |  | 22 | [NAME]
 |  |  | 23 | [NAME]
[NAME] | [NAME] |  | 23 | [NAME]
 |  |  | 24 | [NAME]
Charity Crabtree | [NAME] |  | 24 | [NAME]
Charity Crabtree | Chase Kincaid |  | 25 | [NAME]
 |  |  | 25 | [NAME]
[NAME] | [NAME] |  | 26 | [NAME]
[NAME] | [NAME] |  | 26 | Chase Kincaid
[NAME] | [NAME] |  | 27 | [NAME]
 |  |  | 27 | Nate Apgar
Chase Kincaid | [NAME] |  | 28 | [NAME]
Chase Kincaid | [NAME] |  | 28 | [NAME]
 |  |  | 29 | [NAME]
[NAME] | [NAME] |  | 29 | [NAME]
 |  |  | 30 | [NAME]
[NAME] | [NAME] |  | 30 | [NAME]
 |  |  | 31 | [NAME]
[NAME] | [NAME] |  | 31 | Nate Stults
[NAME] | [NAME] |  | 32 | [NAME]
[NAME] | [NAME] |  | 32 | [NAME]
 |  |  | 33 | Charity Crabtree
[NAME] | [NAME] |  | 33 | [NAME]
 |  |  | 34 | Charity Crabtree
[NAME] | [NAME] |  | 34 | Chase Kincaid
[NAME] | [NAME] |  | 35 | [NAME]
[NAME] | [NAME] |  | 35 | [NAME]
 |  |  | 36 | [NAME]
[NAME] | [NAME] |  | 36 | [NAME]
[NAME] | [NAME] |  | 37 | [NAME]
[NAME] | [NAME] Monday |  | 37 | [NAME]
 |  |  | 38 | Chase Kincaid
[NAME] | [NAME] |  | 38 | [NAME]
[NAME] | [NAME] |  | 39 | Chase Kincaid
[NAME] | [NAME] |  | 39 | [NAME]
 |  |  | 40 | [NAME]
[NAME] | [NAME] |  | 40 | [NAME]
[NAME] | [NAME] |  | 41 | [NAME]
 |  |  | 41 | [NAME]
[NAME] | [NAME] |  | 42 | [NAME]
[NAME] | [NAME] |  | 42 | [NAME]
[NAME] | [NAME] |  | 43 | [NAME]
 |  |  | 43 | [NAME]
[NAME] | [NAME] |  | 44 | [NAME]
[NAME] | [NAME] |  | 44 | [NAME]
 |  |  | 45 | [NAME]
[NAME] | Skyler Teague |  | 45 | [NAME]
 |  |  | 46 | [NAME]
[NAME] | [NAME] |  | 46 | [NAME]
 |  |  | 47 | [NAME]
[NAME] | [NAME] |  | 47 | [NAME]
[NAME] | [NAME] |  | 48 | [NAME]
 |  |  | 48 | [NAME]
[NAME] | [NAME] |  | 49 | [NAME]
 |  |  | 49 | [NAME]
[NAME] | [NAME] |  | 50 | [NAME]
[NAME] | [NAME] |  | 50 | [NAME]
 |  |  | 51 | [NAME]
[NAME] | [NAME] |  | 51 | [NAME] Monday
[NAME] | Nate Stults |  | 52 | [NAME]
 |  |  | 52 | [NAME]
[NAME] | [NAME] |  | 53 | [NAME]
 |  |  | 53 | [NAME]
[NAME] | [NAME] |  | 54 | [NAME]
[NAME] | Nate Stults |  | 54 | [NAME]
 |  |  | 55 | [NAME]
[NAME] | [NAME] |  | 55 | [NAME]
 |  |  | 56 | [NAME]
[NAME] | [NAME] |  | 56 | [NAME]
 |  |  | 57 | [NAME]
[NAME] | [NAME] |  | 57 | [NAME]
 |  |  | 58 | [NAME]
[NAME] | [NAME] |  | 58 | [NAME]
 |  |  | 59 | [NAME]
[NAME] | [NAME] |  | 59 | [NAME]
 |  |  | 60 | [NAME]
[NAME] | [NAME] |  | 60 | [NAME]
 |  |  | 61 | [NAME]
Nate Stults | [NAME] |  | 61 | [NAME]
 |  |  | 62 | [NAME]
[NAME] | [NAME] |  | 62 | Skyler Teague
 |  |  | 63 | [NAME]
[NAME] | [NAME] |  | 63 | [NAME]
 |  |  | 64 | [NAME]
[NAME] | [NAME] |  | 64 | [NAME]
[NAME] | [NAME] |  | 65 | [NAME]
[NAME] | [NAME] Monday |  | 65 | [NAME]
 |  |  | 66 | [NAME]
[NAME] Monday | [NAME] |  | 66 | [NAME]
 |  |  | 67 | [NAME]
 |  |  | 67 | [NAME]
 |  |  | 68 | [NAME]
 |  |  | 68 | [NAME]
 |  |  | 69 | [NAME]
 |  |  | 69 | [NAME]
 |  |  | 70 | [NAME]
 |  |  | 70 | Nate Stults
 |  |  | 71 | [NAME]
 |  |  | 71 | [NAME]
 |  |  | 72 | [NAME]
 |  |  | 72 | [NAME]
 |  |  | 73 | [NAME]
 |  |  | 73 | Nate Stults
 |  |  | 74 | [NAME]
 |  |  | 74 | [NAME]
 |  |  | 75 | [NAME]
 |  |  | 75 | [NAME]
 |  |  | 76 | [NAME]
 |  |  | 76 | [NAME]
 |  |  | 77 | [NAME]
 |  |  | 77 | [NAME]
 |  |  | 78 | [NAME]
 |  |  | 78 | [NAME]
 |  |  | 79 | [NAME]
 |  |  | 79 | [NAME]
 |  |  | 80 | Nate Stults
 |  |  | 80 | [NAME]
 |  |  | 81 | [NAME]
 |  |  | 81 | [NAME]
 |  |  | 82 | [NAME]
 |  |  | 82 | [NAME]
 |  |  | 83 | [NAME]
 |  |  | 83 | [NAME]
 |  |  | 84 | [NAME]
 |  |  | 84 | [NAME]
 |  |  | 85 | [NAME]
 |  |  | 85 | [NAME] Monday
 |  |  | 86 | [NAME] Monday
 |  |  | 86 | [NAME]