DataAutofilterChoose Custom from drop down listchoose "contains" (last
option) Saturday
Repeat it for the other column!

Regards,
Stefi

€žDaren€� ezt Ã*rta:

Hello,
I have text values in 2 columns of cells that contain the word Saturday in
any length of values...e.g, The First Saturday, That Saturday was Nice. I
want to be able to use an advanced filter to show any rows that contain the
word Saturday in both columns. How can I do this assuming that Saturday can
appear in columns D and E?
Thanks.