Sorting within subtotals

[rvmams]

Hi,

I subtotaled a list of values, but within the "category" I would like the items sorted within the list. Here is an example of what it is now:

Al cars 2
Al hotels 5
Al planes 3
Sub total 10

This is what I would like it to be:

Al hotels 5
Al planes 3
Al cars 2
Sub total 10

Is there anyway to do this besides manually sorting them?

Thnx,

Roger

 

[SkipVought]

Roger,

Can't do it in SUBTOTAL.

However, using the PivotTable Wizard you can use Sum Of [whatever you were subtotaling] and then RIGHT CLICK the ROW field and select Field Setting - Advanced - Auto Sort Options Descending by Sum of whatever

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[GlennUK]

Why don't you sort by Category and item, then add the subtotals?

Just an idea.
Glenn.

 

[mscallisto]

I agree with Skip, pivot table gives you the most for your money and are extremely easy to use (once you try them).

If you're not pivot saavy see

http://peltiertech.com/Excel/Pivots/pivotstart.htm

from an earlier KenWright post