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.
Thanks!
ScriptingRe: 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
)
