| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
| How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
| How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
