sub total value
in [General]
|
From: creating a reference list on 6 May 2010 14:08 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?
From: Jim Thomlinson on 6 May 2010 14:17 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?
|
Pages: 1 Prev: Excel subtotals Next: How do I change Font color specific text |