autofilter - custom...
 

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

autofilter - custom...
 

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

autofilter - custom...
 

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