using LARGE and OFFSET in a lookup

[Tinkerz]

=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

 

[Aladin Akyurek]

=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?