Origin Ver.9.1 and Service Release SR2 Operating System: W10 Home
Hello,
I am trying to find the maximum value in each column and for each maximum, I want to find its corresponding X value. I found this command xvalue(list(max(col(B)),col(B)),col(B)) but I have no idea how to make it work for multiple columns and with the output in anew worksheet. Could you please give me an idea how to do it? Also, isn't there an easier way to do this operation from "Statistics on columns"? I can get from there the index number but not x.
For Y columns in the active worksheet, can you try the following?
doc -e DY { //loop over all Y columns in the active worksheet
range ri=%C; //current Y col
cn=colnum(%C); //its column number
range ro=[maxX]!wcol(cn); //output column
ro[1]=xvalue(list(max(ri),ri),ri); //put the X of max to 1st row
}
max operation with corresponding x retrieve
Posted - 03/19/2018 : 4:40:25 PM
