topic Re: How do we find the max value of several rows in a column? in Discussions

How do we find the max value of several rows in a column?

TDK_Long — Tue, 19 Dec 2023 23:04:27 GMT

Hi folks,

I know how to find the maximum value in a whole column, my question is how can we find the maximum value from row#3 to row#7 in a column. In Excel, we can easily command it: max(number3 : number7), is there a similar way with JSL? Thank you.

Re: How do we find the max value of several rows in a column?

txnelson — Wed, 20 Dec 2023 03:47:02 GMT

max(:number[3::7]);

Re: How do we find the max value of several rows in a column?

TDK_Long — Fri, 29 Dec 2023 16:10:26 GMT

Thanks, Jim