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

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

--
__________________________________
HTH

Bob

"mariekek5" wrote in message
...
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

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

On Tue, 16 Jun 2009 07:15:02 -0700, mariekek5
wrote:

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