ExcelBanter - sub total value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sub total value (https://www.excelbanter.com/excel-discussion-misc-queries/263271-sub-total-value.html)

creating a reference list

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?

Jim Thomlinson

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?

All times are GMT +1. The time now is 02:50 AM.