I want to take the input cells, lookup their color values, then count the color occurrences. Probably need to use array but it's my achilles heel. Thanks!!
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
A | B | C | D | E | F | G | H |
INPUT | FRUIT | COLOR | Count | ||||
APPLE | APPLE | RED | ORANGE | ?? | |||
BANANA | PEACH | ORANGE | RED | ||||
GRAPE | GRAPE | BLUE | GREEN | ||||
MELON | BERRY | BLUE | BLUE | ||||
MELON | MELON | GREEN | YELLOW | ||||
KIWI | KIWI | GREEN | |||||
BANANA | BANANA | YELLOW | |||||
ORANGE | ORANGE | ORANGE | |||||
MANGO | MANGO | ORANGE | |||||
STRAW | STRAW | RED | |||||
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>