I have a spreadsheet with thousands of rows. I want to show only those rows where Column A contains any of the following words (not case sensitive): cat, dog, bird, pigeon, lizard
I have figured out how to make a text filter, but it only allows me to designate 2 words. I'm not sure how to do it for 5 words. Thanks!