I need to seach a column, or an entire worksheet, for more than one term. For example, I want to find “red” or “blue”. Why is this so difficult?
Filtering doesn’t help because there are 100’s of cells in the column with different terms. If I filtered, I would have to scan the filter selections manually, which wouldn’t be any easier than looking at the document.
Would it help that the mulitiple terms are the same for each doc? Thanks!