Spreadsheet: 215291d1361328120-need-help-sum-a-range-and-return-adjacent-data-tied-to-largest-digit-data-sheet-coc
Sheet: Descriptors - transposed

Sample | CJJ | BLL | RKR | PPS | HHC | FMM | NBL | WKK |  |  |  |  |  |  | Sample | CJJ | BLL | RKR | PPS | HHC | FMM | NBL | WKK |  |  |  |  |  |  | Sample | CJJ | BLL | RKR | PPS | HHC | FMM | NBL | WKK
GREEN FRUIT - Artichoke; High | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Buttery; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Black pepper; High | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
GREEN FRUIT - Artichoke; Low | 3 | 0 | 1 | 0 | 0 | 1 | 1 | 0 |  |  |  |  |  |  | RIPE FRUIT - Buttery; Low | 4 | 1 | 1 | 0 | 1 | 1 | 1 | 2 |  |  |  |  |  |  | OTHER - Black pepper; Low | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0
GREEN FRUIT - Artichoke; Medium | 4 | 0 | 1 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Buttery; Medium | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Black pepper; Medium | 0 | 1 | 0 | 0 | 0 | 2 | 1 | 1
GREEN FRUIT - Cinnamon; High | 5 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |  |  |  |  |  |  | RIPE FRUIT - Floral; High | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Cherry; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Cinnamon; Low | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Floral; Low | 2 | 2 | 0 | 2 | 0 | 0 | 1 | 2 |  |  |  |  |  |  | OTHER - Cherry; Low | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0
GREEN FRUIT - Cinnamon; Medium | 7 | 0 | 0 | 0 | 0 | 3 | 0 | 1 |  |  |  |  |  |  | RIPE FRUIT - Floral; Medium | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  | OTHER - Cherry; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
GREEN FRUIT - Eucalyptus; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Nutty; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Citrus; High | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Eucalyptus; Low | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Nutty; Low | 4 | 2 | 3 | 0 | 1 | 1 | 2 | 1 |  |  |  |  |  |  | OTHER - Citrus; Low | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
GREEN FRUIT - Eucalyptus; Medium | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  | RIPE FRUIT - Nutty; Medium | 2 | 0 | 3 | 2 | 0 | 1 | 1 | 1 |  |  |  |  |  |  | OTHER - Citrus; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Grass; High | 0 | 0 | 1 | 2 | 0 | 2 | 1 | 0 |  |  |  |  |  |  | RIPE FRUIT - Other; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Hay-straw; High | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0
GREEN FRUIT - Grass; Low | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 1 |  |  |  |  |  |  | RIPE FRUIT - Other; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Hay-straw; Low | 2 | 1 | 0 | 2 | 0 | 0 | 1 | 1
GREEN FRUIT - Grass; Medium | 1 | 5 | 2 | 1 | 0 | 1 | 2 | 2 |  |  |  |  |  |  | RIPE FRUIT - Other; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Hay-straw; Medium | 3 | 1 | 2 | 0 | 0 | 3 | 2 | 0
GREEN FRUIT - Green almond; High | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 |  |  |  |  |  |  | RIPE FRUIT - Ripe apple; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Other spices; High | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
GREEN FRUIT - Green almond; Low | 2 | 1 | 1 | 1 | 0 | 1 | 2 | 3 |  |  |  |  |  |  | RIPE FRUIT - Ripe apple; Low | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Other spices; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green almond; Medium | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe apple; Medium | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |  |  |  |  |  |  | OTHER - Other spices; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green apple; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe banana; High | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 |  |  |  |  |  |  | OTHER - Other; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green apple; Low | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe banana; Low | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Other; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green apple; Medium | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe banana; Medium | 2 | 0 | 1 | 1 | 1 | 1 | 0 | 0 |  |  |  |  |  |  | OTHER - Other; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green banana; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe olive; High | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Walnut shell; High | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
GREEN FRUIT - Green banana; Low | 2 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe olive; Low | 1 | 2 | 1 | 2 | 1 | 1 | 0 | 2 |  |  |  |  |  |  | OTHER - Walnut shell; Low | 1 | 1 | 3 | 0 | 2 | 1 | 1 | 2
GREEN FRUIT - Green banana; Medium | 1 | 0 | 2 | 0 | 0 | 1 | 1 | 0 |  |  |  |  |  |  | RIPE FRUIT - Ripe olive; Medium | 2 | 3 | 3 | 1 | 0 | 1 | 2 | 1 |  |  |  |  |  |  | OTHER - Walnut shell; Medium | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1
GREEN FRUIT - Green olive; High | 0 | 2 | 2 | 1 | 0 | 4 | 1 | 0 |  |  |  |  |  |  | RIPE FRUIT - Stone fruit; High | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Woody; High | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1
GREEN FRUIT - Green olive; Low | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 2 |  |  |  |  |  |  | RIPE FRUIT - Stone fruit; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Woody; Low | 0 | 2 | 2 | 0 | 2 | 0 | 2 | 0
GREEN FRUIT - Green olive; Medium | 1 | 3 | 2 | 4 | 0 | 0 | 4 | 3 |  |  |  |  |  |  | RIPE FRUIT - Stone fruit; Medium | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | OTHER - Woody; Medium | 0 | 0 | 1 | 2 | 0 | 0 | 2 | 1
GREEN FRUIT - Green tea; High | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 |  |  |  |  |  |  | RIPE FRUIT - Tropical; High | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green tea; Low | 2 | 1 | 3 | 0 | 0 | 1 | 2 | 2 |  |  |  |  |  |  | RIPE FRUIT - Tropical; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Green tea; Medium | 0 | 1 | 0 | 1 | 1 | 2 | 1 | 1 |  |  |  |  |  |  | RIPE FRUIT - Tropical; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Herbaceous; High | 0 | 0 | 1 | 2 | 0 | 1 | 2 | 0
GREEN FRUIT - Herbaceous; Low | 0 | 1 | 0 | 2 | 0 | 1 | 1 | 1
GREEN FRUIT - Herbaceous; Medium | 2 | 1 | 1 | 0 | 1 | 1 | 1 | 1
GREEN FRUIT - Mint; High | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Mint; Low | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Mint; Medium | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0
GREEN FRUIT - Other; High | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
GREEN FRUIT - Other; Low | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Other; Medium | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Pine; High | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
GREEN FRUIT - Pine; Low | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
GREEN FRUIT - Pine; Medium | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
GREEN FRUIT - Tomato leaf; High | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GREEN FRUIT - Tomato leaf; Low | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 1
GREEN FRUIT - Tomato leaf; Medium | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0
Sample Count: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample Count: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample Count:
Minimum for Validation: | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Minimum for Validation: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Minimum for Validation:
MAX |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAX |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAX
SAMPLE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE:
Artichoke |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Buttery |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black Pepper
Cinnamon |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Floral |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Eucalyptus |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nutty |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Citrus
Grass |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hay-Straw
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Spices
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ripe Olive |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Walnut Shell
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stone Fruit |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Woody
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tropical |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
Green Tea |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
Herbaceous
Mint
Pine
Tomato Leaf
Other