Find duplicates and sum the column

[Jovinchious]

Hi everyone,

i need a bit of help...

in column A I have names like:
"Mike"
"Laura"
"Harry"
"Mike"
"Mike"
"Betty" etc..

and in column B are the values like:
2000
100
500 etc...

I need a code that will find all the duplicates in column A and sum their values in new column C, also keep the original "non-duplicated" names and values as they are...
Thanks!

 

[kevin9999]

Book1
	A	B	C
1	Name	Values	Sum
2	Mike	2000	2300
3	Laura	100	100
4	Harry	500	500
5	Mike	100	2300
6	Mike	200	2300
7	Betty	300	300
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=SUMIF($A$2:$A$7,A2,$B$2:$B$7)

 

[alansidman]

For those running Excel 2010 or later versions, here is an MCode solution

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Total", each List.Sum([Values]), type number}})
in
    #"Grouped Rows"

 

[Jovinchious]

Thanks! Helped a lot!
After that just pressed "remove dupllicates" and thats it.
Tnx!

 

[kevin9999]

Thanks! Helped a lot!
After that just pressed "remove dupllicates" and thats it.
Tnx!

Glad we could help, and thanks for the feedback