| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advance filtering with multiple conditons
I have a problem with the filtering options for the advance filtering and hope someone can help me with it. Sheet1 is my database and Sheet 2 is the information I need to plot a graph 1) Sheet1!G1:I2 contains the advance filtering criteria, I want to find only Level 2 and within the week range stated in Sheet2!E1:G1. But it does not work. 2) Can I plot 2 different graphs into a single chart? Eg. Using the information gotten out in Sheet2!A1:B11, I plot graph 1. and using the same x axis(Part) and the value in the Target column in sheet2 to plot graph 2. Can I place both graphs in the one chart? +-------------------------------------------------------------------+ |Filename: report.zip | |Download: http://www.excelforum.com/attachment.php?postid=4236 | +-------------------------------------------------------------------+ -- falloutx ------------------------------------------------------------------------ falloutx's Profile: http://www.excelforum.com/member.php...o&userid=30560 View this thread: http://www.excelforum.com/showthread...hreadid=502492 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering for multiple sheets | Excel Discussion (Misc queries) | |||
| Filtering on multiple columns | Excel Discussion (Misc queries) | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
| Filtering Text Data from Multiple columns | Excel Worksheet Functions | |||
Threaded Mode
