K
Ken
Excel 2000 ... I have a list of random numbers (event
readings) ... Criteria may be AVERAGE, SELECTED, or a
particular RANK within the RANGE.
My ? to the board ... if RANK criteria happens to be
Lowest number (MIN will do it) ... Highest number (MAX
will do it) ... But what if I am looking for the 2nd
lowest value ... or 5th lowest ... or 3rd highest etc etc.
Is there a formula that will do this?
Thanks ... Kha
readings) ... Criteria may be AVERAGE, SELECTED, or a
particular RANK within the RANGE.
My ? to the board ... if RANK criteria happens to be
Lowest number (MIN will do it) ... Highest number (MAX
will do it) ... But what if I am looking for the 2nd
lowest value ... or 5th lowest ... or 3rd highest etc etc.
Is there a formula that will do this?
Thanks ... Kha