I need a macro to associate values in columns

[jaccobby]

I have a list of names in the first column which can contain one o
more of the same name, and a list of numbers associated with each nam
in column 2 . what i want to do is search through the names and add th
corresponding numbers, so as I end up with a column with names which ar
not duplicated and a column with the the sum of numbers associated wit
each name thank

 

[Spencer101]

I have a list of names in the first column which can contain one o
more of the same name, and a list of numbers associated with each nam
in column 2 . what i want to do is search through the names and add th
corresponding numbers, so as I end up with a column with names which ar
not duplicated and a column with the the sum of numbers associated wit
each name thanks

Any chance of an example workbook? Always a great starting point fo
help..

 

[Kevin@Radstock]

Not a macro!

Assuming your names are in column A (Header in A1) and your Values to sum are in Column B (Header in B1) to row 100.
Would this be something you could use!

=IF(COUNTIF($A$2:A2,A2)=1,SUMIF($A$2:$A$100,A2,$B$2:$B$100),"")

and drag down.

 

[jaccobby]

Any chance of an example workbook? Always a great starting point fo
help...

what I want is
Names values Names values
name1 256 name1 1690
name2 148 name2 513
name1 268 name3 2237
name3 967
name3 685
name1 598
name2 365
name1 568
name3 58

 

[jaccobby]

Can you not use a pivot table to do this?

not exactly what I had in mind but thanks anywa

 

[Claus Busch]

Hi,

Am Fri, 14 Sep 2012 18:28:20 +0000 schrieb jaccobby:

not exactly what I had in mind but thanks anyway

filter the names with advanced filter without duplicates to Column G
e.g. Then in H2:
=SUMIF($A$2:$A$100,G2,$B$2:$B$100)
and copy down


Regards
Claus Busch