Ranking data

%3CLINGO-SUB%20id%3D%22lingo-sub-2697177%22%20slang%3D%22en-US%22%3ERanking%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697177%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excel%20experts%2C%3C%2FP%3E%3CP%3EI%20have%20a%20table%20(all%20students)%20imported%20and%20linked%20to%20another%20workbook.%20After%20that%2C%20I%20created%20a%20filter%20in%20another%20table%20(this%20year)%20in%20order%20to%20display%20only%20students%20of%20a%20specific%20year%20(cf.%20cell%20B1).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chamseddine_hamdeni_0-1630271656367.png%22%20style%3D%22width%3A%20546px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306585i5ABA30CA7BE1087F%2Fimage-dimensions%2F546x213%3Fv%3Dv2%22%20width%3D%22546%22%20height%3D%22213%22%20role%3D%22button%22%20title%3D%22chamseddine_hamdeni_0-1630271656367.png%22%20alt%3D%22chamseddine_hamdeni_0-1630271656367.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20working.%20However%2C%20my%20aim%20is%20to%20display%20the%20data%20of%20the%20second%20table%20(this%20year)%20ranked%20according%20to%20their%20ID.%3C%2FP%3E%3CP%3EAny%20solution%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2697177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2697417%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2697417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1140785%22%20target%3D%22_blank%22%3E%40chamseddine_hamdeni%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20nest%20your%20use%20of%20FILTER%20in%20SORT%2C%20so%20it%20reads%20%3CSTRONG%3E%3DSORT(FILTER(whatever_is_already_there))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20Since%20you%20went%20to%20the%20trouble%20of%20creating%20a%20mockup%2C%20containing%20no%20real%20data%2C%20it%20would%20have%20been%20more%20helpful%20to%20post%20an%20actual%20copy%20of%20that%20mockup%20rather%20than%20an%20image.%20Here%2C%20though%2C%20is%20a%20YouTube%20video%20you%20might%20find%20helpful%20regarding%20the%20use%20of%20both%20FILTER%20and%20SORT%2C%20along%20with%20UNIQUE%2C%20all%20members%20of%20the%20newly%20released%20Dynamic%20Array%20functions.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Dear Excel experts,

I have a table (all students) imported and linked to another workbook. After that, I created a filter in another table (this year) in order to display only students of a specific year (cf. cell B1).

 

chamseddine_hamdeni_0-1630271656367.png

This is working. However, my aim is to display the data of the second table (this year) ranked according to their ID.

Any solution ?

 

2 Replies

@chamseddine_hamdeni 

 

You can nest your use of FILTER in SORT, so it reads =SORT(FILTER(whatever_is_already_there))

 

P.S. Since you went to the trouble of creating a mockup, containing no real data, it would have been more helpful to post an actual copy of that mockup rather than an image. Here, though, is a YouTube video you might find helpful regarding the use of both FILTER and SORT, along with UNIQUE, all members of the newly released Dynamic Array functions. https://www.youtube.com/watch?v=9I9DtFOVPIg

 

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...
thank you this is working