https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721409#M90348 <P>Thanks much to Craige_Hales for a quick response.</P><P>It works well</P> Thu, 01 Feb 2024 19:13:28 GMT VD 2024-02-01T19:13:28Z https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721081#M90310 Thu, 01 Feb 2024 00:48:19 GMT https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721081#M90310 VD 2024-02-01T00:48:19Z https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721113#M90311 <PRE><CODE class=" language-jsl">dt = Open( "$sample_data/big class.jmp" ); nr = N Rows( dt ); // needed below to find the end of the ascending sort list rowsSortedByWeight = Rank( dt:weight &lt;&lt; getvalues ); // Rank gives the indexes, ascending heavyRows = rowsSortedByWeight[nr - 3 :: nr]; // four biggest at end For Each( {r}, heavyRows, // get each row number into r from the heavyRows matrix // look in the log for the report... Write( Eval Insert( "\!nname=^dt:name[r]^ weight=^dt:weight[r]^" ) ) );</CODE></PRE> <P><STRONG>name=KIRK weight=134</STRONG><BR /><STRONG>name=LESLIE weight=142</STRONG><BR /><STRONG>name=JACLYN weight=145</STRONG><BR /><STRONG>name=LAWRENCE weight=172</STRONG></P> <P>edit: this will work better with missing values:</P> <PRE><CODE class=" language-jsl">dt = Open( "$sample_data/big class.jmp" ); rowsSortedByWeight = Rank( dt:weight &lt;&lt; getvalues ); // Rank gives the indexes, ascending nr = N Rows( rowsSortedByWeight ); // should handle missing values heavyRows = rowsSortedByWeight[nr - 3 :: nr]; // four biggest at end For Each( {r}, heavyRows, // get each row number into r from the heavyRows matrix // look in the log for the report... Write( Eval Insert( "\!nname=^dt:name[r]^ weight=^dt:weight[r]^" ) ) );</CODE></PRE> <P>Rank() will return a short list, without indexes to missing values, so use the number of rows in the ranked list rather than the number of rows in the data table.</P> <P>more edit: And if you mean to select the rows in the table,</P> <PRE><CODE class=" language-jsl">dt &lt;&lt; selectrows( heavyRows )</CODE></PRE> Thu, 01 Feb 2024 01:43:52 GMT https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721113#M90311 Craige_Hales 2024-02-01T01:43:52Z https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721409#M90348 <P>Thanks much to Craige_Hales for a quick response.</P><P>It works well</P> Thu, 01 Feb 2024 19:13:28 GMT https://community.jmp.com/t5/Discussions/Please-help-for-how-to-script-to-select-the-4-highest-cell-value/m-p/721409#M90348 VD 2024-02-01T19:13:28Z