I have data of over 10000 rows 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 Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=52954