Data Filter

J

jesg

Hey guys.

I was wondering if there is a method to do the following:
Auto Filter
then filter by 3 criteria
like
Equals to = 1 and / or
Equals to = 2
Equals to = 3

does anyone know how to do it without macro ? just manually ?

tx in advance
the excel hardcore noob ;
 
D

Dave Peterson

I usually insert a helper column and devise a formula that returns what I want.

=if(or(a2=1,a2=2,a2=3),"ok","hide")

Drag down the column and filter on that helper column.

You may want to look at Data|Filter|Advanced filter
Debra Dalgleish has some instructions:
http://www.contextures.com/xladvfilter01.html
 
Top