If I have spreadsheet with 2 columns. Each colum containing a list of names. Lest say column A has Bob, Joe, and Steve in that order. And column B has Joe Steve and Bob int hat order.
How would I filter out all the records that have Bob at once.
If I filter column A for Bob I right away lose the next two rows so I can't further filter column B for Bob too.
Basically is there a way to have multiple column filters work as an AND, meaning together with the previous filters.