Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Subtotaled information
I have subtoaled the total charges of several customers. Now i want to sort
the subtotoaled results, from lowest to highest. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Subtotaled information
Did you use data|subtotal to create the subtotals?
If yes, then use the outlining symbols to the left to hide the details and then sort your range. chris wrote: I have subtoaled the total charges of several customers. Now i want to sort the subtotoaled results, from lowest to highest. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Subtotaled information
I was actually able to get it to work, but only if I had 1 subtotoaled
criteri. Do you know how to do it if i want to keep several criterie, i.e a count of one thing, and a sum of another, "Dave Peterson" wrote: Did you use data|subtotal to create the subtotals? If yes, then use the outlining symbols to the left to hide the details and then sort your range. chris wrote: I have subtoaled the total charges of several customers. Now i want to sort the subtotoaled results, from lowest to highest. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Subtotaled information
Couldn't you just hide the details and do sorts over and over...
Personally, I think I'd drop the data|subtotals and learn about data|pivottable. You'll find that you can make very nice summaries really quickly. And once you create your pivottable, you'll be able to pivot on any type of report that you want. If you've never used pivottables, here are a few links: Debra Dalgleish's pictures at Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivottables.htm And Debra's own site: http://www.contextures.com/xlPivot01.html John Walkenbach also has some at: http://j-walk.com/ss/excel/files/general.htm (look for Tony Gwynn's Hit Database) Chip Pearson keeps Harald Staff's notes at: http://www.cpearson.com/excel/pivots.htm MS has some at (xl2000 and xl2002): http://office.microsoft.com/downloads/2000/XCrtPiv.aspx http://office.microsoft.com/assistan...lconPT101.aspx ==== And if you have used pivottables and can't use them here, then never mind. chris wrote: I was actually able to get it to work, but only if I had 1 subtotoaled criteri. Do you know how to do it if i want to keep several criterie, i.e a count of one thing, and a sum of another, "Dave Peterson" wrote: Did you use data|subtotal to create the subtotals? If yes, then use the outlining symbols to the left to hide the details and then sort your range. chris wrote: I have subtoaled the total charges of several customers. Now i want to sort the subtotoaled results, from lowest to highest. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting information into lists | Excel Discussion (Misc queries) | |||
Sorting subtotaled amounts in excel | New Users to Excel | |||
formula help, sorting information | Excel Worksheet Functions | |||
sorting information on a template. | Excel Discussion (Misc queries) | |||
sorting two columns' information | Excel Discussion (Misc queries) |