Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up advance filters excel 2003
How do I set up advance filters excel 2003 using one column with mutlitple
entries. Auto filter allows only two entries and the numeric range varies. Please advise. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up advance filters excel 2003
What are your criteria? If you have multiple OR conditions you can use a
formula as criteria, use 2 cells as criteria and leave the firs one empty, then in the cell below use =OR(A2=criteria1,A2=criteria2,A2=criteria3,etc) where A2 is the first cell with data in the column you want to filter then in the criteria range refer to the empty cell and the cell with criteria i.e. if you are using L1 and L2 use (L2 would be the cell with your formula and L1 is empty) $L$1:$L$2 as criteria -- Regards, Peo Sjoblom "util" wrote in message ... How do I set up advance filters excel 2003 using one column with mutlitple entries. Auto filter allows only two entries and the numeric range varies. Please advise. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up advance filters excel 2003
You will need another set of cells that are your criteria. The first row in
the criteria must be the column headers from the main data table (the 'list range') which will be used to filter. Ex: if your list range column headers are Date, Sales and Weekday and you're going to filter on Weekday, the criteria range must have Weekday (at least) in the first row. Each subsequent row of the criteria range is one filter criteria; the result is the union of all the filters (filter1 OR filter2 OR filter3 would be the autofilter analogy). If you wanted to see the sales only on Monday, Tuesday and Wednesday, for instance, the next three rows in your criteria range would be 2, 3, 4. Then select your data table and Data Filter Advanced Filter. Specify the list range (Excel will fill this in for you if you selected the table before turning on the filter) and the criteria range (the set of cells including the headers on the criteria) and click OK. "util" wrote: How do I set up advance filters excel 2003 using one column with mutlitple entries. Auto filter allows only two entries and the numeric range varies. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 row height format | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |