I tried this stupid method and got results.Ask the experts Can this formula be simplified?
Thanks!
If( Row() > 30,
r1 = Contains( height[Index( 1, 30 )], height + 2 );
r2 = Contains( height[Index( 1, 30 )], height + 1 );
r3 = Contains( height[Index( 1, 30 )], height );
r4 = Contains( height[Index( 1, 30 )], height - 1 );
r5 = Contains( height[Index( 1, 30 )], height - 2 );
Min( If( r1 == 0, 99, r1 ), If( r2 == 0, 99, r2 ), If( r3 == 0, 99, r3 ), If( r4 == 0, 99, r4 ), If( r5 == 0, 99, r5 ) );
)
![2021-09-23_1733.png 2021-09-23_1733.png](https://community.jmp.com/t5/image/serverpage/image-id/36021i8B788F1D71B0F8C7/image-size/large?v=v2&px=999)