In Excel 2016, I have a worksheet with two columns and many rows of data where each entry consists of a name in the first column and the fruits they like separated by commas in the other column (for example). How can I sort this data based on fruit?
I know how to sort if there is only one piece of data per cell and I can do a find all which will select all cells in the column that contain strawberries for example but I would like to sort the rows and possibly highlight the ones that contain some word (like strawberry) when there are multiple pieces of data in one cell. The user of the spreadsheet should be able to quickly find all people who like strawberries.
I have attached an example screenshot that shows how my data is organized. Would it be better to organize the data in a different way? Will this require VBA? Thanks in advance for any help.