Dear all, I am looking for a way using the set values function to get Min value in a column which range from max value in that column to the end of the column. I will really appreciate your help.
Before Formula Script:
sum(col(A));
smax=sum.max;
simax=sum.imax;
range rr=col(A)[$(simax):<end>];
sum(rr);
smin=sum.min;
simin=sum.imin;
col(B)=
i==1?simax: (i==2?smax: (i==3?simin:(i==4?smin:0)))
It shows the max position, the value, the min position after the max, and the value.
Before Formula Script:
sum(col(A));
smax=sum.max;
simax=sum.imax;
range rr=col(A)[$(simax):<end>];
sum(rr);
smin=sum.min;
simin=sum.imin;
col(B)=
i==1?simax: (i==2?smax: (i==3?simin:(i==4?smin:0)))
It shows the max position, the value, the min position after the max, and the value.
Min value in a range from max to end
Posted - 08/23/2017 : 09:57:22 AM
