Spreadsheet: 538434d1505624840-sorting-values-of-two-columns-column-sorting-template
Sheet: Sheet1

[NAME] | new UPC |  | Both A & B | In B not A | In A not B
887253826454 | 887253915615
887253826461 | 887253915622
887253826430 | 887253915639 |  |  |  |  |  |  |  | In A not B | In B not A | Both A & B
888667311680 | 887253915646 |  |  |  |  |  |  |  | =IFERROR(INDEX($A$2:$A$10000,SMALL(IF(ISNA(MATCH($A$2:$A$10000,$B$2:$B$10000,0)),ROW($A$2:$A$10000)-MIN(ROW($A$2:$A$10000))+1),ROWS($2:2))),"") | =IFERROR(INDEX($B$2:$B$10000,SMALL(IF(ISNA(MATCH($B$2:$B$10000,$A$2:$A$10000,0)),ROW($B$2:$B$10000)-MIN(ROW($B$2:$B$10000))+1),ROWS($2:2))),"") | =IFERROR(INDEX($B$2:$B$10000,SMALL(IF(ISNA(MATCH($B$2:$B$10000,$A$2:$A$116,0)),"",ROW($B$2:$B$10000)-MIN(ROW($B$2:$B$10000))+1),ROWS($2:2))),"")
888667311697 | 887253915653
888664150626 | 887253915677
888664150633 | 887253915684
888664150640 | 887253915691
888664150664 | 887253915707
888667301476 | 887253915714
888667301483 | 888665187324
888667301490 | 888665187300
888667301605 | 888665187294
888667301612 | 888665187287
888667301643 | 888665187317
887253734285 | 887253916216
887253734292 | 887253916223
888667336775 | 887253916230
888667336782 | 887253916247
888667336799 | 887253916254
888667336805 | 190178920283
888667336737 | 190178920269
888667336744 | 190178920252
888667336751 | 190178920245
887253830710 | 190178920276
887253830680 | 887253916636
888664129097 | 887253916643
888664129103 | 887253916667
888664129110 | 887253916674
888667184734 | 190178920870
888667311536 | 190178920887
888667311550 | 887253916933
888667311567 | 887253916940
888667301339 | 190178920955
888667301346 | 190178920962
888667301353 | 887253833155
888667336607 | 887253833162
888667336614 | 887253833179
888667077890 | 887253833186
888667078002 | 887253833193
888667078019 | 887253833209
888667078026 | 887253833216
888667078033 | 887253833223
888667078194 | 190178918662
888667078309 | 190178918679
888667078316 | 190178918648
888667078323 | 190178918655
888667078330 | 887253833551
888664415831 | 887253833568
888664415848 | 887253833575
888664415855 | 887253833582
888667196539 | 190178918761
888667196287 | 190178918778
888667362071 | 190178918747
888458779347 | 190178918754
888667135712 | 190178954059
888667135729 | 190178954035
887921234147 | 190178954028
887921234130 | 190178954011
887253804698 | 190178954042
887253804711 | 190178954509
887253804865 | 190178954486
887921001800 | 190178954479
887253805008 | 190178954462
887253804995 | 190178954493
887253805015 | 190178954141
888667111303 | 190178954127
888667111310 | 190178954110
888667111327 | 190178954103
887253915691 | 190178954134
887253915684 | 190178954684
887253915622 | 190178954660
887253918746 | 190178954653
887921580305 | 190178954646
887921580282 | 190178954677
887921580312 | 190178955056
887921134867 | 190178955063
887921134119 | 190178955346
887921134102 | 190178955353
887921134096 | 190178955254
887921111783 | 190178955261
887921111776 | 190178955087
887921111929 | 190178955094
887921111912 | 190178955377
887921135253 | 190178955384
887921135291 | 190178956176
887921114272 | 190178956183
888664294535 | 190178956152
888665207961 | 190178956169
888665207978 | 190178956589
888665207985 | 190178956596
888665207992 | 190178956565
888664153146 | 190178956572
888664152996 | 190178956510
888664153009 | 190178956527
888664153023 | 190178956497
887253822722 | 190178956503
887253822715 | 190178956015
888667176104 | 190178956022
888667176135 | 190178955995
888664239772 | 190178956008
887253718889 | 190178956657
887253718919 | 190178956664
888664266914 | 190178956633
888664266921 | 190178956640
888664266945 | 887253794494
888667150449 | 887253794500
888667150456 | 887921002036
888667150463 | 887921002043
888664213796 | 190178959870
888664342144 | 190178959887
888667155673 | 888667336775
888667155680 | 888667336805
888667155697 | 888667336812
888667155802 | 888667336782
888667232251 | 888667336799
888667232268 | 190178954868
888667232275 | 190178954899
887253228012 | 190178954905
887253789476 | 190178954875
887253789469 | 190178954882
888664435983 | 190178954998
887921134355 | 190178955025
888667242786 | 190178955032
888667242793 | 190178955001
888667242908 | 190178955018
888667242915 | 190178953793
888664435952 | 190178953823
888667258510 | 190178953830
888667258527 | 190178953809
888667289811 | 190178953816
887253916643 | 888664326502
887921134089 | 888664326533
887921134324 | 888664326540
888665208005 | 888664326519
887253822708 | 888664326526
887253718872 | 190178924977
887253718865 | 190178924984
888667150470 | 190178925097
887253822241 | 190178925103
887253822258 | 190178925011
885491272798 | 190178925028
888667175015 | 190178930978
885491273085 | 190178930954
887253822531 | 190178930947
888667258909 | 190178930930
888667258916 | 190178930961
887921983830 | 887253718872
887921983847 | 887253718889
888664277132 | 887253718896
887921974364 | 887253718902
887921974371 | 887253718919
888664267232 | 888667150470
888667420832 | 888667150456
888667420849 | 888667150449
888667044786 | 888667150432
887921133938 | 888667150463
888664213819 | 888667184666
888664342151 | 888667184697
888664342168 | 888667184703
888664342182 | 888667184673
888667420979 | 190178926605
888667421228 | 190178926636
888667450037 | 190178926643
888667450259 | 190178926612
888667451775 | 190178926490
888667450266 | 190178926520
888667450327 | 190178926537
888667451782 | 190178926506
888667450273 | 190178926339
888667450334 | 190178926360
888667450068 | 190178926377
888667451904 | 190178926346
888667450075 | 190178914787
888667450297 | 190178914817
888667450358 | 190178914824
887921134645 | 190178914794
888667426254 | 190178914800
888667426278 | 190178914619
888667426285 | 190178914640
888667426216 | 190178914657
888667426223 | 190178914626
888667426230 | 190178914633
888667378171 | 190178914503
888667378188 | 190178914534
888667378195 | 190178914541
888667378300 | 190178914510
888667378133 | 190178914527
888667378140 | 190178909295
888667378157 | 190178909325
888667378164 | 190178909332
 | 190178909301
 | 190178909318
 | 887253734254
 | 887253734261
 | 887253734278
 | 887253734285
 | 887253734292
 | 190178909011
 | 190178909042
 | 190178909059
 | 190178909028
 | 888664415824
 | 888664415855
 | 888664415862
 | 888664415831
 | 887253734353
 | 887253734360
 | 887253734377
 | 887253734384
 | 190178908908
 | 190178908939
 | 190178908946
 | 190178908915
 | 190178909127
 | 190178909158
 | 190178909165
 | 190178909134
 | 190178908793
 | 190178908823
 | 190178908830
 | 190178908809
 | 190178925356
 | 190178925387
 | 190178925394
 | 190178925363
 | 190178925370
 | 190178925400
 | 190178925431
 | 190178925448
 | 190178925417
 | 190178925424
 | 190178925783
 | 190178925813
 | 190178925820
 | 190178925790
 | 190178925806
 | 888664150626
 | 888664150657
 | 888664150664
 | 888664150633
 | 888664150640
 | 190178931623
 | 190178931630
 | 190178931562
 | 190178931579
 | 190178931791
 | 190178931807
 | 887921048669
 | 887921048676
 | 190178930008
 | 190178930039
 | 190178930046
 | 190178930015
 | 190178930022
 | 190178929927
 | 190178929958
 | 190178929965
 | 190178929934
 | 190178929941
 | 190178930138
 | 190178930169
 | 190178930176
 | 190178930145
 | 190178930152
 | 887921048935
 | 887921048942
 | 887921048959
 | 887921048966
 | 887921048973
 | 887921950818
 | 887921950825
 | 887921950832
 | 887921950849
 | 887921950856
 | 887921950870
 | 887921950887
 | 887921950894
 | 887921950900
 | 887921950917
 | 887921950993
 | 887921951006
 | 887921951013
 | 887921951020
 | 887921951037
 | 190178932095
 | 190178932071
 | 190178932064
 | 190178932057
 | 190178932088
 | 190178924168
 | 190178924144
 | 190178924137
 | 190178924120
 | 190178924151
 | 190178924281
 | 190178924267
 | 190178924250
 | 190178924243
 | 190178924274
 | 190178924229
 | 190178924205
 | 190178924199
 | 190178924182
 | 190178924212
 | 190178906560
 | 190178906546
 | 190178906539
 | 190178906522
 | 190178906553
 | 888458839775
 | 888458839782
 | 888458839799
 | 888458839805
 | 888458839812
 | 190178905860
 | 190178905877
 | 888458839881
 | 888458839898
 | 888458839904
 | 190178907048
 | 190178907055
 | 190178907024
 | 190178907031
 | 888458832202
 | 888458832219
 | 888458832226
 | 888458832233
 | 190178912448
 | 190178912424
 | 190178912417
 | 190178912400
 | 190178912431
 | 190178903095
 | 190178903071
 | 190178903064
 | 190178903057
 | 190178903088
 | 190178907161
 | 190178907147
 | 190178907130
 | 190178907123
 | 190178907154
 | 190178902852
 | 190178902869
 | 190178902821
 | 190178902838
 | 190178902418
 | 190178902425
 | 190178902326
 | 190178902333
 | 190178902302
 | 190178902319
 | 190178902227
 | 190178902234
 | 190178902203
 | 190178902210
 | 190178901787
 | 190178901794
 | 190178901763
 | 190178901770
 | 888667451904
 | 888667451782
 | 888667451775
 | 888667451768
 | 888667451799
 | 888667450358
 | 888667450334
 | 888667450327
 | 888667450310
 | 888667450341
 | 190178903835
 | 190178903811
 | 190178903804
 | 190178903798
 | 190178903828
 | 190178931364
 | 190178931371
 | 190178931449
 | 190178931456
 | 190178931531
 | 190178931548
 | 190178931593
 | 190178931609
 | 190178931302
 | 190178931319
 | 190178931760
 | 190178931777
 | 190178931746
 | 190178931753
 | 190178931838
 | 190178931845
 | 190178931814
 | 190178931821
 | 190178931906
 | 190178931913
 | 190178931883
 | 190178931890
 | 190178931975
 | 190178931982
 | 190178931951
 | 190178931968
 | 190178931722
 | 190178931739
 | 190178931708
 | 190178931715
 | 190178901473
 | 190178901480
 | 190178901459
 | 190178901466
 | 190178932217
 | 190178932224
 | 190178915470
 | 190178915487
 | 190178915456
 | 190178915555
 | 190178915562
 | 190178915531