ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Advanced filter formula for "contains="Sept" (https://www.excelbanter.com/excel-worksheet-functions/110084-advanced-filter-formula-contains%3D-sept.html)

condor_tmc

Advanced filter formula for "contains="Sept"
 
Advanced filter formula for "contains="Sept"

Boo

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"


Debra Dalgleish

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com