09-16-2016 11:40 AM
What i am trying to accomplish is the following , i have an array with 4 variables containing values lest say 1, 2 ,5, 6 etc.
I am able to get the max value of the array and have the column name returned but I am stuck on how I can do the same procedure for the next largest value, any ideas?
Kind regards and thank you in advance
This is my script up till now
ARRAY COL(*) col1 --col4;
INDEX_OF_MAX=WHICHN(MAX(OF COL(*)),OF COL(*));
09-16-2016 01:00 PM
The function LARGEST is what you are looking for.
Second = Largest(2, of col(*));
Third = Largest(3, of col(*));
and so on. the 2 or 3 could be a variable as well.