Count each unique value in coloumn 'a' and sum values in coloumn 'b'

[vipin717]

Hi I am new to vba.
I want alittli help to all of you plz help me.
I want to count each unique value in coloumn 'A' and sum respectly in coloumn 'B' and display this in same sheet an other place with unique values.

I attached a sample sheet.
plz plz plz plz help me.

thanks alot in advance.

[FDibbins]

Hi and welcome to the forum

for the names...
=IFERROR(INDEX($A$2:$A$11,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$11),0,0),0)),"")
for the count...
=COUNTIF($A$2:$A$11,D2)
for the sum...
=SUMIF($A$2:$A$11,D2,$B$2:$B$11)

[vipin717]

plz send me a macro file i dont know how make changes in
sorry
plz help me

[FDibbins]

You dont need a macro file for this, put the formulas where I have said, then copy them down...
for the names...
D2=IFERROR(INDEX($A$2:$A$11,MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$11),0,0),0)),"")
for the count...
E2=COUNTIF($A$2:$A$11,D2)
for the sum...
F2=SUMIF($A$2:$A$11,D2,$B$2:$B$11)

[sktneer]

Are you looking for a VBA solution?
Otherwise formulas suggested by Ford are enough for what you are trying to do.

[vipin717]

Thank you very much for this help it works very well but there is one problem system becomes very slow because i am having near about 1000 rows data.

Now wt to do.
plz help me.