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 ...
--
hagenuk
------------------------------------------------------------------------
hagenuk's Profile:
http://www.excelforum.com/member.php...o&userid=27751
View this thread:
http://www.excelforum.com/showthread...hreadid=472609