View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joanne joanne is offline
external usenet poster
 
Posts: 5
Default 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.

.


.


.