Thanks If I enforce a filter on one column, it appears that I'm losing the filter when I moved and chose my next filter column.
So if I have 2 columns in a spreadsheet and I want to use as filters eg. Active and ProductActive and the ideal situation is If I marked PartActive = True, ProductActive should be True as a rule . Both should have true values. But what if certain ProductActive rows were not marked as True but it should be True, what is the safest way to it-Filter by ProductActive first then Active? If express in an SQL query , it should be something like
"If Active = True AND ProductActive = True..." This is the type filter test I have in mind...
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.