Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter formula for "contains="Sept"
Advanced filter formula for "contains="Sept"
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter formula for "contains="Sept"
Assuming you have already filtered your data (i.e. applied an autofilter to
your data): 1. Click on the filter arrow in the column that would contain "Sept" 2. Select "Custom" filter 3. Click drop-down box and select the word "Contains" 4. Click on the box to the right of this and type "Sept" 5. Click ok to filter with records containing "Sept" in that column "condor_tmc" wrote: Advanced filter formula for "contains="Sept" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced filter formula for "contains="Sept"
In the criteria cell, type: *Sept
condor_tmc wrote: Advanced filter formula for "contains="Sept" -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions |