| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sub total value
I have 4000 lines of data and I have used the sub total function to obtain
the value that I need. How can I sort the data by the sub total value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sub total value
You can't. A pivot tabel will accomplish the same thing as subtotaling and
will allow you to sort by subtotals... http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "creating a reference list" wrote: I have 4000 lines of data and I have used the sub total function to obtain the value that I need. How can I sort the data by the sub total value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Hybrid Mode
