| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter for Text String
In the meanwhile Bob gave a solution!
Stefi Daren ezt *rta: Thanks, that worked for one of the columns, but when I did it for the other column, the combined function acted as an "and" statement that only filtered rows that contained Saturday in both columns. I need the function to show all rows that contain Saturday in either column D or E. How can I do that? "Stefi" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use list box text for advanced filter on dblClick | Excel Discussion (Misc queries) | |||
| Building criteria string for Advanced Filter variable not resolvin | Excel Discussion (Misc queries) | |||
| Need Advanced Filter with NOT equal string and OR criteria | Excel Discussion (Misc queries) | |||
| Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
