Auto Filter function only provide 2 criteria input

  • Thread starter Thread starter Kent
  • Start date Start date
K

Kent

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
 
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)
 
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
 
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
 
=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)
 
I get it, thank you Max & Bob.


Kent



Bob Phillips said:
=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)
Click to expand...
 
Back
Top