is it possible to filter a sheet of data where I have multiple groups of selections?
ie.. filter a sheet of data where (column a) is greater than 30 days from today and (column b) doesn't contain the word dog or
if (column b) does contains dog, and (column a) is less than 60 days hid that row.
so, my visible data will show all records that are older than 30 days without the word dog and all rows with or without dog that is greater than 60 days.
I messed with filters and advanced filter and thought i would probably have to use a array of some kind (helper column) then filter on that value
Thanks
ie.. filter a sheet of data where (column a) is greater than 30 days from today and (column b) doesn't contain the word dog or
if (column b) does contains dog, and (column a) is less than 60 days hid that row.
so, my visible data will show all records that are older than 30 days without the word dog and all rows with or without dog that is greater than 60 days.
I messed with filters and advanced filter and thought i would probably have to use a array of some kind (helper column) then filter on that value
Thanks