Help with LARGE formula with multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all. Please help me with a problem I am having. I have set up a
spreadsheet with 11 worksheets for keeping scores of 10 different events.
Sheets 1-10 are scores for individual events. Sheet 11 is a list that keeps
track of the top 3 in each category.

The indivual sheets have 5 columns. Column A is the school name, B-D are sub
scores and E is a total score. The winner's list has 3 columns, A is the
event, B needs to be the school name and C is the score. I have used the
LARGE formula to pull over the top 3 scores into Column C, but I need to find
out how to pull over the corresponding school name. Please help. Thanks.
 
Have you tried using MATCH to determine the row number of the highest score
(assuming there's only one) and then and then INDEX to get the SCHOOL name?
 
Back
Top