cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
lala
lala
Level VIII

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

Created: Aug 19, 2022 09:42 AM  |  Last Modified: Jun 9, 2023 10:08 AM (482 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!

 

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

0 Kudos
1 REPLY 1
lala
lala
Level VIII

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

Created: Aug 19, 2022 10:06 AM  |  Last Modified: Aug 26, 2022 4:28 AM (474 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
)
0 Kudos