We have an annual competition for middle and senior high school students. There are individual and team winners. Worksheet 1 lists all the students with team name and school name, their four (4) subtest scores. Team and individual totals are all computed. I would like Worksheet 2 to find the winners. I have found that the LARGE function will find the first 3 places but I can't figure out how to also bring over from Worksheet 1 the name of the School, Coach and the Individuals or Teams name as well. Can anyone help? Attached is an abbreviated version of the file. Thank you in advance for any help.
Bookmarks