# List Top 3 Text & Values?

#### ttamvegas

##### New Member
I have a large list with text of item names in column A and their values in column B.

I used =LARGE(B3:B43, 1) =LARGE(B3:B43, 2) =LARGE(B3:B43, 3)
to find the Top 3 values and it works fine, however I want to bring the Item name from column A as well not just the value. How would I do this? thanks!

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

#### JackDanIce

##### Well-known Member
Welcome to the board.
Try:
Code:
``````=OFFSET(INDIRECT("B"&LARGE(B3:B43,1)),0,-1)
=OFFSET(INDIRECT("B"&LARGE(B3:B43,2)),0,-1)
=OFFSET(INDIRECT("B"&LARGE(B3:B43,3)),0,-1)``````

#### Andrew Poulsom

##### MrExcel MVP
Try eg:

=INDEX(A3:A43,MATCH(LARGE(B3:B43,1),B3:B43,FALSE))

#### Dryver14

##### Well-known Member
try this

=LARGE(B3:B9,1)&" "&INDEX(A3:A9,MATCH(LARGE(B3:B9,1),B3:B9,0))

#### kennycwhite

##### New Member
With respect to the equation below, if there are duplicate values in B:B it returns the same values for as many duplicates as there are. So if the 4th largest and 5th largest in B:B are the number 3 then it currently returns the same thing for 4th largest and 5th largest although the values in A:A are different. It will then return the correct value for the 6th largest. It doesn't matter which one it returns as 4th or 5th, I just need it to return both values separately. There will be an unknown number of duplicates in B:B, I am focusing on grabbing the 10 largest values along with the value in the corresponding A column. I tried to attach as screenshot, hopefully it works so you can see what the results are yielding.

=LARGE(B:B,1)&" "&INDEX(A:A,MATCH(LARGE(B:B,1),B:B,0))

Replies
2
Views
265
Replies
8
Views
310
Replies
4
Views
235
Replies
26
Views
866
Replies
1
Views
273

1,191,179
Messages
5,985,149
Members
439,943
Latest member
bowlgud2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back