Hi there,
I need some help with Large and Index function.
In my spreadsheets, I have the columns that contain the team name and score and the row contain the week no.
I can locate the top score and locate the week no. but I don't how to locate the Team name.
Can you please advice what formula I should use?
Please see attached sample: Highlighted in Yellow.
Regards
Ray
Bookmarks