Hi Guys,
so I'm trying to create a summary page that will pull through the name of the highest point scorer on various different tabs. I have attached the workbook. I am trying to get B5 on the "summary SPH" tab to show the same of the highest scorer on the "Leeds" Tab, so it would be "Lucy Bond" as per point score is 34. Does that make sense?
Try
=INDEX(INDIRECT("'" & A5 & "'!G3:G100"),MATCH(MAX(INDIRECT("'" & A5 &"'!H3:H100")),INDIRECT("'" &A5 & "'!H3:h100"),0))
Rebecca Snare!
thank you!
oooh...one more quick question if you don't mind? if I wanted to have another cell on my summary page that pulled through the name of the overall points winner from all tabs...how would I do that? thank you so much in advance. xx
A low tech way to do this would be to use a helper column, which could be hidden for aesthetic purposes. The helper column would be populated by a modification of John's formula such that the index would point to column H of each tab, so that it would read:Formula:
Please Login or Register to view this content.
Another index/match formula would then find the highest score from the helper and display the name using the formula:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
thank you! that's exactly what I needed!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks