Spreadsheet: 164400d1340745779-formula-to-look-up-value-for-most-1-and-least-3-while-ignoring-middle-2-from-survey-example
Sheet: New table

 | Q1 |  | Q2 |  | Q3 |  | Q4 |  | Q5 |  | Q6
Response ID | Most | Least | Most | Least | Most | Least | Most | Least | Most | Least | Most | Least
16004415
16004422
16004426
16004427
16004431
16004433
16004438
16004439
16004440
16004441
16004444
16004450
16004453
16004458
16004459
16004460
16004463
16004465
16004469
16004471
16004477
16004482
16004485
16004486
16004487
16004488
16004492
16004493
16004494
16004495
16004496
16004499
16004502
16004504
16004508
16004509
16004515
16004516
16004517
16004519
16004520
16004524
16004526
16004527
16004533
16004534
16004535
16004536
16004538
16004539
16004540
16004542
16004545
16004546
16004548
16004550
16004551
16004552
16004554
16004557
16004558
16004559
16004568
16004569
16004572
16004574
16004575
16004577
16004578
16004579
16004581
16004583
16004584
16004585
16004589
16004592
16004593
16004594
16004595
16004599
16004601
16004603
16004604
16004605
16004609
16004610
16004614
16004615
16004620
16004621
16004622
16004625
16004626
16004627
16004628
16004629
16004634
16004635
16004636
16004640
16004641
16004644
16004646
16004647
16004648
16004649
16004650
16004653
16004654
16004658
16004659
16004660
16004661
16004667
16004669
16004670
16004671
16004675
16004676
16004683
16004685
16004689
16004694
16004701
16004703
16004706
16004707
16004708
16004710
16004712
16004713
16004714
16004717
16004721
16004729
16004730
16004732
16004733
16004734
16004738
16004741
16004742
16004744
16004746
16004747
16004748
16004751
16004754
16004759
16004774
16004782
16004784
16004791
16004796
16004797
16004798
16004799
16004801
16004805
16004806
16004812
16004813
16004814
16004815
16004817
16004821
16004833
16004834
16004844
16004851
16004852
16004857
16004858
16004862
16004864
16004871
16004875
16004887
16004892
16004895
16004900
16004902
16004905
16004908
16004910
16004913
16004914
16004922
16004923
16004925
16004927
16004928
16004930
16004931
16004932
16004933
16004937
16004938
16004944
16004946
16004950
16004951
16004952
16004958
16004961
16004964
16004967
16004969
16004970
16004975
16004976
16004978
16004981
16004984
16004989
16004990
16004992
16004993
16004994
16004998
16005003
16005006
16005008
16005010
16005012
16005014
16005015
16005017
16005020
16005039
16005042
16005048
16005053
16005066
16005072
16005083
16005084
16005089
16005091
16005108
16005111
16005120
16005121
16005125
16005149
16005151
16005156
16005157
16005160
16005161
16005163
16005177
16005179
16005180
16005192
16005194
16005197
16005199
16005200
16005204
16005209
16005210
16005212
16005215
16005218
16005223
16005228
16005247
16005248
16005259
16005260
16005262
16005263
16005278
16005279
16005284
16005288
16005300
16005302
16005304
16005312
16005326
16005327
16005338
16005339
16005352
16005357
16005361
16005368
16005379
16005386
16005392
16005400
16005401
16005411
16005414
16005415
16005420
16005426
16005446
16005449
16005454
16005458
16005459
16005461
16005463
16005467
16005469
16005470
16005471
16005481
16005483
16005486
16005488
16005499
16005503
16005520
16005531
16005539
16005548
16005565
16005570
16005574
16005577
16005581
16005582
16005583
16005585
16005589
16005590
16005593
16005604
16005606
16005625
16005626
16005638
16005640
16005642
16005645
16005656
16005661
16005665
16005667
16005672
16005678
16005682
16005683
16005685
16005688
16005690
16005698
16005703
16005704
16005709
16005710
16005711
16005713
16005717
16005724
16005728
16005736
16005738
16005741
16005745
16005752
16005763
16005771
16005774
16005778
16005781
16005785
16005789
16005792
16005793
16005803
16005804
16005807
16005822
16005826
16005829
16005834
16005839
16005845
16005854
16005857
16005863
16005865
16005867
16005868
16005873
16005875
16005878
16005881
16005883
16005888
16005889
16005890
16005898
16005899
16005900
16005902
16005904
16005905
16005909
16005914
16005919
16005926
16005929
16005930
16005931
16005935
16005942
16005946
16005957
16005963
16005969
16005975
16005983
16005985
16005986
16005992
16005998
16006000
16006002
16006006
16006012
16006017
16006024
16006025
16006028
16006038
16006041
16006043
16006046
16006048
16006061
16006071
16006073
16006078
16006083
16006096
16006097
16006099
16006101
16006105
16006106
16006111
16006115
16006116
16006117
16006119
16006121
16006127
16006130
16006137
16006139
16006142
16006149
16006152
16006155
16006172
16006174
16006179
16006186
16006189
16006190
16006227
16006236
16006297
16006319
16006331
16006352
16006438
16006449
16006456
16006475
16006488
16006492
16006497
16006499
16006524
16006526
16006581
16006585
16006610
16006623
16006646
16006666
16006676
16006697
16006726
16006741
16006745
16006753
16006754
16006769
16006774
16006796
16006807
16006811
16006830
16006867
16006870
16006872
16006875
16006895
16006919
16006949
16006970
16006992
16007017
16007025
16007067
16007103
16007165
16007170
16007173
16007184
16007196
16007203
16007209
16007236
16007269
16007277
16007302
16007343
16007350
16007365
16007368
16007377
16007410
16007438
16007456
16007472
16007534
16007585
16007586
16007607
16007611
16007619
16007623
16007628
16007631
16007635
16007640
16007648
16007661
16007673
16007677
16007683
16007686
16007702
16007711
16007717
16007721
16007735
16007751
16007772
16007772
16007772
16007794
16007839
16007865
16007870
16007885
16007886
16007900
16007902
16007904
16007907
16007918
16007921
16007982
16008090
16008148
16008170
16008198
16008204
16008215
16008224
16008227
16008233
16008241
16008243
16008269
16008275
16008279
16008281
16008284
16008300
16008306
16008311
16008329
16008332
16008349
16008356
16008371
16008374
16008435
16008455
16008464
16008508
16008556
16008593
16008601
16008602
16008606
16008649
16008668
16008674
16008686
16008704
16008718
16008767
16008799
16008825
16008887
16008898
16008924
16008940
16008982
16008987
16009016
16009018
16009047
16009084
16009098
16009195
16009208
16009214
16009219
16009234
16009281
16009374
16009383
16009544
16009552
16009698
16009707
16009710
16009728
16009735
16009750
16009759
16009769
16009775
16009776
16009779
16009781
16009788
16009806
16009809
16009818
16009828
16009846
16009853
16009868
16009892
16009908
16009911
16009916
16009920
16009935
16009949
16009976
16009978
16009988
16009995
16010023
16010026
16010031
16010038
16010068
16010069
16010093
16010096
16010097
16010099
16010100
16010104
16010106
16010107
16010108
16010110
16010115
16010131
16010133
16010136
16010138
16010141
16010144
16010147
16010148
16010154
16010157
16010164
16010170
16010178
16010185
16010186
16010187
16010194
16010195
16010210
16010220
16010227
16010234
16010240
16010246
16010250
16010268
16010273
16010276
16010278
16010289
16010290
16010293
16010297
16010298
16010299
16010302
16010305
16010310
16010313
16010314
16010318
16010321
16010323
16010327
16010334
16010336
16010337
16010341
16010348
16010354
16010355
16010356
16010357
16010360
16010362
16010369
16010372
16010374
16010376
16010378
16010381
16010387
16010395
16010396
16010397
16010399
16010406
16010407
16010408
16010409
16010418
16010420
16010423
16010425
16010432
16010434
16010437
16010439
16010442
16010444
16010454
16010457
16010468
16010472
16010477
16010484
16010485
16010488
16010490
16010493
16010494
16010497
16010499
16010500
16010501
16010502
16010509
16010512
16010514
16010516
16010517
16010518
16010528
16010531
16010534
16010535
16010537
16010539
16010542
16010546
16010548
16010557
16010558
16010562
16010567
16010569
16010572
16010574
16010580
16010586
16010588
16010589
16010590
16010592
16010600
16010609
16010612
16010618
16010621
16010628
16010633
16010641
16010642
16010643
16010647
16010652
16010659
16010661
16010662
16010665
16010667
16010670
16010673
16010675
16010689
16010691
16010692
16010693
16010703
16010714
16010716
16010719
16010722
16010723
16010728
16010733
16010734
16010737
16010738
16010743
16010745
16010759
16010761
16010762
16010764
16010768
16010769
16010773
16010774
16010780
16010783
16010784
16010788
16010789
16010790
16010793
16010794
16010796
16010798
16010801
16010805
16010808
16010811
16010817
16010823
16010825
16010832
16010840
16010842
16010843
16010849
16010854
16010858
16010865
16010872
16010883
16010892
16010894
16010898
16010900
16010914
16010919
16010921
16010925
16010927
16010938
16010943
16010949
16010953
16010965
16010971
16010973
16010980
16010984
16010989
16010999
16011005
16011043
16011045
16011066
16011075
16011081
16011095
16011100
16011108
16011143
16011148
16011152
16011165
16011166
16011205
16011208
16011215
16011223
16011227
16011236
16011238
16011242
16011266
16011273
16011275
16011277
16011291
16011304
16011312
16011323
16011326
16011359
16011364
16011402
16011413
16011414
16011417
16011441
16011447
16011472
16011477
16011532
16011576
16011583
16011604
16011611
16011637
16011659
16011671
16011672
16011687
16011700
16011732
16011742
16011755
16011765
16011768
16011769
16011773
16011775
16011788
16011789
16011797
16011802
16011817
16011829
16011831
16011837
16011841
16011852
16011863
16011864
16011873
16011880
16011881
16011889
16011893
16011898
16011899
16011907
16011910
16011919
16011932
16011936
16011937
16011939
16011945
16011957
16011963
16011967
16011968
16011978
16012002
16012021
16012033
16012036
16012045
16012055
16012059
16012065
16012078
16012102
16012110
16012122
16012142
16012144
16012167
16012170
16012172
16012193
16012198
16012201
16012204
16012231
16012233
16012241
16012244
16012262
16012280
16012281
16012306
16012309
16012311
16012318
16012325
16012350
16012355
16012367
16012370
16012384
16012411
16012415
16012416
16012420
16012427
16012428
16012435
16012446
16012454
16012463
16012465
16012489
16012493
16012503
16012517
16012539
16012544
16012549
16012551
16012567
16012569
16012578
16012580
16012584
16012597
16012600
16012606
16012626
16012628
16012646
16012649
16012650
16012651
16012657
16012667
16012669
16012687
16012694
16012704
16012720
16012728
16012730
16012732
16012734
16012736
16012744
16012746
16012767
16012774
16012787
16012795
16012812
16012825
16012831
16012854
16012898
16012922
16012926
16012938
16012957
16012965
16012997
16013003
16013004
16013008
16013027
16013033
16013037
16013048
16013052
16013071
16013074
16013081
16013112
16013134
16013156
16013201
16013223
16013236
16013243
16013265
16013279
16013295
16013308
16013337
16013346
16013351
16013446
16013458
16013466
16013473
16013492
16013495
16013553
16013567
16013570
16013580
16013581
16013587
16013602
16013630
16013643
16013654
16013678
16013702
16013717
16013723
16013724
16013736
16013742
16013767
16013803
16013806
16013825
16013829
16013833
16013839
16013846
16013850
16013855
16013858
16013860
16013862
16013869
16013876
16013899
16013903
16013915
16013919
16013945
16013982
16013986
16013996
16014001
16014003
16014017
16014027
16014049
16014056
16014061
16014072
16014088
16014129
16014144
16014181
16014201
16014222
16014310
16014349
16014380
16014403
16014409
16014410
16014445
16014525
16014547
16014549
16014643
16014716
16014717
16014718
16014743
16014803
16014818
16014841
16014861
16014865
16014906
16014929
16014931
16014987
16015035
16015057
16015069
16015082
16015091
16015093
16015103
16015106
16015270
16015273
16015288
16015297
16015311
16015343
16015380
16015382
16015401
16015486
16015489
16015490
16015561
16015601
16015627
16015707
16015732
16015738
16015745
16015755
16015761
16015762
16015800
16015855
16015862
16015865
16016118
16016121
16016267
16016283
16016398
16016480
16016547
16016617
16016663
16016685
16016717
16016725
16016874
16016919
16017018
16017032
16017046
16017101
16017161
16017180
16017287
16017306
16017322
16017334
16017338
16017369
16017389
16017404
16017439
16017494
16017645
16017721
16017775
16017823
16017932
16017982
16018144
16018478
16018479
16018486
16018506
16018516
16018592
16018617
16018751
16018804
16018821
16019003
16019136
16019322
16019504
16019665
16019720
16019777
16019909
16019953
16020063
16020119
16020271
16020528
16020682
16021064
16021521
16021549
16021665
16022116
16022551
16022562
16022962
16023202
16023828
16024050