Formula ? Help!?

H

hagenuk

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

RagDyeR

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

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:
 
R

RagDyer

Appreciate the feed-back.

Post back if you think you'll need to deal with ties.
 
Top