Consolidating Data
 

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

Consolidating Data
 

hi!

try this!

=SUMPRODUCT(--(A1:A9=E1)*(B1:B9=F1)*(C1:C9))

assuming that your data in A1:C9
and your conditional value of COL A & COL B in E1 & F1 respectively!!!

-via13

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

Consolidating Data
 

Thats good, however my list actually involves over 10000 rows,
so im not sure if the solution to date is practical.

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

Consolidating Data
 

don't worry the formula will take care of any number of rows! but yo
must specify the range!!!

-via13

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

Consolidating Data
 

The problem is I have loads of conditional values, how canI easil
identify thes

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

Consolidating Data
 

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:


The problem is I have loads of conditional values, how canI easily
identify these


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

Consolidating Data
 

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
2 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=52954

Consolidating Data
 

Answer is pretty much the same.

--
Regards,
Tom Ogilvy


"T De Villiers"
wrote in message
news:T.De.Villiers.25qn9b_1144151406.7767@excelfor um-nospam.com...

Sorry Tom,

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

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

Regards


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