autofilter - custom...

[mariekek5]

Hi,

My autofilter (Excel 2003) gives me several options:
- all
- top 10
- custom
- x
- y
- z
- etc.

2 questions:

1) Is it possible with custom to select more than 2 things....now I can use
equals x or equals y ... but not equals x or y or z.

2) is it possible to create a custom that will stay in the options? Like if
I want the option to show x and y, do I need to customize that eveytime,...or
can I make an extra option in de drop down box with "x and y" automatically
in it?

Thanks in advance.

Regards,
Marieke

 

[Bob Phillips]

Simplest way is to add a helper column and test the conditions there, such
as

=OR(B2="x",B2="y",B2="z")

copy down and filter the helper column on TRUE

 

[Gord Dibben]

In Custom you can choose two options only using And/Or

To retain those settings you would create a macro and run that macro.


Gord Dibben MS Excel MVP