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.

      Data2.PNG.png

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

      Data3.PNG.png

      Thanks in advance!