Filter

  • Thread starter Thread starter ub
  • Start date Start date
U

ub

Hi
I have a drop down list in colum "A" of my Excel sheet that has 7 values. I
want to filter my results to show only those rows that satisfy 4 values in
the list.
I am using Excel 2000.
Please advise, if this can be done using any Excel function or If this can
be done writing any vba code.
Thanks
 
You can use a helper column to set up your multiple criteria, like
this:

=IF(OR(A2="a",A2="b",A2="c",A2="d"),1,0)

and copy this down. Then you could apply your autofilter to this
column, and choose 1 from the filter drop-down - this will enable you
to filter the rows where column contains a or b or c or d, but you can
amend to suit your data.

Hope this helps.

Pete
 
Hi,

That is one of the things that the Advanced Filter command allows you to do.
Enter the four items in a range, lets say D2:D5, in D1 enter the title of
column A exactly as it is displayed in your original data.

Choose Data, Filter, Advanced Filter
In the List range specify your column A range
In the Criteria range specify D1:D5
Click OK

If you upgrade to 2007 you will find that when you open the AutoFilter each
item is listed with a check box and you can quickly and easily pick any
combination of items.
 
Back
Top