Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Formula
This should be easy, but I can't seem to get it to work.
I have several columns of data relating to Hockey Team stats. One of the columns contains total points per player. I would like to use the 'LARGE' function to identify the top five values in the points coulmn, and return the associated players name via an 'OFFSET' function. I have tried the following, which looks OK to me, but doesn't seem to work. =OFFSET(LARGE(M14:M29,1),0,-8) -- LTR |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Formula
Try this:
A1: Rank B1: Score C1: Name A2:A6 enter numbers 1 through 5 B2: =LARGE($N$14:$N$29,A2) Copy that down through B6 C2: =INDEX($M$14:$M$29,MATCH(B2,$N$14:$N$29,0)) Copy that down through C6 Does that help? *********** Regards, Ron "MichaelS" wrote: This should be easy, but I can't seem to get it to work. I have several columns of data relating to Hockey Team stats. One of the columns contains total points per player. I would like to use the 'LARGE' function to identify the top five values in the points coulmn, and return the associated players name via an 'OFFSET' function. I have tried the following, which looks OK to me, but doesn't seem to work. =OFFSET(LARGE(M14:M29,1),0,-8) -- LTR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel nested IF formula question | Excel Discussion (Misc queries) | |||
Hide formula | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
UPDATED - Referencing named Ranges within a Nested IF formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |