Discussions

Solve problems, and share tips and tricks with other JMP users.

Choose Language Hide Translation Bar

Level IX

Created: Aug 19, 2022 09:42 AM | Last Modified: Jun 9, 2023 10:08 AM (1388 views)

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

Thanks!

1 REPLY 1

Level IX

Created: Aug 19, 2022 10:06 AM | Last Modified: Aug 26, 2022 4:28 AM (1380 views) | Posted in reply to message from lala 08-19-2022

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
)