View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ms. Domzalski Ms. Domzalski is offline
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.