Filter

[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

 

[Pete_UK]

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

 

[Shane Devenshire]

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 D25, 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 D15
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.