I have users input their preferences by checking certain fruits they would like to have. There are columns for all the fruit options that has a formula attached to create a
✓
if the individual chose it. If someone has a suggestion I would like for the non fruit items to go into the "Other" Column. I need help extracting only the remaining text excluding the text which already has options in columns (C - G ), if the individual selected it. Is there a way to extract the other text?
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