Filter Help Need
 

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

Filter Help Need
 

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

Filter Help Need
 

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

Filter Help Need
 

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