Is there a Column Formula to find 2nd highest value?
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 an...