Prev: Return Value from a Range (depends on input to determind month
Next: Relative Range Reference in a sumifs formula
From: BigDogR on 31 Mar 2010 11:32
How might I carryover/copy additional information into the newly created row
that includes the subtotal and name of the subtotal? For instance, the
product number (Column A) is what is grouped to determine the subtotal of the
Sales for that product group (Column C) but I want to include the item
description which is in Column B of the rows above. I have 35,000 rows of
data being subtotaled and want to avoid cutting and pasting this information.
Then, I plan to sort the subtotal data from highest to lowest and would like
to have the description in the printout of the subtotals (with the details
hidden).
--
Many thanks - BD
From: Glenn on 31 Mar 2010 11:55
BigDogR wrote:
> How might I carryover/copy additional information into the newly created row
> that includes the subtotal and name of the subtotal? For instance, the
> product number (Column A) is what is grouped to determine the subtotal of the
> Sales for that product group (Column C) but I want to include the item
> description which is in Column B of the rows above. I have 35,000 rows of
> data being subtotaled and want to avoid cutting and pasting this information.
> Then, I plan to sort the subtotal data from highest to lowest and would like
> to have the description in the printout of the subtotals (with the details
> hidden).

First, you might consider a PivotTable instead of Subtotals. If you are not
familiar with them, look here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Otherwise, collapse your data to include only the Subtotals. Select the first
blank cell in column B. Assume that cell is B14. In that cell, enter the
following formula:

=B13

Copy that cell. Select the rest of the empty cells currently showing in column
B. Edit / Go To / Special / Blanks / OK. Paste. Re-calculate (if not
automatic). Now show all of your data. Select Column B. Copy. Edit / Paste
Special / Values / OK.
 | 
Pages: 1
Prev: Return Value from a Range (depends on input to determind month
Next: Relative Range Reference in a sumifs formula