Spreadsheet: 793302d1661407024-using-iferror-to-sort-data-into-groups-not-working-grouping-test-aligw
Sheet: Grouping

Group | Invoice |  |  | Group
Y | INV-110635 |  |  | A | X | Y | Z
A | INV-110881
A | INV-110878 |  |  | INV-110878 | INV-110993 | INV-110879
A | INV-110874 |  |  | INV-110874 | INV-110991 | INV-111373
A | INV-110883 |  |  | INV-110883 | INV-111049
A | INV-110882 |  |  | INV-110882 | INV-111033
A | INV-110865 |  |  | INV-110865 | INV-111054
A | INV-110863 |  |  | INV-110863
A | INV-110876 | wrong group |  | INV-110876
Y | INV-110879 | wrong group |  | INV-110875
A | INV-110875 |  |  | INV-110886
A | INV-110886 |  |  | INV-110861
A | INV-110861 |  |  | INV-110941
A | INV-110941 | missing |  | INV-110937
X | INV-110934 |  |  | INV-110930
A | INV-110937 |  |  | INV-110923
A | INV-110930 |  |  | INV-110933
A | INV-110923 |  |  | INV-110940
A | INV-110933 |  |  | INV-110915
A | INV-110940 |  |  | INV-110942
A | INV-110915 |  |  | INV-110943
A | INV-110942 | missing |  | INV-110939
Z | #N/A |  |  | INV-110938
A | INV-110943 |  |  | INV-110947
A | INV-110939 | missing |  | INV-110927
 | #N/A |  |  | INV-110924
A | INV-110938 |  |  | INV-110999
A | INV-110947 |  |  | INV-110983
A | INV-110927 |  |  | INV-110982
A | INV-110924 | missing |  | INV-110995
X | INV-110993 | missing |  | INV-111000
#N/A | #N/A |  |  | INV-110996
A | INV-110999 |  |  | INV-110985
A | INV-110983 | wrong group |  | INV-110988
X | INV-110991 | wrong group |  | INV-110997
A | INV-110982 |  |  | INV-111055
A | INV-110995 |  |  | INV-111052
A | INV-111000 |  |  | INV-111038
A | INV-110996 |  |  | INV-111035
A | INV-110985 |  |  | INV-111032
A | INV-110988 |  |  | INV-111056
A | INV-110997 | wrong group |  | INV-111059
X | INV-111049 |  |  | INV-111099
X | INV-111033 | wrong group |  | INV-111108
A | INV-111055 |  |  | INV-111135
A | INV-111052 |  |  | INV-111118
A | INV-111038 |  |  | INV-111098
A | INV-111035 |  |  | INV-111094
A | INV-111032 | wrong group |  | INV-111112
X | INV-111054 | wrong group |  | INV-111130
A | INV-111056 |  |  | INV-111120
A | INV-111059 | wrong group |  | INV-111111
Z | #N/A |  |  | INV-111119
#N/A | #N/A |  |  | INV-111104
A | INV-111099 |  |  | INV-111114
A | INV-111108 |  |  | INV-111113
A | INV-111135 |  |  | INV-111096
A | INV-111118 |  |  | INV-111208
A | INV-111098 |  |  | INV-111177
A | INV-111094 |  |  | INV-111169
A | INV-111112 |  |  | INV-111198
A | INV-111130 |  |  | INV-111188
A | INV-111120 |  |  | INV-111165
A | INV-111111 |  |  | INV-111182
A | INV-111119 |  |  | INV-111181
A | INV-111104 |  |  | INV-111246
A | INV-111114 |  |  | INV-111238
A | INV-111113 |  |  | INV-111247
A | INV-111096 |  |  | INV-111252
A | INV-111208 |  |  | INV-111242
A | INV-111177 |  |  | INV-111254
A | INV-111169 |  |  | INV-111251
A | INV-111198 |  |  | INV-111233
A | INV-111188 |  |  | INV-111248
A | INV-111165 |  |  | INV-111236
A | INV-111182 |  |  | INV-111259
A | INV-111181 |  |  | INV-111229
A | INV-111246 |  |  | INV-111234
A | INV-111238 |  |  | INV-111241
A | INV-111247 |  |  | INV-111298
A | INV-111252 |  |  | INV-111303
A | INV-111242 |  |  | INV-111289
A | INV-111254 |  |  | INV-111293
A | INV-111251 |  |  | INV-111297
A | INV-111233 |  |  | INV-111302
A | INV-111248 |  |  | INV-111294
A | INV-111236 |  |  | INV-111312
A | INV-111259 |  |  | INV-111355
A | INV-111229 |  |  | INV-111363
A | INV-111234 |  |  | INV-111382
A | INV-111241 |  |  | INV-111350
A | INV-111298 |  |  | INV-111351
A | INV-111303 |  |  | INV-111352
A | INV-111289 |  |  | INV-111346
A | INV-111293 |  |  | INV-111358
A | INV-111297 |  |  | INV-111407
A | INV-111302 |  |  | INV-111426
A | INV-111294 |  |  | INV-111413
A | INV-111312 |  |  | INV-111422
A | INV-111355 |  |  | INV-111403
A | INV-111363 |  |  | INV-111415
A | INV-111382 |  |  | INV-111410
A | INV-111350 |  |  | INV-111404
A | INV-111351 |  |  | INV-111367
A | INV-111352 |  |  | INV-111432
Y | INV-111373
A | INV-111346
A | INV-111358
A | INV-111407
A | INV-111426
A | INV-111413
A | INV-111422
A | INV-111403
A | INV-111415
A | INV-111410
A | INV-111404
A | INV-111367
A | INV-111432