I would like to create a macros that filters 3 values.
Ex:
Lets keep it simple- Lets say column "A" looks like this-
in A1 is 1
in A2 is 2
in A3 is 3
in A4 is 4
in A5 is 5
I need to create a filter that would pull out all 1's, 2's, and 3's
Advanced filter would be perfect except to can only grab 2 values if you
could use 3 that would be perfect but doesn't look like you can?
Any ideas?
Thanks

I suspect this question is over simplified because to do what you describe
here is as simple as a

Data|Autofilter

select Custom

Cell value is
less than or equal to
3.

Mike

"Str8" wrote:

I would like to create a macros that filters 3 values.
Ex:
Lets keep it simple- Lets say column "A" looks like this-
in A1 is 1
in A2 is 2
in A3 is 3
in A4 is 4
in A5 is 5
I need to create a filter that would pull out all 1's, 2's, and 3's
Advanced filter would be perfect except to can only grab 2 values if you
could use 3 that would be perfect but doesn't look like you can?
Any ideas?
Thanks

Hi Str8,

Perhaps you are confusing the Advanced
Filter and Autofilter tools.

Try using Advanced Filter; perhaps after
looking at Debra Dalgleish's AF criteria
tutorial at:


Excel -- Filters -- Advanced Filter -- Complex Criteria
http://www.contextures.com/xladvfilter02.html




---
Regards.
Norman


"Str8" wrote in message
...
I would like to create a macros that filters 3 values.
Ex:
Lets keep it simple- Lets say column "A" looks like this-
in A1 is 1
in A2 is 2
in A3 is 3
in A4 is 4
in A5 is 5
I need to create a filter that would pull out all 1's, 2's, and 3's
Advanced filter would be perfect except to can only grab 2 values if you
could use 3 that would be perfect but doesn't look like you can?
Any ideas?
Thanks

Hey Mike, it's a little bit more complex then that but I wanted to try and
keep it simple.
Basically I have a column with zip codes. I would like an auto filter setup
to only filter three specific zip codes.
So the column could have 50 zip codes but I only want to filter any row that
has any of the three zip codes I need. Hope that's clear.

Norman thanks for the link I'll take a peek at it.

Thanks again for the qiuck replies.

"Mike H" wrote:

I suspect this question is over simplified because to do what you describe
here is as simple as a

Data|Autofilter

select Custom

Cell value is
less than or equal to
3.

Mike

"Str8" wrote:

I would like to create a macros that filters 3 values.
Ex:
Lets keep it simple- Lets say column "A" looks like this-
in A1 is 1
in A2 is 2
in A3 is 3
in A4 is 4
in A5 is 5
I need to create a filter that would pull out all 1's, 2's, and 3's
Advanced filter would be perfect except to can only grab 2 values if you
could use 3 that would be perfect but doesn't look like you can?
Any ideas?
Thanks