How to use function to find the first position greater than the specified starting position?

[#1]

Use the function to find the first position of the weight column in the top 5 rows greater than 120.

Excuse me, Thanks!

[#2 · Accepted solution]

Here is one way to do it

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

dt << New Column( "match",
	formula(
		value = .;
		If( Row() > 5,
			count = 0;
			For( i = Row() - 5, i <= Row() - 1, i++,
				count++;
				If( :weight[i] > 120,
					value = count;
					Break();
				);
			);
		);
		value;
	)
);

[#3]

It seems to me that this kind of calculation is needed by fewer people.

Thank Jim!
This calculation can be done in excel using a simple array formula.
{=MATCH(,IF(E2:E6>120,),)}

[#4 · Accepted solution]

The JSL function that here corresponds to Excel's Match() would be Loc(). However, Loc() returns a matrix with the position of all matches, not just the first (or last).

Example:

dt << New Column("match",
    formula(If(Row() > 4, Loc(:weight[Row() - 4 :: Row()] > 120)[1]))
);