Spreadsheet: 821788d1678897718-index-match-based-on-quantity-grouped-by-qty
Sheet: Sheet1

GroupOrderNo | Quantity |  |  | DetailOrderNo | Rank | GroupOrderNo
A001 | 25 |  |  | B0021 | 1 | A001
A002 | 30 |  |  | B0022 | 2 | A001
A003 | 26 |  |  | B0023 | 3 | A001
A004 | 26 |  |  | B0024 | 4 | A001
A005 | 6 |  |  | B0025 | 5 | A001
A006 | 1 |  |  | B0026 | 6 | A001
A007 | 5 |  |  | B0027 | 7 | A001
A008 | 5 |  |  | B0028 | 8 | A001
A009 | 5 |  |  | B0029 | 9 | A001
A010 | 5 |  |  | B0030 | 10 | A001
A011 | 5 |  |  | B0031 | 11 | A001
A012 | 5 |  |  | B0032 | 12 | A001
A013 | 5 |  |  | B0033 | 13 | A001 |  |  | Group order number, A0001 to the 1st nth Quantity, 25
A014 | 2 |  |  | B0034 | 14 | A001
A015 | 6 |  |  | B0035 | 15 | A001
A016 | 6 |  |  | B0036 | 16 | A001
A017 | 6 |  |  | B0037 | 17 | A001
 |  |  |  | B0038 | 18 | A001
 |  |  |  | B0039 | 19 | A001
 |  |  |  | B0040 | 20 | A001
 |  |  |  | B0041 | 21 | A001
 |  |  |  | B0042 | 22 | A001
 |  |  |  | B0043 | 23 | A001
 |  |  |  | B0044 | 24 | A001
 |  |  |  | B0045 | 25 | A001
 |  |  |  | B0046 | 26 | A002
 |  |  |  | B0047 | 27 | A002
 |  |  |  | B0048 | 28 | A002
 |  |  |  | B0049 | 29 | A002
 |  |  |  | B0050 | 30 | A002
 |  |  |  | B0051 | 31 | A002
 |  |  |  | B0052 | 32 | A002
 |  |  |  | B0053 | 33 | A002
 |  |  |  | B0054 | 34 | A002
 |  |  |  | B0055 | 35 | A002
 |  |  |  | [NAME] | 36 | A002
 |  |  |  | B0057 | 37 | A002
 |  |  |  | B0058 | 38 | A002
 |  |  |  | B0059 | 39 | A002
 |  |  |  | B0060 | 40 | A002 |  |  | Group order number, A0002 to the next nth Quantity, 30
 |  |  |  | [NAME] | 41 | A002
 |  |  |  | B0062 | 42 | A002
 |  |  |  | B0063 | 43 | A002
 |  |  |  | B0064 | 44 | A002
 |  |  |  | B0065 | 45 | A002
 |  |  |  | [NAME] | 46 | A002
 |  |  |  | B0067 | 47 | A002
 |  |  |  | B0068 | 48 | A002
 |  |  |  | B0069 | 49 | A002
 |  |  |  | B0070 | 50 | A002
 |  |  |  | B0071 | 51 | A002
 |  |  |  | B0072 | 52 | A002
 |  |  |  | B0073 | 53 | A002
 |  |  |  | B0074 | 54 | A002
 |  |  |  | B0075 | 55 | A002
 |  |  |  | B0076 | 56 | A003
 |  |  |  | B0077 | 57 | A003
 |  |  |  | B0078 | 58 | A003
 |  |  |  | [NAME] | 59 | A003
 |  |  |  | B0080 | 60 | A003
 |  |  |  | B0081 | 61 | A003
 |  |  |  | B0082 | 62 | A003
 |  |  |  | B0083 | 63 | A003
 |  |  |  | B0084 | 64 | A003
 |  |  |  | B0085 | 65 | A003
 |  |  |  | B0086 | 66 | A003
 |  |  |  | B0087 | 67 | A003
 |  |  |  | B0088 | 68 | A003 |  |  | Group order number, A0003 to the next nth Quantity, 26
 |  |  |  | B0089 | 69 | A003
 |  |  |  | B0090 | 70 | A003
 |  |  |  | B0091 | 71 | A003
 |  |  |  | B0092 | 72 | A003
 |  |  |  | B0093 | 73 | A003
 |  |  |  | B0094 | 74 | A003
 |  |  |  | B0095 | 75 | A003
 |  |  |  | B0096 | 76 | A003
 |  |  |  | B0097 | 77 | A003
 |  |  |  | B0098 | 78 | A003
 |  |  |  | B0099 | 79 | A003
 |  |  |  | B0100 | 80 | A003
 |  |  |  | B0101 | 81 | A003
 |  |  |  | B0102 | 82
 |  |  |  | B0103 | 83
 |  |  |  | B0104 | 84
 |  |  |  | B0105 | 85
 |  |  |  | B0106 | 86
 |  |  |  | B0107 | 87
 |  |  |  | B0108 | 88
 |  |  |  | B0109 | 89
 |  |  |  | B0110 | 90
 |  |  |  | B0111 | 91
 |  |  |  | B0112 | 92
 |  |  |  | B0113 | 93
 |  |  |  | B0114 | 94
 |  |  |  | [NAME] | 95
 |  |  |  | B0116 | 96
 |  |  |  | B0117 | 97
 |  |  |  | B0118 | 98
 |  |  |  | B0119 | 99
 |  |  |  | B0120 | 100
 |  |  |  | B0121 | 101
 |  |  |  | B0122 | 102
 |  |  |  | B0123 | 103
 |  |  |  | B0124 | 104
 |  |  |  | B0125 | 105
 |  |  |  | B0126 | 106
 |  |  |  | B0127 | 107
 |  |  |  | B0128 | 108
 |  |  |  | B0129 | 109
 |  |  |  | B0130 | 110
 |  |  |  | B0131 | 111
 |  |  |  | B0132 | 112
 |  |  |  | B0133 | 113
 |  |  |  | B0134 | 114
 |  |  |  | B0135 | 115
 |  |  |  | B0136 | 116
 |  |  |  | B0137 | 117
 |  |  |  | B0138 | 118
 |  |  |  | B0139 | 119
 |  |  |  | B0140 | 120
 |  |  |  | B0141 | 121
 |  |  |  | B0142 | 122
 |  |  |  | B0143 | 123
 |  |  |  | B0144 | 124
 |  |  |  | B0145 | 125
 |  |  |  | B0146 | 126
 |  |  |  | [NAME] | 127
 |  |  |  | B0148 | 128
 |  |  |  | B0149 | 129
 |  |  |  | B0150 | 130
 |  |  |  | B0151 | 131
 |  |  |  | B0152 | 132
 |  |  |  | B0153 | 133
 |  |  |  | B0154 | 134
 |  |  |  | B0155 | 135
 |  |  |  | B0156 | 136
 |  |  |  | B0157 | 137
 |  |  |  | B0158 | 138
 |  |  |  | B0159 | 139
 |  |  |  | B0160 | 140
 |  |  |  | B0161 | 141
 |  |  |  | [NAME] | 142
 |  |  |  | B0163 | 143
 |  |  |  | B0164 | 144
 |  |  |  | B0165 | 145
 |  |  |  | B0166 | 146
 |  |  |  | B0167 | 147
 |  |  |  | B0168 | 148
 |  |  |  | [NAME] | 149
 |  |  |  | B0170 | 150
 |  |  |  | B0171 | 151
 |  |  |  | B0172 | 152
 |  |  |  | B0173 | 153
 |  |  |  | B0174 | 154
 |  |  |  | B0175 | 155
 |  |  |  | B0176 | 156
 |  |  |  | B0177 | 157
 |  |  |  | B0178 | 158
 |  |  |  | B0179 | 159
 |  |  |  | B0180 | 160
 |  |  |  | B0181 | 161
 |  |  |  | B0182 | 162
 |  |  |  | B0183 | 163
 |  |  |  | B0184 | 164
 |  |  |  | B0185 | 165
 |  |  |  | B0186 | 166
 |  |  |  | B0187 | 167
 |  |  |  | [NAME] | 168
 |  |  |  | B0189 | 169