Sum of the unique entries individually??

[kusgh]

Hello all,

Following is the problem I am facing. Please see if any one of you can help me in solving the same. There are two columns as shown below: Please note that I have a total of around 5000 entries in these columns and around 1000 unique entries in the first column.

A 1
A 3
C 1
D 1
B 2
B 3
A 1
E 4
E 2
B 1

Now I want to get that the sum of all the A's is 5, B's is 6, C is 1, D is 1 and E's is 6.

Thanks in advance!

 

[shg]

Is this a different question than http://www.mrexcel.com/forum/showthread.php?t=573846?

 

[kusgh]

I am a new member here. i cud nt find my old post. I wanted to give more info abt the prob so had to post again. see if u can answer it!