Merging rows

[Mr.Bennet]

Hey!

I have done a huge excel document and I am trying to sum up numbers with the exact same name. So lets say:

Tommy 6
Emma 5
Tommy 2
Martin 1
Anna 3
Martin 2

I want a final list with:
Tommy 8
Emma 5
Martin 3
Anna 3

I have one of the latest version.

Any clue of how to do this?

[AlKey]

Enter formula to get unique names list in D2 and copy down

Please Login or Register  to view this content.

then in E2 and copy down

Please Login or Register  to view this content.

v	A	B	C	D	E
1
2	Tommy	6		Tommy	8
3	Emma	5		Emma	5
4	Tommy	2		Martin	3
5	Martin	1		Anna	3
6	Anna	3
7	Martin	2