| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine rows of data in a worksheet
Thanks
-----Original Message----- Hi you should talk to your manager :-) all< other solutions would require complex formulas or VBA: - first extracting a unique list of customers/fiscal years - using SUMPRODUCT to sum all your values accordingly -- Regards Frank Kabel Frankfurt, Germany "Joanne" schrieb im Newsbeitrag ... I thought that would work, but unfortunately, my manager does not want to use pivot tables. THat is why I am looking at alternate methods. -----Original Message----- Hi for this have a look at piot tables to aggregate your data. See: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Frank Kabel Frankfurt, Germany "Joanne" schrieb im Newsbeitrag ... Cust Id Name Fiscal Code MSF Sales$ 1009 abc 04/04 300 5000 1035 XYZ 03/04 250 3500 1009 abc 04/04 400 4500 I would like to combine the data under the following conditions: If the customer # is the same, as well as the fiscal code, We would like the MSF and Sales $ figures to be combined so that we only have one row of data for the fiscal period. We do business for the same customers at both plants, and would like to see the totals for the customer, not the plant. Thanks for your help. -----Original Message----- Hi and how do you want them combined. You may post an example (plain text - no attachment please) -- Regards Frank Kabel Frankfurt, Germany wrote: I am trying to combine data from two companies into one spreadsheet for the complex. I need to combine the rows that contain similar data for that time period. For example, since we are looking at 2 separate companies in the division, we may have 2 separate entries for customer # 1009 for fiscal code 04/04. We would like to see just one entry made for the entire complex. Is there a formula, or code to do this? I have been trying some things, but none of them seem to work. . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine rows and sum data with the same id | Excel Discussion (Misc queries) | |||
| How do I combine multiple rows with like data in Excel? | Excel Discussion (Misc queries) | |||
| Combine Data from Multiple Rows | Excel Discussion (Misc queries) | |||
| Combine the data in 2 columns of 20 rows into one column of 40 row | Excel Discussion (Misc queries) | |||
| Combine data rows in Pie Chart | Charts and Charting in Excel | |||
Hybrid Mode
