T O P I C R E V I E W |
mvww |
Posted - 09/13/2012 : 11:02:47 AM Origin Ver. and Service Release (Select Help-->About Origin): V8.0724 Operating System: Windows 7
Hello. I want each row of colum(X) to get the smallest value of other colums. For example: Colum(X): row 1 -> smallest value of colum(A) row 2 -> smallest value of colum(B) row 4 -> smallest value of colum(C) ...
Regards. |
1 L A T E S T R E P L I E S (Newest First) |
JacquelineHe |
Posted - 09/14/2012 : 12:02:10 AM Hi
If the X column is the first column, you can use this Labtalk script as following to get the minimum value of others columns to the X column.
1. Select "Window: Command Window" in the menu. 2. Copy this script to the Window, and run it.
// BEGIN SCRIPT for( int ii = 1 ; ii < wks.ncols; ii+=1) { wks.col = ii; [book1]!Cell(ii,1)=min(wcol(ii+1)) ; }; // END SCRIPT
Jacqueline Originlab |
|
|