3 Replies Latest reply on Mar 12, 2014 2:58 PM by Desiree Koh

    How do you find the second (or nth) highest value in an un-ordered group of records using a calculation?

    Desiree Koh

      I'm trying write a calculation that would return the second (or nth) highest value in the attached workbook. So for product a I would like to get 19 since that is the second highest value for a.


      I would like it to work similarly to the MAX function, but instead of returning the MAX, return the nth value (n would be based off another function).


      Thanks in advance!