Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
One thought ..
Assuming source letters running in A2 down (eg: A, B, .. ) and that case sensitivity is not an issue You could use in say, E2: =ISNUMBER(MATCH(A2,{"A";"B";"C";"D";"E";"F"},0)) Copy down, then filter on col E for TRUE -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kent" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter function only provide 2 criteria input
=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 |
#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 |
Reply |
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 |