Jan 28, 2004 #1 Rae03 IS-IT--Management Joined Jun 19, 2003 Messages 36 Location NL Is there a way to sort by subtotaled amounts on a excel spread sheet?
Jan 28, 2004 #2 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US 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, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 Upvote 0 Downvote
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, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884