how to filter spreadsheet by multiple variables?
On Mar 14, 1:44 am, "Max" wrote:
.. 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
Singaporehttp://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?
one other quick question, is there another way to copy the b2 equation
down the list other than dragging it? It's a very long spreadsheet,
thanks
|