Hello,
I've got a sheet with hundreds of comments that range from 3 words to 300 words each. They are each contained within separate cells. I want to be able to type in a specific word that I'm looking for, and have excel output each entire comment where that word is found. I have set up a simple mock workbook that I will attach.
Any thoughts?
Bookmarks