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