Hello experts,
I would need your help to write a formula to extract all the fruits in a cell, based on the list provided in a range.
For example
Input
A1----> Box1 has apples, orange Peach and banana
A2----> apple, jackfruit, in box2 along with banana and peach
A3----> Box no.3 has 100 guava,124 strawberrys
Desired Result
B1---->apples,orange,peach,banana
B2---->apple,jackfruit,banana,peach
B3---->guava,strawberry
The list of fruits to check is in the range N2:N10
Apple
Orange
Jackfruit
Guava
Strawberry
Lemon
Gooseberry
Peach
Banana
and i might add more fruits in to the list. Attached excel sheet to make it clear.
Thanks for your help.
Bookmarks