Home

Seperate Rank List

%3CLINGO-SUB%20id%3D%22lingo-sub-1172113%22%20slang%3D%22en-US%22%3ESeperate%20Rank%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172113%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20sheet%20that%20lists%20and%20ranks%20various%20data.%20Then%20I%20average%20those%20ranked%20points%20into%20a%20final%20rank%20which%20low%20score%20is%20the%20best.%20The%20data%20and%20order%20changes%20pretty%20consistently%20and%20the%20sheet%20and%20all%20of%20the%20overall%20formulas%20work%20well.%20However%2C%20I%20was%20wondering%20for%20(organizational%20purposes)%20could%20I%20replicate%20that%20list%20but%20it%20would%20put%20those%20main%20data%20final%20ranked%20topics%20in%20order%20from%201-12%20Separately%3F%20Where%20the%201-12%20list%20would%20stay%20the%20same%20but%20the%20topic%20would%20fall%20into%20their%20appropriate%20ranked%20order%20that%20week.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20tried%20to%20google%20it%20but%20didn't%20have%20much%20luck.%20Perhaps%20I%20don't%20know%20what%20it%20is%20correctly%20called%3F%26nbsp%3B%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1172113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Erank%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172145%22%20slang%3D%22en-US%22%3ERe%3A%20Seperate%20Rank%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F556495%22%20target%3D%22_blank%22%3E%40coachzach_%3C%2FA%3E%26nbsp%3BIt%20might%20be%20more%20productive%20to%20post%20this%20Excel%20question%20in%20the%20Excel%20forum%20instead%20of%20here%2C%20in%20the%20Access%20forum%2C%20which%20is%20dedicated%20to%20support%20for%20the%20Microsoft%20Access%20Relational%20Database%20development%20application.%20Both%20are%2C%20of%20course%2C%20part%20of%20the%20MS%20Office%20suite%20of%20applications.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1172180%22%20slang%3D%22en-US%22%3ERe%3A%20Seperate%20Rank%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1172180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3Bmy%20bad%20i%20thought%20i%20did%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello All,

 

I have a sheet that lists and ranks various data. Then I average those ranked points into a final rank which low score is the best. The data and order changes pretty consistently and the sheet and all of the overall formulas work well. However, I was wondering for (organizational purposes) could I replicate that list but it would put those main data final ranked topics in order from 1-12 Separately? Where the 1-12 list would stay the same but the topic would fall into their appropriate ranked order that week.

I tried to google it but didn't have much luck. Perhaps I don't know what it is correctly called?  Thank you in advance!

2 Replies
Highlighted

@coachzach_ It might be more productive to post this Excel question in the Excel forum instead of here, in the Access forum, which is dedicated to support for the Microsoft Access Relational Database development application. Both are, of course, part of the MS Office suite of applications.

Highlighted

@George Hepworth my bad i thought i did

Related Conversations