Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need a macro to associate values in columns
I have a list of names in the first column which can contain one or more of the same name, and a list of numbers associated with each name in column 2 . what i want to do is search through the names and add the corresponding numbers, so as I end up with a column with names which are not duplicated and a column with the the sum of numbers associated with each name thanks
Last edited by jaccobby : September 12th 12 at 07:53 PM Reason: forgot to mention thanks |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Quote:
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 585 Last edited by jaccobby : September 13th 12 at 09:00 PM |
#4
|
|||
|
|||
Quote:
It's easy enough to do with formulas, SUMIF or SUMPRODUCT will do it depending on which version of Excel you use. But they will both depend on you having a unique list of names to begin with. I don't know a macro would be necessary. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I need a macro to associate values in columns
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 -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to look up values in 2 different columns | Excel Programming | |||
Associate values in worksheet?? | Excel Worksheet Functions | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
How to create button and associate a macro with it. | Excel Programming | |||
Associate additional columns with an external query | Excel Programming |