| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
I get it, thank you Max & Bob.
Kent "Bob Phillips" bl... =ISNUMBER(MATCH(A2,{"A","B","C","D","E","F"},0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kent" wrote in message ... Dear Bob, Thanks for your reply. For example, I want to filter out the rows which column A is any of the characters from A to F, how the formula at helper column should be please? Kent "Bob Phillips" hx.gbl... You could add a helper column and create a formula that checks the 6 criteria and returns TRUE or FALSE, and then filter by that helper column. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kent" wrote in message ... Dear all, I want to auto-filter a spreadsheet with 6 criteria, but the auto-filter function of Excel only let me to input 2 criteria in the same time. Any alternative way to solve my problem please? Kent |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter - capture criteria used | Excel Discussion (Misc queries) | |||
| Is it possible to use auto filter to select more than 2 criteria? | Excel Discussion (Misc queries) | |||
| Auto Filter by Criteria | Excel Worksheet Functions | |||
| Auto Filter function | Excel Discussion (Misc queries) | |||
| How do I Provide a specific result given multiple criteria? | Excel Worksheet Functions | |||
Threaded Mode
