View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default Advanced Filter for Text String

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.