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 |
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) |