A
Amanda
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
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