Is there a Column Formula to find 2nd highest value?

Question

Hello all -

I am wondering if someone can help with something that has been stumping me in JMP.  I have columns 1-10 that contain a value from the RandomGamma(1) function.  I am trying to come up with a formula to enter for column 11 that would pull out the second highest value of columns 1-10 for any row.  It would be like finding the second highest Maximum for columns 1-10.   Does anyone have any ideas of how to do this?  I am a student who is new(ish) to JMP and would appreciate as simple an answer as possible as I am very much still learning.

Thanks!

Wendy_Murphrey · Accepted Answer

The Sort Descending() function would return the values in descending order. The following demonstrates the concept.  The subscript of 2 will capture the second highest value. You will need to change the column names to your actual column names:

Sort Descending( Eval List( {:A, :B, :C} ) )[2]

Hope that helps!