Return a name that goes with data from multiple sheets

[Theteacher]

I have a workbook with multiple sheets. The last sheet returns the 10 largest inputs from all the sheets. I cant seem to get the data that belongs to the outcome. I want to have the name that belongs to the largest number in the column left to the number.


-- removed inline image ---

 

[Robert Mika]

Hi TheTeacher and welcome to the board.
Is your results based on formula or macro?
If on formula could you post it?

 

[Theteacher]

=LARGE(year01:year97!A:C;1)
=LARGE(year01:year97!A:C;2) etc.
Its a list of grades in different classes.
In the last sheet I have the top ten students. I have the formula working great to return the grades but I cant seem to get the names to come with it.
The names are in column A and the data in Column B...

-- removed inline image ---

 

[Robert Mika]

Are the names in column D?

To post your data you can download and install two of the following programs:

HTLMaker

or
Excel Jeanie

or when using Internet Explorer just put a borders around your data in Excel and copy those cells into your post.

 

[Theteacher]

https://sites.google.com/site/ymislegtannad/