• 465K Members
• 11K Online
• 563K Conversations
SOLVED

New Contributor

Hello, I'm trying to produce a table containing the top 5 "top scores" with the name extracted aswell.

I'm extremely new to spreadsheets in general, so go easy.

I've managed to extract the top 5 percentages using the "large" function

"=LARGE(\$E\$3:\$R\$3,V3)"

But I cant seem to extract the names along side the percentages. I followed a video and used their formula:

"=IF(V3="","",INDEX(\$E\$2:\$R\$2,AGGREGATE(15,6,(ROW(\$E\$3:\$R\$3)-ROW(\$E\$3)+1)/(\$E\$3:\$R\$3=W3),COUNTIF(\$W\$3:W3,W3))))"

This doesnt work, it produces the first name is the table "Jack"

I hope I've provided enough material for a helpful responce if not let me know, Cheers.

4 Replies

Solution

# Re: Excel Spreadsheet Extract Data

Hi,

Since you return the per cent in your resulting table, you don't need to use AGGREGATE with criteria, you may use simple INDEX/MATCH on that per cent

Sample is in the attached file

# Re: Excel Spreadsheet Extract Data

Awesome, works perfectly. Thanks so much!

# Re: Excel Spreadsheet Extract Data

You are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies