Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Consolidation
I have a large list (2000 entries) which contains about 60 different
categories. Right now, I have it listed like this: Category A - Value 1 Category A - Value 2 Category A - Value 3 Category B - Value 1 .... etc. Is there a nice way to consolidate this so that I have: Category A - Sum of all A Values Category B - Sum of all B Values ...etc? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data consolidation | Excel Discussion (Misc queries) | |||
consolidation of data from other worksheet | Excel Worksheet Functions | |||
Need how-to or example for data consolidation | Excel Worksheet Functions | |||
Problem with Data Consolidation | Excel Discussion (Misc queries) | |||
data consolidation | Excel Discussion (Misc queries) |