Hello,
I am running into a problem where I would like to make a summary page illustrating the person with the highest value in column a. Each tab has the associated teacher and the student's name and test score. For example:
Column A Column B
Student Score
Joe 81
Matt 96
Lindsey 85
Amy 65
Courtney 60
Santiago 85
Is there a way to be able to incorporate an index, match(max) formula? I tried the following.
=INDEX('Amy Stewart:Jennifer Brown'!B3:B8,MATCH(MAX(('Amy Stewart:Jennifer Brown'!B3:B8),'Amy Stewart:Jennifer Brown'!B3:B8,0))
Any advice will be greatly appreciated.
Bookmarks