# using LARGE and OFFSET in a lookup

#### Tinkerz

##### Board Regular
=ROUND(OFFSET(DD\$2:DD\$121,MATCH(LARGE(DD\$2:DD\$121,\$A126),DD\$2:DD\$121,0)-1,0,1),4)

I am looking up the largest 10 numbers and then matching them to get a number to offset to a list.

If I have the same number in my Match statement it goes to the first number, how can I code a formula to ingnore previous match's of the same number?

Thanks

Tinkerz

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
=ROUND(OFFSET(DD\$2:DD\$121,MATCH(LARGE(DD\$2:DD\$121,\$A126),DD\$2:DD\$121,0)-1,0,1),4)

I am looking up the largest 10 numbers and then matching them to get a number to offset to a list.

If I have the same number in my Match statement it goes to the first number, how can I code a formula to ingnore previous match's of the same number?

Thanks

Tinkerz

Here are 7 numbers...

6
4
4
8
3
7
2

Would you formulate your intent vis-a-vis 4 largest numbers in this sample along with the desired results?

Replies
0
Views
273
Replies
3
Views
182
Replies
0
Views
264
Replies
3
Views
249
Replies
3
Views
455

1,207,402
Messages
6,078,264
Members
446,324
Latest member
JKamlet

### 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