Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates in Groups
I have a file that has quantity and codes. Each code has an amount, but they
are different amounts and the code duplicates many times. I need a formula that totals each group of codes. The codes cannot be sorted so they are all together they must be separate to keep lots together. C = The results I would like to have. A B C 10 AR5 10 25 AC6 25 AC6 50 15 AR5 25 AR5 25 AR5 65 12 AC6 10 AC6 22 22 XR6 Any help would be appreciated!! Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
SUM OF GROUPS | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |