| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a summary from a data dump
Hello, I have been trying to figure this out for some time now... I am soo lost... please help I have a data sheet which contains data for about forty products. For each month a new row for data is added for each one of the products. the raw data column are organized with the following headers Date(in A1) Product name (in B1) Price(in C1) MonthReturn(in D1) from launch |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a summary from a data dump
have you tried using a pivot table report in the data menu.
-- Regards, Tom Ogilvy "awaisb" wrote in message ... Hello, I have been trying to figure this out for some time now... I am soo lost... please help I have a data sheet which contains data for about forty products. For each month a new row for data is added for each one of the products. the raw data column are organized with the following headers Date(in A1) Product name (in B1) Price(in C1) MonthReturn(in D1) from launch |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a summary from a data dump
unfortunately i am not too familiar with pivot tables.... : -- awais ----------------------------------------------------------------------- awaisb's Profile: http://www.excelforum.com/member.php...fo&userid=2760 View this thread: http://www.excelforum.com/showthread.php?threadid=47165 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a summary from a data dump
Look under P for Pivot Tables on this page:
http://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "awaisb" wrote in message ... unfortunately i am not too familiar with pivot tables.... :( -- awaisb ------------------------------------------------------------------------ awaisb's Profile: http://www.excelforum.com/member.php...o&userid=27606 View this thread: http://www.excelforum.com/showthread...hreadid=471658 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
creating a summary from a data dump
unfortunately i am not too familiar with pivot tables.... :( -- awaisb ------------------------------------------------------------------------ awaisb's Profile: http://www.excelforum.com/member.php...o&userid=27606 View this thread: http://www.excelforum.com/showthread...hreadid=471658 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating regional summary data | Excel Discussion (Misc queries) | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| Creating a summary list from source data - can you?? | Excel Discussion (Misc queries) | |||
| Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions | |||
| Creating a summary from existing spreadsheet data ... | Excel Programming | |||
Hybrid Mode
