• 516K Members
• 3,838 Online
• 612K Conversations
SOLVED

Highlighted
New Contributor

Excel Spreadsheet Extract Data

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

Re: Excel Spreadsheet Extract Data

It is better if you upload your sample file.
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
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Extract data from multiple sheet into one with conditions
TheCarb1 in Excel on
4 Replies
Data Extraction
Seth Pontiff in Excel on
6 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies