Advanced filter formula for "contains="Sept"

's Computer Specifications

's Computer Specifications

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"

's Computer Specifications

In the criteria cell, type: *Sept

condor_tmc wrote:
> Advanced filter formula for "contains="Sept"

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
advanced filter criteria "begins with" and "does not begin with"	=?Utf-8?B?cmFwaF9iYXJpbA==?=	Microsoft Excel Worksheet Functions	3	28th Jun 2005 10:38 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du	=?Utf-8?B?VEM=?=	Microsoft Excel Worksheet Functions	1	12th May 2005 02:06 AM
Outlook 2002 SP3 -> Tasks -> Custom Filter -> Advanced - ignores condition/value "between"/"last year and next friday"	pluto@jupiter.info	Microsoft Outlook	1	27th Jan 2005 05:11 PM
Customize Current View > Filter > Advanced > Feild="Location", Condition="is not empty"	=?Utf-8?B?SnVzdGlu?=	Microsoft Outlook Calendar	5	24th Mar 2004 03:08 AM
"More Advanced" button on "Using Colors" Filter	TechWriterMpls	Microsoft Outlook	0	20th Mar 2004 03:56 AM