| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to filter spreadsheet by multiple variables?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? Wow, that works great Max, and so simple - my favorite kind of solution, thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to filter spreadsheet by multiple variables?
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, 2 ways 1. If there's no in-between blank cells in col A, just double click on the fill handle 2. Type the range in the namebox*, eg, type: B2:B10000 Press ENTER, this selects the range with B2 active Paste the formula into the formula bar, then just press CTRL+ENTER *the dropdown just to the left of the formula bar -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to filter spreadsheet by multiple variables?
welcome, Joe.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joe" wrote Wow, that works great Max, and so simple - my favorite kind of solution, thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple variables-SOS | Excel Worksheet Functions | |||
| look for a value with multiple variables | Excel Discussion (Misc queries) | |||
| How do I set up a spreadsheet with 3 different variables | Excel Discussion (Misc queries) | |||
| Calculating on multiple variables | Excel Discussion (Misc queries) | |||
| Formula for counting multiple variables in a spreadsheet | Excel Worksheet Functions | |||
Linear Mode
