cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
Choose Language Hide Translation Bar
lala
Level IX

How do I determine whether the data in the specified range meets the criteria?

For example, find the height column with four consecutive rows between the top 10 rows and the top 20 rows >>60 and <65.

Thanks!

 

2022-08-19_21-37-24.png

1 REPLY 1
lala
Level IX

Re: How do I determine whether the data in the specified range meets the criteria?

Sum(
	60 < height[Index( Row() - 19, Row() - 10 )] < 65 & 
	60 < height[Index( Row() - 18, Row() - 9  )] < 65 & 
	60 < height[Index( Row() - 17, Row() - 8  )] < 65 & 
	60 < height[Index( Row() - 16, Row() - 7  )] < 65
)

Recommended Articles