Spreadsheet: 850923d1701231763-formula-to-return-range-based-on-criteria-example-1
Sheet: Specific Example

[NAME] | 0.3
Country | Product Family | Median | Low | High | Fit range | Pop | % | Assessment
Country A | Product A
Country A | Product B
Country A | Product C
Country B | Product A
Country B | Product B
Country B | Product C
Country | Product | Sales Price USD
Country A | Product A | 2.316381559775419
Country A | Product A | 2.316381559775419
Country A | Product A | 2.380724308063048
Country A | Product A | 2.573755641434686
Country A | Product A | 7.385270999999995
Country A | Product A | 11.58191320376739
Country A | Product A | 11.58191320376739
Country A | Product A | 11.58191320376739
Country A | Product A | 11.58191320376739
Country A | Product A | 11.58191320376739
Country A | Product A | 13.499577
Country A | Product A | 13.499577
Country A | Product A | 13.5
Country A | Product A | 13.5
Country A | Product A | 13.5
Country A | Product A | 14.15567669516181
Country A | Product A | 14.15567669516181
Country A | Product A | 19.9985
Country A | Product A | 21.87691757304211
Country A | Product A | 21.87691757304211
Country A | Product A | 24.45072712182321
Country A | Product A | 27.02441771154242
Country A | Product A | 29.59820655444613
Country A | Product A | 29.59820655444613
Country A | Product A | 40.0017
Country A | Product A | 40.0017
Country A | Product A | 40.0017
Country A | Product A | 40.0017
Country A | Product A | 42.46693889726468
Country A | Product A | 42.46693889726468
Country A | Product A | 42.46693889726468
Country A | Product B | 3.333176000000001
Country A | Product B | 11
Country A | Product B | 11
Country A | Product B | 11
Country A | Product B | 11.000294
Country A | Product B | 11.000294
Country A | Product B | 11.000294
Country A | Product B | 12.86878229944753
Country A | Product B | 12.86878229944753
Country A | Product B | 12.86878229944753
Country A | Product B | 12.86878229944753
Country A | Product B | 12.86878229944753
Country A | Product B | 12.8687921054628
Country A | Product B | 12.8687921054628
Country A | Product B | 12.8687921054628
Country A | Product B | 12.8687921054628
Country A | Product B | 12.8687921054628
Country A | Product B | 22
Country A | Product B | 22
Country A | Product B | 22
Country A | Product B | 22.00058799999999
Country A | Product B | 22.00058799999999
Country A | Product B | 32.17198026365698
Country A | Product B | 32.17198026365698
Country A | Product B | 36.03259689343635
Country A | Product B | 36.03262623426944
Country A | Product C | 0.0100325959926213
Country A | Product C | 0.01029374227591308
Country A | Product C | 0.04116453251784691
Country A | Product C | 0.04116453251784691
Country A | Product C | 0.04116453251784691
Country B | Product A | 17.0004
Country B | Product A | 20
Country B | Product A | 20
Country B | Product A | 20
Country B | Product A | 20.0012
Country B | Product A | 20.0012
Country B | Product A | 24.9984
Country B | Product A | 24.9984
Country B | Product A | 24.9984
Country B | Product A | 24.9984
Country B | Product A | 31.9982
Country B | Product A | 31.9982
Country B | Product B | 4.916094999999999
Country B | Product B | 9.7488
Country B | Product B | 10.8115
Country B | Product B | 10.8115
Country B | Product B | 14.399
Country B | Product B | 14.4515
Country B | Product B | 19.0015
Country B | Product B | 19.6675
Country B | Product B | 19.999
Country B | Product B | 19.999
Country B | Product B | 20.5555
Country B | Product B | 21.30963200000001
Country B | Product B | 22.6675
Country B | Product B | 25.0005
Country B | Product B | 25.0005
Country B | Product B | 25.0005
Country B | Product B | 28
Country B | Product B | 29.001
Country B | Product B | 29.9145
Country B | Product B | 33.150683
Country B | Product B | 33.150683
Country B | Product B | 33.150683
Country B | Product B | 33.150683
Country B | Product B | 35
Country B | Product B | 35
Country B | Product B | 39.335
Country B | Product B | 40.000444
Country B | Product B | 40.000444
Country B | Product B | 40.000444
Country B | Product B | 40.000444
Country B | Product B | 45
Country B | Product B | 45
Country B | Product B | 45.335
Country B | Product B | 50
Country B | Product B | 50
Country B | Product B | 50
Country B | Product B | 50
Country B | Product B | 59.49883500000001
Country B | Product B | 64.99851399999999
Country B | Product B | 64.99851399999999
Country B | Product B | 67.9996
Country B | Product B | 71.503944
Country B | Product B | 71.503944
Country B | Product B | 71.503944
Country B | Product C | 0.007499999999999973
Country B | Product C | 0.01014000000000002
Country B | Product C | 0.016675
Country B | Product C | 0.069984
Country B | Product C | 0.069984
Country B | Product C | 0.069984
Country B | Product C | 0.09998800000000001
Country B | Product C | 0.11
Country B | Product C | 0.11
Country B | Product C | 0.11
Country B | Product C | 0.114318
Country B | Product C | 0.11502
Country B | Product C | 0.123228
Country B | Product C | 0.123228
Country B | Product C | 0.123228
Country B | Product C | 0.17
Country B | Product C | 0.18198
Country B | Product C | 0.1852200000000001
Country B | Product C | 0.19
Country B | Product C | 0.2
Country B | Product C | 0.2
Country B | Product C | 0.2
Country B | Product C | 0.22
Country B | Product C | 0.23994
Country B | Product C | 0.27999
Country B | Product C | 0.27999
Country B | Product C | 0.27999
Country B | Product C | 0.28998
Country B | Product C | 0.29
Country B | Product C | 0.29
Country B | Product C | 0.3002400000000001
Country B | Product C | 0.401706
Country B | Product C | 0.48
Country B | Product C | 0.50136
Country B | Product C | 0.51
Country B | Product C | 0.555
Country B | Product C | 0.555
Country B | Product C | 0.555
Country B | Product C | 0.65
Country B | Product C | 0.65
Country B | Product C | 0.65
Country B | Product C | 0.800016