Sorting subtotal results

  • Thread starter Thread starter gls858
  • Start date Start date
G

gls858

I have a spreadsheet with three col. Company, Date, Invoice Amount
I sort by Company and subtotal invoice amount to get the YTD
total for each Company. What I would like to do is sort the subtotaled
amounts in descending order. What's the easiest way to do this?

I tried a copy and Paste Special > values but it copied the
underlying detail also.

gls858
 
Collapse the subtotals, so only the Company Names, and subtotal amounts
are visible. To do this, you should be able to click the 2 button in the
Outline bar.

Select a cell that contains a subtotal
Click the Z-A button on the toolbar

If you want to copy just the subtotals to a new area of the workbook:

Select the cells that you want to copy
Choose Edit>Go To
Click the Special button
Select Visible cells only
Click OK

Click the Copy button
Select the cell where you want to start the paste
Click the Paste button.
 
Debra said:
Collapse the subtotals, so only the Company Names, and subtotal amounts
are visible. To do this, you should be able to click the 2 button in the
Outline bar.

Select a cell that contains a subtotal
Click the Z-A button on the toolbar

If you want to copy just the subtotals to a new area of the workbook:

Select the cells that you want to copy
Choose Edit>Go To
Click the Special button
Select Visible cells only
Click OK

Click the Copy button
Select the cell where you want to start the paste
Click the Paste button.
Click to expand...
Thanks Debra. Doesn't get any easier than that :-)
I was highlighting BOTH col and it wouldn't sort.
Never thought about selecting just the subtotal col.
I usually work with detail without subtotals so I'm
used to selecting all cols. to sort.

gls858
 
Hi

This works well - but
when you subtotal excel inserts the word 'total' on the same line - as
in theis example 'company name'

How can I remove the word total?

In my case I am subtotaling by invoice number - after I subtotal it
states '123456 total' - 123456 = invoice number

When I do the special copy/paste below the '123456 total' is pasted on
a new line - but I cannot have the word total there - becuase I need
to upload the invoice number as format number into another program

How can I get rid of the word total?

Thanks
 
Hi

This works well - but
when you subtotal excel inserts the word 'total' on the same line - as
in theis example 'company name'

How can I remove the word total?

In my case I am subtotaling by invoice number - after I subtotal it
states '123456 total' - 123456 = invoice number

When I do the special copy/paste below the '123456 total' is pasted on
a new line - but I cannot have the word total there - becuase I need
to upload the invoice number as format number into another program

How can I get rid of the word total?

Thanks
 
Maybe try Edit > Replace
Find what: Total
Replace with: (leave it blank)
Click "Replace All"
 
Back
Top