nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

So how do this quickly in excel using JSL?

lwx228

As shown in figure：

Open Probe file：Copy the "Start Time" column and J column of the "DELL_RPNBR" file to excel

Enter formula I in excel[C5]：=IF(B5=MAX(B2:B8),A5,0)

How is this implemented in JMP with JSL?Can I only use the FOR loop?Thank you very much!

Accepted answers

txnelson

I believe a formula below, or something close to this will work:

If(
	:DELL_RPNBR == Max(
		Max( :DELL_RPNBR[Index( Row() - 4, Row() - 1 )] ),
		Max( :DELL_RPNBR[Index( Row() + 1, Row() + 4 )] )
	),
	:Start Time,
	0
)

All comments

lwx228

Input formula in column "Site" and calculate according to the following requirements:
If the value of a row in "DELL_RPNBR" column is the maximum of 3 rows above it and 3 rows below it, the value of the same row in "Start Time" column is returned; otherwise, "Site" row[] it is 0.

lwx228

dt = Open( "$SAMPLE_DATA/Probe.jmp" );

txnelson

I believe a formula below, or something close to this will work:

If(
	:DELL_RPNBR == Max(
		Max( :DELL_RPNBR[Index( Row() - 4, Row() - 1 )] ),
		Max( :DELL_RPNBR[Index( Row() + 1, Row() + 4 )] )
	),
	:Start Time,
	0
)

lwx228

Thank Jim!

If(
:DELL_RPNBR == Max(
Max( :DELL_RPNBR[Index( Row() - 4, Row())] ),
Max( :DELL_RPNBR[Index( Row() , Row() + 4 )] )
),
:Start Time,
0
)

lwx228

This method is very practical !

lwx228

continue

lwx228

it should be

If(:DELL_RPNBR==(Max(:DELL_RPNBR[Index(Row()-4,Row()+4)])),:Start Time,0)