Thread: Total then Sort
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amanda Amanda is offline
external usenet poster
 
Posts: 151
Default 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