| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 ...  -- hagenuk ------------------------------------------------------------------------ hagenuk's Profile: http://www.excelforum.com/member.php...o&userid=27751 View this thread: http://www.excelforum.com/showthread...hreadid=472609 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
