Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates without Sorting
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates without Sorting
Zesty,
In C2 enter the formula =IF(B2<B3,SUM($A$1:A2)-SUM($C$1:C1),"") and copy down to match column B. HTH, Bernie MS Excel MVP "Zesty" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates without Sorting
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Duplicates without Sorting
Excel 2007 Pivot Table
Group by consecutive names. http://www.mediafire.com/file/efg53a...10_15_09a.xlsx |
Reply |
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) | |||
Finding Duplicates in a Column (Without Sorting) | Excel Discussion (Misc queries) | |||
Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
When sorting, how would I omit duplicates? | New Users to Excel |