Filter Help Need

S

Str8

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
 
M

Mike H

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
 
S

Str8

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.
 
Top