Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting&Computing results
Hi All,
Is me again.. having some problems. Do help me, thanks! Trying to create something like this: Let say I have a set of records running disorder from class A,B,C,D,E,F,G,etc and marks range from 10,20,30,40,50. from years 2000,2001,2002,2003,2004,2005,2006. Now, i trying to create a new table (mayb in a new tag) to store combine total marks for that particular year for each A,B,C,D,E,F,G. For example: Class Date Makrs A 5-aug-06 10 A 5-aug-05 20 B 5-aug-03 30 C 5-aug-02 30 D 5-aug-01 40 D 5-aug-04 20 G 5-aug-06 20 A 5-aug-05 30 E 5-aug-06 20 F 5-aug-04 40 G 5-aug-02 20 G 5-aug-01 50 F 5-aug-03 50 after sorting the table can look like this: Year |2000|2001|2002|2003|2004|2005|2006| ------------------------------------------------------- A B C D E F G -------------------------------------------------------- Total -------------------------------------------------------- any way just using the excel inside or do i have to use visua basic? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
Returning Numeric Results across a Single Row in Consecutive Cells | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) |