ExcelBanter - can you filter more than two items in excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - can you filter more than two items in excel 2000 (https://www.excelbanter.com/excel-worksheet-functions/44959-can-you-filter-more-than-two-items-excel-2000-a.html)

hbqns

can you filter more than two items in excel 2000

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" wrote in message
...
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!

All times are GMT +1. The time now is 07:24 PM.