The order of the cells

%3CLINGO-SUB%20id%3D%22lingo-sub-3010463%22%20slang%3D%22en-US%22%3EThe%20order%20of%20the%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010463%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CPRE%3E%3CSPAN%20class%3D%22%22%3EHy!%20I%20wanted%20to%20ask%20you%20a%20very%20important%20question.%20Let's%20assume%20we%20have%20the%20ranking%20of%20a%20football%20championship%20in%20front%20of%20us.%20I%20created%20mine%20in%20particular%20on%20excel%20by%20writing%20each%20team%20in%20a%20cell%2C%20and%20the%20cells%20are%20on%20successive%20rows%20in%20the%20same%20column%20(ex%3A%20first%20team%20in%20B16%2C%20second%20team%20in%20B17%2C%20exc.).%20But%20I%20want%20that%20when%20I%20change%20the%20points%20of%20a%20team%2C%20the%20ranking%20is%20automatically%20updated%20according%20to%20the%20points%20of%20all%20the%20teams.%20Also%2C%20my%20ranking%20consists%20of%2020%20rows%20and%209%20columns%20and%20these%20columns%20are%20all%20full%20of%20values.%20So%2C%20if%20I%20change%20the%20points%20of%20the%20teams%20in%20the%20leaderboard%2C%20how%20do%20I%20get%20the%20rows%20to%20sort%20themselves%20from%20the%20highest%20to%20the%20lowest%20value%2C%20without%20just%20changing%20the%20order%20of%20certain%20cells%3F%20Thanks%20in%20advance.%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CPRE%3E%26nbsp%3B%3C%2FPRE%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Albooq_0-1638026095940.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329792i4422AC26F0F28318%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Albooq_0-1638026095940.png%22%20alt%3D%22Albooq_0-1638026095940.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3010463%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3010569%22%20slang%3D%22en-US%22%3ERe%3A%20The%20order%20of%20the%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231150%22%20target%3D%22_blank%22%3E%40Albooq%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20two%20older%20files%20that%20I%20had%20one%20from%20the%20Internet%20(unfortunately%20I%20don't%20know%20from%20which%20address%2C%20but%20maybe%20you%20can%20find%20it%20on%20the%20website)%20to%20follow%20the%20European%20Championship%202004%2C%20and%20the%20other%20file%20from%20this%20forum.%3C%2FP%3E%3CP%3EMaybe%20this%20file%20will%20help%20you%E2%80%A6or%20not%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20before%20you%20ask%20a%20new%20question%20(which%20we%20welcome%20you%20too)%2C%20Please%20always%20add%20specific%20information%20about%20your%20Excel%20version%20and%20operating%20system%20to%20your%20concerns.%20As%20well%20as%2C%20if%20possible%20or%20necessary%2C%20a%20file%20(without%20sensitive%20data).%20In%20this%20way%2C%20you%20will%20come%20up%20with%20a%20proposed%20solution%20much%20faster%20and%20more%20precisely.%20This%20also%20makes%20it%20much%20easier%20for%20the%20helpers%20to%20provide%20the%20help%20that%20they%20would%20like%20to%20offer%20you.%20It%20helps%20both%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20link%20with%20information%20on%20how%20you%20can%20quickly%20find%20a%20solution%20that%20is%20most%20suitable%20for%20you.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20welcome%20you%20to%20this%20forum%20with%20a%20new%20question%20also%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hy! I wanted to ask you a very important question. Let's assume we have the ranking of a football championship in front of us. I created mine in particular on excel by writing each team in a cell, and the cells are on successive rows in the same column (ex: first team in B16, second team in B17, exc.). But I want that when I change the points of a team, the ranking is automatically updated according to the points of all the teams. Also, my ranking consists of 20 rows and 9 columns and these columns are all full of values. So, if I change the points of the teams in the leaderboard, how do I get the rows to sort themselves from the highest to the lowest value, without just changing the order of certain cells? Thanks in advance.
 
Albooq_0-1638026095940.png

 

 
 
 
 
 
1 Reply

@Albooq 

Here are two older files that I had one from the Internet (unfortunately I don't know from which address, but maybe you can find it on the website) to follow the European Championship 2004, and the other file from this forum.

Maybe this file will help you…or not

 

With your permission, if I can recommend you, before you ask a new question (which we welcome you too), Please always add specific information about your Excel version and operating system to your concerns. As well as, if possible or necessary, a file (without sensitive data). In this way, you will come up with a proposed solution much faster and more precisely. This also makes it much easier for the helpers to provide the help that they would like to offer you. It helps both :).

 

Here is a link with information on how you can quickly find a solution that is most suitable for you.

Welcome to your Excel discussion space!

 

Thank you for your understanding

 

I would be happy to welcome you to this forum with a new question also in the future.

 

NikolinoDE

I know I don't know anything (Socrates)