Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working in the Advanced Filter in 2003 Excel
I have typed on the first line this formula 1/1/05 & < 300.00 ,
for 2 criteria info. just under the Headers, Then there's a 5 line spread So there's 2 sets of headers and then my list of (household inventory) several lines of my stuff. I've selected the Filter from Data menu, I can use the AutoFilter arrows on this list, now I'm stuck. I require help from somebody that knows this stuff. I need this information as soon as possible...help thanks Hydz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
working in the Advanced Filter in 2003 Excel
If you're using the AutoFilter arrows, you don't need criteria in a
criteria range. Click the arrow in the date column, and then click (Custom...) From the first dropdown, select Is greater than In the box to the right, enter your date Then, click the arrow in the number column, and then click (Custom...) From the first dropdown, select Is less than In the box to the right, enter your number Hydz wrote: I have typed on the first line this formula 1/1/05 & < 300.00 , for 2 criteria info. just under the Headers, Then there's a 5 line spread So there's 2 sets of headers and then my list of (household inventory) several lines of my stuff. I've selected the Filter from Data menu, I can use the AutoFilter arrows on this list, now I'm stuck. I require help from somebody that knows this stuff. I need this information as soon as possible...help thanks Hydz -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Advanced filter does not effect data list | Excel Discussion (Misc queries) | |||
Is there an Excel 2003 Advanced Filter Bug?! | Excel Discussion (Misc queries) | |||
Excel 2002/2003 Advanced Filter | Setting up and Configuration of Excel | |||
Advanced Filter not working | Excel Worksheet Functions | |||
Advanced Filter Not Working | Excel Discussion (Misc queries) |