If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wth is an excel summary? and structure diagram?
Omg i am quite the excel n00b but i need to know :P i just cant find
what an excel spreadsheet summary is..anyone have any idea? --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Wth is an excel summary? and structure diagram?
nippalony wrote:
Omg i am quite the excel n00b but i need to know :P i just cant find what an excel spreadsheet summary is..anyone have any idea? --- Message posted from http://www.ExcelForum.com/ Maybe if you try and explain what you would like to be able to do, someone would help. Are you trying to sum a column or row? Do you want to add values from several sheeet onto a seperate sheet? just state exactly what you would like to accomplish and the people here can be quite helpful. gls858 |
#3
|
|||
|
|||
Wth is an excel summary? and structure diagram?
With just the info you have provided I would guess that someone is expecting you
to take a bunch of raw data, much like a dump out of a mainframe, or database, and then summarise that data in a nice friendly manner such as Excel's Pivot tables will do for you, eg:- A B 1 Code Val 2 b 3 3 a 1 4 c 2 5 c 2 6 b 3 7 a 1 8 b 1 9 a 4 One example of a summary of the above would be D E 1 Code Sum of Val 2 a 6 3 b 7 4 c 4 This is all achieved automatically by using something like a Pivot table though, and you don't do it all manually :-) As to the structure diagram, hard to say without more info and an example of your data. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "nippalony " wrote in message ... Omg i am quite the excel n00b but i need to know :P i just cant find what an excel spreadsheet summary is..anyone have any idea? --- Message posted from http://www.ExcelForum.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.682 / Virus Database: 444 - Release Date: 11/05/2004 |
Thread Tools | |
Display Modes | |
|
|