OK I have to admit that this will probably be like asking you guys how to open a can of coke or something, but the fact is, I have tried to find the answer, but failed.
Here goes:
I have an excel spreadsheet with names of companies and the value of sales made to them last year and this year to date.
The list is in alphabetical order but I want to put it in to descending numerical order, based on the sales made to them this year to date. So in other words, re-order the year to date column in descending order, but keep the correct name attached.
Yes I know that's basic, but when I went to school we used slide rules and log tables !
Any help gratefully received. Thanks.
Here goes:
I have an excel spreadsheet with names of companies and the value of sales made to them last year and this year to date.
The list is in alphabetical order but I want to put it in to descending numerical order, based on the sales made to them this year to date. So in other words, re-order the year to date column in descending order, but keep the correct name attached.
Yes I know that's basic, but when I went to school we used slide rules and log tables !
Any help gratefully received. Thanks.