LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Putting subtotals in $ descending order

I have exported a report from a Donor based program to Excel v 2003. The
columns are donor name, date of donation and dollar amount of donation. Some
donors have more than one donation. All donors have subtotals for their
donations, the subtotal is below the detail of donation amounts. How can I
put this report in order of donation subtotals, highest to lowest.

This is an example of how an entry might look

Column a Column b Column c

row 5 John Smith 4/29/05 $5,000
row 6 John Smith 6/20/06 $10,000
row 7 2 $15,000

row 9 Jane Doe 4/04/07 50.00
row 10 Jane Doe 4/25/07 1,000.00
row 11 Jane Doe 6/30/07 20,000.00
row 12 3 21,050.00

row 14 Bill Brown 6/20/06 10.00
row 15 1 10.00

In putting the subtotal amounts in descending order, it will need to keep
the detail with it.

Thank you.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Top 10 in descending order Esradekan Excel Worksheet Functions 8 September 24th 07 02:54 AM
DESCENDING ORDER -in Form Marilyn Excel Discussion (Misc queries) 2 January 13th 07 05:31 PM
How do I match all columns into descending order Kiwi Jane New Users to Excel 2 October 13th 06 01:10 AM
Drop Down List is not in Descending Order John Excel Discussion (Misc queries) 1 November 2nd 05 11:26 PM
Date in descending order to come up automatically in a column? Snugglebums Excel Worksheet Functions 2 January 11th 05 03:09 PM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"