can you filter more than two items in excel 2000

[hbqns]

I would like to filter more than two items in my worksheet

autofilter and advanced filter do not give me this capability

What steps would I have to take?

Thank you!

[Bernie Deitrick]

Make a table of the values that you want to show (let's say in G2:G10), and include a new column in
your table, with the formula

=NOT(ISERROR(MATCH(A2,$G$2:$G$10,FALSE)))

copied down. Then filter based on that column being TRUE.

HTH,
Bernie
MS Excel MVP


"hbqns" <[email protected]> wrote in message
news:[email protected]...
>I would like to filter more than two items in my worksheet
>
> autofilter and advanced filter do not give me this capability
>
> What steps would I have to take?
>
> Thank you!