ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Can I change the default for custom filters? (https://www.excelbanter.com/new-users-excel/109333-can-i-change-default-custom-filters.html)

cbry

Can I change the default for custom filters?
 
"Custom filte" always begins with "Show rows where <field name EQUALS ..."
I almost always use CONTAINS. Can I change the default so that it'll
automatically display CONTAINS as the starting criterion? If so, how? I'm in
Mac OS 10.4.7. Thanks.

Dave Peterson

Can I change the default for custom filters?
 
You can't change it the wintel version.

But you can fool it.

Say you want to check to see if the value contains cbry.

Use Equals and
*cbry*
surround your value with asterisks to get the equivalent of Contains

Leading asterisk (*cbry) is the same as ends with
trailing asterisk (cbry*) is the same as begins with

Why, oh, why isn't that dropdown box just a hair bigger!



cbry wrote:

"Custom filte" always begins with "Show rows where <field name EQUALS ..."
I almost always use CONTAINS. Can I change the default so that it'll
automatically display CONTAINS as the starting criterion? If so, how? I'm in
Mac OS 10.4.7. Thanks.


--

Dave Peterson

cbry

Can I change the default for custom filters?
 

"Dave Peterson" wrote:

You can't change it the wintel version.
But you can fool it... Use Equals and
*cbry*
surround your value with asterisks to get the equivalent of Contains



YEEEAAAAHHH -- works fine! A muy cool workaround. Many thanks, Dave P!


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

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