I have a large table that looks like this:
ID String 1 abcde 2 defgh 3 defgh 4 defgh 5 ijkl 6 ijkl 7 mnop 8 qrst
I want to selectivley hide rows by populating a list of filterd values. For example, I'd like to filter out (hide) all rows that contain 'ef', 'kl', and 'qr'. Is there an easy way to do this?
I know how to use Advanced filters to include only the rows that contain those substrings, but not the inverse. Has anyone does this before?