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