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 ;

--
jes
-----------------------------------------------------------------------
jesg's Profile: http://www.excelforum.com/member.php...fo&userid=3718
View this thread: http://www.excelforum.com/showthread.php?threadid=56893

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

jesg wrote:
>
> 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
>
> --
> jesg
> ------------------------------------------------------------------------
> jesg's Profile: http://www.excelforum.com/member.php...o&userid=37180
> View this thread: http://www.excelforum.com/showthread...hreadid=568933

--

Dave Peterson