Need help to Analyze, 1st 2nd and 3rd top scores in 30 separate Classes

[GearheadFest]

Hey everyone! I am a newb, but I am very frustrated and have decided to come to you all for some help! I have been working on this particular spreadsheet, and evolving it for the last 3 years. I am very basic with formulas, I usually do well when I can read through what has already been done, to apply it to my data. So starting from scratch is a challenge for me. I have watched TONS of you tube videos and googled and swept through a ton of websites, I even figured out a great alternative with macro, but didn't save it properly and lost HOURS of work. Even with the skills I have gained over the last year I am having a lot of trouble applying the knowledge to my personal spreadsheet.

For the sake of my sanity could someone please take a look at my spreadsheet and help me figure out what I need?(i just figured out that i cant attach it.)


I have looked and tried to play with the LARGE, IF, MATCH, INDEX functions, but its not pulling the right info, or I'm not properly routing the functions.
Currently the Master info list and the judging scorecard sheet talk to each other to pull the scores/registration numbers to match so my master list shows the proper scores, which is perfect for that function.

What I need: I need the MASTER INFO LIST to communicate over to the WINNERS sheet. ON the WINNERS sheet I need the top 3 scores to populate in the appropriate class from the MASTER INFO LIST. I also would like the Name, Year, Make, & Model to populate over to the winners list also. Then god forbid there are ties, I'm not sure how to separate those, but I would assume it could be an IF formula?

I used class #19 as a sample on the spreadsheet... so on the WINNERS sheet, in CLASS 19 I would like to be able to see the following data auto populated:

19	HYUNDAI/KIA/SCION	SCORE
1st	Allison Cline 2016 Kia Optima	92.0
2nd	Jessica Hecker 2013 Hyundai Sonata	81.0
3rd	Frank Hecker 2015 Hyundai Genesis	50.0

<tbody>
</tbody>

Any Help would be GREATLY APPRECIATED!!! <3

 

[cerfani]

Start by writing a loop that loops the number of times for each row in the masterlist

Dim startRow As Long
startRow = 2
Dim endRow As Long
endRow = Cells(Worksheets("MasterWorksheet").Rows.Count, 1).End(xlUp).Row 'google the Range.End function

try to write a loop that starts at 2 and loops all the way to endRow

have a msgbox tell you each person's name

if you can do that i will help you further

(BTW YOU CAN HOLD ESC KEY TO STOP A MACRO SO YOU DONT HAVE TO LOOK AT EACH MSGBOX)

ALSO NEVER COPY AND PASTE ANY CODE I WRITE

ALWAYS WRITE YOURSELF!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[GearheadFest]

Start by writing a loop that loops the number of times for each row in the masterlist

Dim startRow As Long
startRow = 2
Dim endRow As Long
endRow = Cells(Worksheets("MasterWorksheet").Rows.Count, 1).End(xlUp).Row 'google the Range.End function

try to write a loop that starts at 2 and loops all the way to endRow

have a msgbox tell you each person's name

if you can do that i will help you further

(BTW YOU CAN HOLD ESC KEY TO STOP A MACRO SO YOU DONT HAVE TO LOOK AT EACH MSGBOX)

ALSO NEVER COPY AND PASTE ANY CODE I WRITE

ALWAYS WRITE YOURSELF!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

thank you i will try to work on this and get back to you!