sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-2261755%22%20slang%3D%22en-US%22%3Esorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261755%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20with%20a%2Cb%2Cc%2Cd%2C%20columns.%26nbsp%3B%20In%20the%20a%20column%20is%20numbered%2C%20the%20b%20and%20c%20columns%20are%20the%20last%20and%20first%20names%20and%20the%20d%20column%20is%20the%20amount%20of%20money%20won%20by%20each%20individual.%26nbsp%3B%20Directly%20across%20beginning%20with%20column%20q%20through%20column%20at%20is%20the%20amount%20of%20money%20won%20each%20week%20for%20each%20individual.%26nbsp%3B%20I%20have%20put%20a%20formula%20for%20each%20person%20in%20column%20d%20that%20will%20pick%20up%20and%20add%20to%20each%20persons%20amount%20from%20columns%20q%20through%20at.%26nbsp%3B%20My%20question%20is%20how%20can%20I%20sort%20columns%20b%20through%20d%20each%20week%20from%20highest%20amount%20to%20lowest%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a table with a,b,c,d, columns.  In the a column is numbered, the b and c columns are the last and first names and the d column is the amount of money won by each individual.  Directly across beginning with column q through column at is the amount of money won each week for each individual.  I have put a formula for each person in column d that will pick up and add to each persons amount from columns q through at.  My question is how can I sort columns b through d each week from highest amount to lowest?

1 Reply
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
A win-win situation for everyone.
Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not always in the case of Excel, on the contrary in some cases.

* Knowing the Excel version and operating system would also be an advantage.
Finally, please consider why does one of the helpers still have to prepare the file with your request?

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)