cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles