Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Top 10 in descending order | Excel Worksheet Functions | |||
DESCENDING ORDER -in Form | Excel Discussion (Misc queries) | |||
How do I match all columns into descending order | New Users to Excel | |||
Drop Down List is not in Descending Order | Excel Discussion (Misc queries) | |||
Date in descending order to come up automatically in a column? | Excel Worksheet Functions |