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

you have already got the reply..why do u repeat again??

-via135


T De Villiers Wrote:
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

--
via13
-----------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=52954

But how do I do this for over 1000 row

--
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