| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidating Data | Excel Discussion (Misc queries) | |||
| Consolidating Data | Excel Worksheet Functions | |||
| Consolidating Data | Excel Discussion (Misc queries) | |||
| Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming | |||
| Consolidating data?? | Excel Worksheet Functions | |||
![T De Villiers[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
