Quote:
Originally Posted by jaccobby
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 585
|
Can you not use a pivot table to do this?
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.