View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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