Hi guys.
I've been trying to make this feature for a few days now and I still
can't come with any solution :(

Let's suppose I have the following table:

[image: http://img203.imageshack.us/img203/5...board18tf.jpg]

I need the top-5 people with the top 5 highest scores to be transferred
into the second table automatically. Name goes to the left column, score
goes to the right one.

Ok, adding the scores is not a problem, I'm using the following
formulas:

B15 = LARGE(B2:B10;1)
B16 = LARGE(B2:B10;2)
B17 = LARGE(B2:B10;3)
B18 = LARGE(B2:B10;4)
B19 = LARGE(B2:B10;5)

Now how do I make a name going to the appropriate cell?
I've tryed using the following function
=OFFSET(A1;MATCH(LARGE(B2:B10;k);B2:B10;0);0;1;1)
where -k- is the required k-th largest number...and it works fine! As
long as there are no repeating scores.

Now look what I get when I try to do this:

[image: http://img216.imageshack.us/img216/5...board25af.jpg]

Notice second and third positions. The names are the same, while one of
them Joes is supposed to be Nick.
I guess the problem here is in MATCH function which returns the
position of the first matching value, which is then used in OFFSET
function to get a name.
So...how can I fix this?


--
Landanan
------------------------------------------------------------------------
Landanan's Profile: http://www.excelforum.com/member.php...o&userid=31262
View this thread: http://www.excelforum.com/showthread...hreadid=509352