LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
use list box text for advanced filter on dblClick sdaenitz Excel Discussion (Misc queries) 0 December 1st 08 06:59 PM
Building criteria string for Advanced Filter variable not resolvin JEFFWI Excel Discussion (Misc queries) 1 August 29th 07 07:52 PM
Need Advanced Filter with NOT equal string and OR criteria MK Excel Discussion (Misc queries) 5 December 7th 05 02:28 PM
Advanced Filter using Date represented as text drice Excel Worksheet Functions 1 December 15th 04 04:56 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 08:38 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"