Hi,
I think it should be pretty easy, but I can't figure out a quick way of doing this. I want to find any matches (variations) of a text string in a data set.
In the attached spreadsheet, there is no consistency in the Item names. I'm looking to find all the possible box names. If it has any combinations of "A-Box", "A Box", "abox", etc. or any other way that "a box" can be written, I want to know about it (in the spreadsheet, A2, A4, A6, A8, A10 would match that criteria). This could be done through Conditional Formatting of the Item column or through a lookup formula (I'm open to any suggestions).
Please let me know of any your thoughts. Thank you in advance for your help,
Yury
Bookmarks