I have a list that I need to filter, but I need it to include 3 possible values

Column F has the following values: PB, BL, VA, NN, MA, EP, RT, BF, SK.

I want to only see the rows that have the following values in Column F: VA,
NN, BL

I'm sure this is very simple to do - but after being up until 3am with a
sick child and then coming in to work to do this, my mind is not computing
today. Thanks so much.

--
Sleeply in EP

You can do this with an advanced filter, not an auto filter. The main
difference (for what you want to do) is that you can set your own
criteria in another area of the spreadsheet and use that to filter the
cells

Just type the heading name from the column that contains your codes,
then under this heading, type in the 3 codes in a new row. Select your
table, then Data\Filter\Advanced Filter. In the criteria box, highlight
your just created criteria range including the header and the 3 cells
below.

Your away

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555008