Filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can do this with an advanced filter, not an auto filter. The mai
difference (for what you want to do) is that you can set your ow
criteria in another area of the spreadsheet and use that to filter th
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 you
table, then Data\Filter\Advanced Filter. In the criteria box, highligh
your just created criteria range including the header and the 3 cell
below.

Your away

Mat
 
Back
Top