I need a macro to associate values in columns

J

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
 
S

Spencer101

jaccobby;1605435 said:
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..
 
Joined
Jul 22, 2012
Messages
8
Reaction score
0
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.
 
J

jaccobby

Spencer101;1605436 said:
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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top