| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total then Sort
I am trying to define which customers has spent the most with us so far this
year in order. I have so far sorted all clients and invoice amounts for this year. There are over 3000 entries with each customer having between 5 and 20 invoices. The customers have been sorted into Alphabetical order in column A with the invoice amounts in column B. I need to add up the totals for each customer and then sort into cutomers with the highest expenditure. Please has anybody got any suggestions? Cheers Amanda |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
| Calculate total $ based on rows displayed by sort | Excel Worksheet Functions | |||
| sort by month with a monthly total | Excel Discussion (Misc queries) | |||
| Sort And Total | Excel Discussion (Misc queries) | |||
| Sort creating total errors | Excel Discussion (Misc queries) | |||
Threaded Mode
