cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
TDK_Long
Level III

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

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. 

 

TDK_Long_0-1703026898730.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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

View solution in original post

2 REPLIES 2
txnelson
Super User

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

max(:number[3::7]);
Jim
TDK_Long
Level III

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

Thanks, Jim