software

I am very new with excel and is tasked to do a project. I am pretty
stucked and will be glad if I can get any help. I have a database
sheet, a chart1 sheet and chart2 sheet. I am required to build graphs
from certain information. The interface needs to be simple for anyone
to use.

1) I need to extract data from col 'DP PPM' the database sheet where
the col 'L'=1 and the col 'Week' matches the week in the chart1 sheet,
else returns 0. I tried vlookup, but did not know how to input multiple
conditions for the lookup. And vlookup only allows me to compare the
first column.

2) I need to extract info from database automatically (or with a press
of a button) and place it in chart2 sheet. The filtering condition is
from database sheetm, col'L'=4, we need to extract the info from col
'defect description' and col 'DP PPM' to chart2 sheet. I only need the
top 10 from DP PPM to be extracted.

Is the above possible in Excel as I am only suppose to do it in Excel
format. I will appreciate your help and inputs. -------------------------------------------------------------------
|Filename: chart.zip |
|Download: www.excelforum.com/attachment.php?postid=4231 |
-------------------------------------------------------------------

--
falloutx
------------------------------------------------------------------------
falloutx's Profile: www.excelforum.com/member.php...oamp;userid=30560
View this thread: www.excelforum.com/showthread...hreadid=502097You can use an advanced filter to extract data. There are instructions
here that may help you get started:

www.contextures.com/xladvfilter01.html

And a few sample files:

www.contextures.com/excelfiles.html

Under Filters, look for 'Product List with Chart'

falloutx wrote:
gt; I am very new with excel and is tasked to do a project. I am pretty
gt; stucked and will be glad if I can get any help. I have a database
gt; sheet, a chart1 sheet and chart2 sheet. I am required to build graphs
gt; from certain information. The interface needs to be simple for anyone
gt; to use.
gt;
gt; 1) I need to extract data from col 'DP PPM' the database sheet where
gt; the col 'L'=1 and the col 'Week' matches the week in the chart1 sheet,
gt; else returns 0. I tried vlookup, but did not know how to input multiple
gt; conditions for the lookup. And vlookup only allows me to compare the
gt; first column.
gt;
gt; 2) I need to extract info from database automatically (or with a press
gt; of a button) and place it in chart2 sheet. The filtering condition is
gt; from database sheetm, col'L'=4, we need to extract the info from col
gt; 'defect description' and col 'DP PPM' to chart2 sheet. I only need the
gt; top 10 from DP PPM to be extracted.
gt;
gt; Is the above possible in Excel as I am only suppose to do it in Excel
gt; format. I will appreciate your help and inputs.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: chart.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4231 |
gt; -------------------------------------------------------------------
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
Thanks for the tip, I am playing around with the advance filtering! --
falloutx
------------------------------------------------------------------------
falloutx's Profile: www.excelforum.com/member.php...oamp;userid=30560
View this thread: www.excelforum.com/showthread...hreadid=502097