Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, sort, lookup from other sheet
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: http://www.excelforum.com/attachment.php?postid=4231 | +-------------------------------------------------------------------+ -- falloutx ------------------------------------------------------------------------ falloutx's Profile: http://www.excelforum.com/member.php...o&userid=30560 View this thread: http://www.excelforum.com/showthread...hreadid=502097 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, sort, lookup from other sheet
You can use an advanced filter to extract data. There are instructions
here that may help you get started: http://www.contextures.com/xladvfilter01.html And a few sample files: http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List with Chart' falloutx wrote: 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: http://www.excelforum.com/attachment.php?postid=4231 | +-------------------------------------------------------------------+ -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, sort, lookup from other sheet
Thanks for the tip, I am playing around with the advance filtering! :) -- falloutx ------------------------------------------------------------------------ falloutx's Profile: http://www.excelforum.com/member.php...o&userid=30560 View this thread: http://www.excelforum.com/showthread...hreadid=502097 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i sort a protected sheet | Excel Discussion (Misc queries) | |||
Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
PASTE SUBTOTALS IN EXCEL TO ANOTHER SHEET TO DO ANOTHER SORT | Excel Discussion (Misc queries) | |||
Lookup from another sheet | Excel Worksheet Functions |