N
nippalony
Omg i am quite the excel n00b but i need to know 
i just cant fin
what an excel spreadsheet summary is..anyone have any idea
i just cant finwhat an excel spreadsheet summary is..anyone have any idea
M
msnews.microsoft.com
Maybe if you try and explain what you would like to be able to do,nippalony said:Omg i am quite the excel n00b but i need to know
what an excel spreadsheet summary is..anyone have any idea?
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
K
Ken Wright
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.
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.