| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
