Quote Originally Posted by DanMnz
Yes, thank you, that answer does help me.

"non-contiguous columns" is where the problem is. Thought I could find a way around that, but I guess I cannot.

Thank you.
If the book is reasonably stable you could use some VBA code on a 'Worksheet_Change' trigger to test and remove any criteria that had been applied to Criteria1 or Criteria5 such as for

Selection.AutoFilter Field:=1, Criteria1:="Monday"
you would clear by using
Selection.AutoFilter Field:=1
but if you are not versed in VB then this could be fraught with danger.

---