|
A |
B |
C |
D |
E |
F |
G |
H |
1 |
person name |
selection / other |
cherries |
strawberries |
grapes |
oranges |
mangoes |
Other |
2 |
Jill |
cherries, grapes, mangoes, Almonds, cottage cheese |
✓ |
|
✓ |
|
✓ |
trying to get formula to solve and return only Almonds, cottage cheese since it is not one of the options in Columns (C - G) |
3 |
Kirk |
strawberries, grapes, trail mix |
|
✓ |
✓ |
|
|
trying to get formula to solve and return only trail mix since it is not one of the options in Columns (C - G) |
4 |
Nancy |
cherries, plain coconut milk yogurt |
✓ |
|
|
|
|
trying to get formula to solve and return only plain coconut milk yogurt since it is not one of the options in Columns (C - G) |
5 |
Joe |
grapes, oranges, limes or lemons |
|
|
✓ |
✓ |
|
trying to get formula to solve and return only limes or lemons since it is not one of the options in Columns (C - G) |
6 |
Larry |
cherries, strawberries, grapes, oranges, mangoes, maple syrup |
✓ |
✓ |
✓ |
✓ |
✓ |
trying to get formula to solve and return only maple syrup since it is not one of the options in Columns (C - G) |
7 |
Jane |
strawberries, mangoes, coffee, creamer, sugar |
|
✓ |
|
|
✓ |
trying to get formula to solve and return only coffee, creamer, sugar since it is not one of the options in Columns (C - G) |
8 |
|
|
|
|
|
|
|
|
Bookmarks