I have data in following format:

1 a 3
1 a 4
1 a 5
1 b 6
1 b 8
2 a 3
2 a 6
2 b 9
2 b 12

I need this to become:
1 a 12
1 b 14
2 a 9
2 b 21

Many thanks for a Macro which can assist me in this.


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=529545