We need the ability to search for multiple keywords within one cell, throughout our entire workbook. For example - If we want to search for a Peyton Manning Blue Refractor, we would like to be able to search using the words "manning blue" or "peyton manning refractor" and have it find anything that has those words in a cell, not necessarily in that order. We copy titles from places we purchase items from and they aren't consistent in the order they are structured. Currently, we are stuck searching through all Peyton Manning cards or all "blue refractors", because we can't break up the search words within a cell.
I don't know if there is a plug-in you can use or a setting within excel that can change that.
I hope this makes sense. Any help is appreciated. Thanks!
I don't know if there is a plug-in you can use or a setting within excel that can change that.
I hope this makes sense. Any help is appreciated. Thanks!