Group:  Microsoft Excel ยป microsoft.public.excel.newusers
Thread: Can I change the default for custom filters?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Can I change the default for custom filters?
cbry 11.09.2006 06:50:01
"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.
Re: Can I change the default for custom filters?
Dave Peterson <petersod[ at ]verizonXSPAM.net> 11.09.2006 13:12:10
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:
[Quoted Text]
>
> "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
Re: Can I change the default for custom filters?
cbry 12.09.2006 02:58:01

"Dave Peterson" wrote:

[Quoted Text]
> 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!

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net