cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
lala
Level VIII

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 VIII

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
)