View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to filter spreadsheet by multiple variables?

.. Say I have a column with variables a-z. Is it
possible to filter all the rows with b,c, j, p and x?


Use helper col to flag it, then autofilter on the helper
Eg if data in A2 down,
you could place this in B2:
= -- ISNUMBER(MATCH(A2,{"b";"c";"j";"p";"x"},0))
Copy B2 down to the last row of data in col A,
then just autofilter on the col B, selecting: 1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Joe" wrote in message
...
I know I can use autofilter to find certain criteria that exist in
rows within the same column. Is it possible to sort by mutiple
variables, like 2 or 10? Say I have a column with variables a-z. Is it
possible to filter all the rows with b,c, j, p and x?