Gentle wizards/sorceresses of excelforum,
I am absolutely useless for programming, so much so, in fact, that I don't even know how hard or easy this request would be to fill. This could be the equivalent of asking you to kindly create a rocket ship using parts of my car, or asking you to tie my shoes for me: I don't know. I've got a spreadsheet I use at work that's roughly 30,000 lines long (and growing every day) that I have to search hundreds of times per day for specific, unique commodity lists my company deals with. I'm looking to make that search easier.
Sample.xlsx
What I'm looking for is a formula that turns the cell containing the word "description" into a search field that will filter out any row that doesn't contain EACH term I enter in the field (including words *containing* the words I enter). For instance, if I entered the word "brake" into the search field, I would want the commodities corresponding to codes 333333.3333, and 555555.5555 to appear and all other commodities to be hidden. If I entered the words "auto parts," I would want only commodities 55555.5555 and 777777.7777 to appear. I need both "code" columns of any row that is a match to remain visible as well. When I clear the contents of the search cell, I'd want the entire spreadsheet to return, unfiltered. Basically, I'd like a cell that operates exactly like Excel's filter for "Containing X *and* Containing Y" does, only it would allow for any number of words to be entered. If that's impossible, 10 words would be sufficient. Some of the descriptions in our spreadsheet are very lengthy, and keying in on them is difficult.
If I've been unclear in any particulars, please feel free to ask questions. I do appreciate any help that you might provide. I pray that I haven't broken any of the forum rules with this thread, and if I have, please let me know.
Bookmarks