| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter contains part of a word
I'm trying to get an advanced filter to work so that it will bring back
all records with part of the word rather than just the start of a word. This works very well when I use AutoFilter with the "Contains" criteria. But when I do an advanced filter, only records that start with the word get filtered. What do I have to do to get all the records. Thanks... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter criteria (formula) | Excel Worksheet Functions | |||
| How do I filter columns and rows for a certain word in Excel? | Excel Discussion (Misc queries) | |||
| Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
| Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
| missing or ill egal extract range advanced filter | Excel Discussion (Misc queries) | |||
Threaded Mode
