[dheaven66]

Hello, i find myself in great need for an excell formula or macro that is able to do the followings for the spreadsheet that i have...

this is what i got (it's a bit more random in reality)


jun | 3333 (uniqueID) | SOME NAME | 10 (value 1) | 3 (value 2)
may | 3333 (uniqueID) | SOME NAME | 14 (value 3) | 6 (value 4)
jan | 4444 (uniqueID) | OTHER NAME | value 5 | value 6
may | 2134 (uniqueID) | LALA NAME | value 7 | value 8

what i need:
search and identify uniqueID then sum in the following manner, so i want to merge the 2 rows that have the same ID and sum there values.

jun+may | 3333 (uniqueID) | SOME NAME | 24 | 9
jan | 4444 (uniqueID) | OTHER NAME | value 5 | value 6
may | 2134 (uniqueID) | LALA NAME | value 7 | value 8

Thank You Very Much!