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
77 a 3
77 a 6
77 b 9
77 b 12

I need this to become:
1 a 12
1 b 14
77 a 9
77 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=52955

Use a pivotTable on your data

Data=PivotTable report. Make the first two columns Row Fields and the
third column a Data Field. Set it to SUM (usually the default for numbers).


--
Regards,
Tom Ogilvy


"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
77 a 3
77 a 6
77 b 9
77 b 12

I need this to become:
1 a 12
1 b 14
77 a 9
77 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=529550

Sorry Tom,

wasnt completely clear in my original response. The data is in th
following
format:

1 a d e 3
1 a c e 4
1 a c v 5

Regard

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