Extracting the Top 5 Scorer based on Criteria

[Juniad]

Hi Dears,
Kindly look into the sample sheet need help to extract top 5 scorer based on Paper-5 in Column D.

 

[pecoflyer]

Depending on your XL version different solutions can be found at https://www.ablebits.com/office-addins-blog/2020/11/19/excel-formula-find-top-bottom-values/

 

[p45cal]

In the attached, choose the paper number in cell I1's dropdown, see the results below that.
I've used the Max score in case applicants have multiple scores for the same paper (eg. MUHAMMAD WAQAS KHAN and Iqra yousaf have each taken Paper-3 twice).

 

[prepelsein]

In the attached, choose the paper number in cell I1's dropdown, see the results below that.
I've used the Max score in case applicants have multiple scores for the same paper (eg. MUHAMMAD WAQAS KHAN and Iqra yousaf have each taken Paper-3 twice).

Thanks for the attachment. I will definitely go through it to understand it better.