One method is to use an auxillary column for your filtering. You can
put a formula into a new colun the would produce either a True or False
and then you can autofilter on the true or false

for example

In cell Z1
=or(A1="A",A1="D",A1="Z")

then copy formula down column Z to last row of data. Then autofilter
column Z.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160741

Microsoft Office Help