Formula ? Help!?
 

Ok , this is a newb question.
Some friends and I play this game were we give eachother points, the
points are changing every time and I have them summed up from J25 to
J35, the order is random. (Their names are from a25 to a35) What I now
want is to have top 8 of these auto appear in M6 to M13 (name) and N6
to N13 (points).
The one with most points on top and downwards ...
:confused:


--
hagenuk
------------------------------------------------------------------------
hagenuk's Profile: http://www.excelforum.com/member.php...o&userid=27751
View this thread: http://www.excelforum.com/showthread...hreadid=472609

Enter this in M6:

=INDEX($A$25:$A$35,MATCH(N6,$J$25:$J$35,0))

Enter this in N6:

=LARGE($J$25:$J$35,ROWS($1:1))


Then select both cells, and copy down to Row 13.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"hagenuk" wrote in
message ...

Ok , this is a newb question.
Some friends and I play this game were we give eachother points, the
points are changing every time and I have them summed up from J25 to
J35, the order is random. (Their names are from a25 to a35) What I now
want is to have top 8 of these auto appear in M6 to M13 (name) and N6
to N13 (points).
The one with most points on top and downwards ...
:confused:


--
hagenuk
------------------------------------------------------------------------
hagenuk's Profile:
http://www.excelforum.com/member.php...o&userid=27751
View this thread: http://www.excelforum.com/showthread...hreadid=472609

Thanks alot!


--
hagenuk
------------------------------------------------------------------------
hagenuk's Profile: http://www.excelforum.com/member.php...o&userid=27751
View this thread: http://www.excelforum.com/showthread...hreadid=472609

Appreciate the feed-back.

Post back if you think you'll need to deal with ties.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"hagenuk" wrote in
message ...

Thanks alot!


--
hagenuk
------------------------------------------------------------------------
hagenuk's Profile:
http://www.excelforum.com/member.php...o&userid=27751
View this thread: http://www.excelforum.com/showthread...hreadid=472609