| Author |
 Topic  |
|
|
Wellsyfred
Australia
2 Posts |
 Posted - 10/03/2014 : 12:48:29 AM
|
Hi,
I have multiple large datasets and am trying to programmatically find the maximum of each.
For example, if I had the data:
X Y1 Y2 Y3
1 2 7 3
2 43 65 23
3 44 34 60
I would want it to return 44, 65, 60
Additionally, I would like to find the X values corresponding to these maximum values. For my example these would be 3, 2, 3.
I have tried using max(Col(A1)) and inserting each column manually, which works fine, but would be painstaking to type out for hundreds of columns...
Origin Ver. 8.6, Windows 7
Thanks so much! |
|
|
greg
USA
1378 Posts |
Posted - 10/03/2014 : 09:13:44 AM
|
Right-click on the Title Bar of your Workbook and choose "Show Script Panel".
In the lower panel, paste the following script:
// BEGIN SCRIPT
wks.userparam1$ = Max;
wks.userparam1 = 1;
wks.userparam2$ = at X;
wks.userparam2 = 1;
loop(ii,2,wks.ncols)
{
limit wcol(ii);
wcol(ii)[Max]$ = $(limit.ymax,*5);
wcol(ii)[at X]$ = $(limit.imax);
}
// END SCRIPT
Click the Execute button. |
 |
|
|
Wellsyfred
Australia
2 Posts |
Posted - 10/04/2014 : 01:31:10 AM
|
This worked perfectly!
Thanks so much :) |
|
|
| |
Topic |
|
|
|
Maximum for multiple datasets