Sum duplicate rows and delete duplicates

[pdjm12]

Hi

I'm working on a spreadsheet that looks like this
collumn A is the product code, B the product and C the quantity we need to sum

312	apple	12
652	orange	10
252	banana	3
111	lemon	1
652	orange	5
312	apple	8
252	banana	2
111	lemon	1
...	...	...

And this is what I'm trying to achieve without sucess with excel vba. I tried searching the forum but I can't make it work. Is this possible? Thanks

312	apple	20
652	orange	15
252	banana	5
111	lemon	2

 

[kevin9999]

There's any number of ways you could do this. If you're OK with a non-VBA solution, (and you have 365 - you need to update your details) here's just one way:

Book1
	A	B	C	D	E	F	G	H
1	Product Code	Product	Quantity		Product Code	Product	Quantity
2	312	apple	12		312	apple	20
3	652	orange	10		652	orange	15
4	252	banana	3		252	banana	5
5	111	lemon	1		111	lemon	2
6	652	orange	5
7	312	apple	8
8	252	banana	2
9	111	lemon	1
10
Sheet1

Cell Formulas
Range	Formula
E2:F5	E2	=UNIQUE(A2:B9)
G2:G5	G2	=SUMIFS($C$2:$C$9,$A$2:$A$9,E2,$B$2:$B$9,F2)
Dynamic array formulas.