If the column headers are in D1:E1, then somewhere where you have space, say
M1:M2, enter this formula in M2 leacing M1 blank:
=OR(NOT(ISERROR(FIND("Saturday",D2))),NOT(ISERROR( FIND("Saturday",E2))))
then use M1:M2 as your criteria cells in the advanced filter dialog.
Bob Umlas
Excel MVP

"Daren" wrote in message
...
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.