Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2000

Status
Not open for further replies.

Rae03

IS-IT--Management
Jun 19, 2003
36
NL
Is there a way to sort by subtotaled amounts on a excel spread sheet?
 
Rae03,

Use the PivotTable Wizard using the Sum of... selection for the DATA AREA.

Open the Field Settings of the ROW DATA field and select the Advanced Button. AutoSort Descending Using Field Sum of...

PivotTable: Conquoring the demons of data, one query at a time ;-)

:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top