Finding Min Value in a set of data and populating it in next column then selecting it to subset it

[#1]

Hi,

From the attached test2.JMP file I am looking to eventually get Subset of Result.JMP.

so basically I am looking to:

1) find the min value until there is no data for -3dB column then populate that min value in the next column but same row

2) Select the rows with only those min value populated in another column

3) Subset the selected rows.

I tried min, col min, rank etc functions but with no luck. 

Finding that min value for only a set of rows (not all rows) in a particular column and then populating in next column is the main challenge. 

Please help!

[#2 · Accepted solution]

Here is the formula that I cam up with

If( Row() == 1,
	theMin = 9999999999999;
	theCount = 0;
);
x = .;
If( Is Missing( :"-3dB"n ) == 0,
	If( theMIn >= :"-3dB"n,
		theMin = :"-3dB"n
	);
	If( Is Missing( Lag( :"-3dB"n, -1 ) ) == 1,
		x = theMin;
		theMin = 9999999999;
	,
		x = .
	);
);
x;

[#3]

Thank you

[#4 · Accepted solution]

If you are building a script to do this analysis multiple times, then great!

If this is just a one time analysis, then the better way to do this is by making a graph and then selecting the points in the graph and subsetting them.

[#5]

Thank you Pauldeen.

It was for multiple times so had to create a script