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. |
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 |
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