Best Students List

[sanmercy]

Hi,

Thank you for all your advice on chandoo.org. I find your site very informative and easy to understand.


I'd like to ask a question about something I've been stuck on.


I have a list of about 100 students that meet for an event every week. After their individual scores are entered on their House Color (Blue, Red, Green, Yellow) tabs, I need to find the highest scorer from all the four tabs.

So I created a separate sheet to grab data from all the four sheets into one sheet and used the RANK function.


However, I am not able to extract the name of the highest scoring students onto the bottom of the sheet. I know Excel has some functionalities to find the MAX and MIN but it only identifies one student. If multiple people score the same high score, is there a way to extract all their names into one list?


Thanks!


​Sincerely, ​

Santhosh George

 

[hiker95]

sanmercy,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


If you are not able to provide screenshots, then:

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[sanmercy]

Link to file:
https://www.dropbox.com/s/dml2vlv34rek4hu/Sample.xlsm?dl=0

Please advise.

 

[hiker95]

Link to file:
https://www.dropbox.com/s/dml2vlv34rek4hu/Sample.xlsm?dl=0

Please advise.

sanmercy,

I have had problems in the past when attempting to download an Excel file with macros, with the xlsm file extension.

Please remove all macros, and, then rename the workbook using the xlsx file extension, and, then repost on dropbox.


Then post your original VBA code, below, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]

 

[FDibbins]

If you already have all the names on 1 sheet, you could use filters to ID the names you wanted?

 

[sanmercy]

Sorry about that- I've removed the VBA code - I dont need those codes.

Please see updated link:

https://www.dropbox.com/s/ze1c651lvpqyk3x/Sample 1.xlsx?dl=0

Thanks!

sanmercy,

I have had problems in the past when attempting to download an Excel file with macros, with the xlsm file extension.

Please remove all macros, and, then rename the workbook using the xlsx file extension, and, then repost on dropbox.


Then post your original VBA code, below, please use Code Tags - like this:

[code=rich]

Paste your code here.

[/code]

 

[hiker95]

sanmercy,

Thanks for the new workbook.

I can not see the logic to solve your request.

 

[sanmercy]

Please see another version of the file...

https://www.dropbox.com/s/ze1c651lvpqyk3x/Sample 1.xlsx?dl=0

In this case, there are 3 kids with 400 score and only 1 of them is listed as "1".
Also I want to extract the names of the winners automatically to Rows A59, A60 and A61 with their respective scores in B59 to 61.

Hope the request is clear.