Sum Duplicates without Sorting

[Zesty]

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

 

[Bernie Deitrick]

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

 

[Bernd P]

Hello,

I suggest to use my UDF Sfreq:
http://sulprobil.com/html/sfreq.html

Regards,
Bernd

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Group by consecutive names.
http://www.mediafire.com/file/efg53anzztd/10_15_09a.xlsx