I'm working with a poor survey tool and the data export is a mess.
I have a cell that contains a list of multiple strings (activities) that the survey responded selected. How can I search this cell for a specific string/activity and return a value of 1 when found? See attached file for desired results. I have tried a mess of formulas that have not worked, I'm not even going to post what I've tried to save myself embarrassment.
Search String Example.xlsx