can you filter more than two items in excel 2000

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

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter on more than one cells (text) 2
VBA: How can I use a string variable as autofilter criteria? 4
filter data by top 10 AND bottom 10 items simultaneously 4
Advanced Filter 2
Filtering Using Values In A Specific Cell 3
Can I use more than two conditions in custom autofilter? 2
Macro to copy value in field and insert it into filter 2
Filter - not = 3

Back
Top