Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with collecting data from a spreadsheet
Hi All, I am hoping someone will be able to help me out here; I currently have a spreadsheet containing stock that has been sold over the last year. Column A contains the stock code number, Column B contains a description of the stock and Column C is the quantity of stock sold for each transation. For Example, Column A Column B Column C 001 Pencil 1 001 Pencil 5 001 Pencil 2 002 Eraser 3 002 Eraser 1 003 Ruler 1 004 Glue Stick 2 004 Glue Stick 1 004 Glue Stick 1 004 Glue Stick 3 I need to add up the quantity of each product sold to get a rough estimate of how much stock we sold over the last year, (eg, Pencil = 8; Eraser = 4; Ruler = 1; Glue Stick = 7). At the moment I am scrolling thru the spreadsheet and autosumming each product to get the total quantity sold. Is there a way I can get excel to: 1. at the end of the spreadsheet list each product code & description 2. calculate the total quantities of each product sold? I dont know if this is possible, but if anyone can help me or has any suggestions that would be most appreciated. Kind Regards Justin -- JChan ------------------------------------------------------------------------ JChan's Profile: http://www.excelforum.com/member.php...o&userid=23273 View this thread: http://www.excelforum.com/showthread...hreadid=474974 |
#2
|
|||
|
|||
Hi Justin I think the easitest way to do what you are asking is to create a pivot table (Data Pivot Table and Pivot Chart Report ...) add some coloumn headings to your list and then just follow the wizard through, Set you row feilds to column A and Data Items to Column C. Cheers Shaun -- ShaunM ------------------------------------------------------------------------ ShaunM's Profile: http://www.excelforum.com/member.php...o&userid=18610 View this thread: http://www.excelforum.com/showthread...hreadid=474974 |
#3
|
|||
|
|||
Cheers Shaun!! That has made things a lot easier! Regards, Justin -- JChan ------------------------------------------------------------------------ JChan's Profile: http://www.excelforum.com/member.php...o&userid=23273 View this thread: http://www.excelforum.com/showthread...hreadid=474974 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Finding repeated data in a excel spreadsheet | Excel Discussion (Misc queries) | |||
When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |