Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting subtotal results
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 |
#2
|
|||
|
|||
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 EditGo 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. gls858 wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Debra Dalgleish wrote:
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 EditGo 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. gls858 wrote: 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 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 |
#4
|
|||
|
|||
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 On Mon, 24 Jan 2005 19:05:50 -0500, Debra Dalgleish wrote: 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 EditGo 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. gls858 wrote: 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 |
#5
|
|||
|
|||
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 On Mon, 24 Jan 2005 19:05:50 -0500, Debra Dalgleish wrote: 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 EditGo 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. gls858 wrote: 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 |
#6
|
|||
|
|||
Maybe try Edit Replace
Find what: Total Replace with: (leave it blank) Click "Replace All" -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "yahoo" wrote in message ... 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 On Mon, 24 Jan 2005 19:05:50 -0500, Debra Dalgleish wrote: 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 EditGo 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. gls858 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Subtotal by two columns at once | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) | |||
?odd results for =left(F#,2) | Excel Worksheet Functions |