# How to extract top 5 values with display its adjacent cells values?

1. ## How to extract top 5 values with display its adjacent cells values?

Column A=Location, Column=Percentage
my formula =Index(\$A\$13:\$A\$40,Match(Large(\$D\$13:\$D\$40+Rows(\$D\$13:\$D\$40)/100,B2),\$D\$13:\$D\$40+Rows(\$D\$13:\$D\$40)/100,0))
The formula doesn't work, it returns nothing but value error. I need to extract the top 5 values includes ties if any with display its adjacent cells values(location). Thank You.

2. ## Re: How to extract top 5 values with display its adjacent cells values?

=INDEX(\$A\$13:\$A\$40,match(large(D\$13:\$D\$40,rows(\$1:1)),D\$13:\$D\$40,0))
Entry with CtrL+Shift+Enter

Copy down

See Tony's post which accounts for duplicates.

3. ## Re: How to extract top 5 values with display its adjacent cells values?

See this...

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1