Mac Numbers Multiple Variable Search

I've looked everywhere and can't figure out how to do a search in Mac Numbers for 2 or more words. I make wildlife movies and have Numbers lists of all my footage. I can easily find all of my clips that contain elephants with the basic Find box but I can't figure out how to find a clip of, for example, an elephant eating grass. I'm not very consistent with the way I describe clips so I can't expect to find all of the elephant eating grass clips by typing in 'elephant eating grass.' I would like to be able to search using 2 variables. For example, find all clips that have the word 'elephant' and 'grass' in the description. Any ideas?


iMac Pro, macOS 11.2

Posted on Nov 24, 2022 1:13 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 24, 2022 2:32 PM

Just create two filter, one for each criteria.

It is important that you select "Match All Filters"


This will give you only rows that match both


Hope this will solve your question, please let me know if this worked for you or if something in unclear.


Regards Ralf


Similar questions

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Mac Numbers Multiple Variable Search

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.