| Author |
 Topic  |
|
|
j1623
4 Posts |
 Posted - 04/10/2022 : 02:55:16 AM
|
Hi,
I have multiple y columns and a x column. How to find maximum in every y columns and their corresponding x values? I want to plot a graph to show the distribution of the maximums. I tried "statistics on columns" to get the maximums but I don't know how to get the corresponding x values. I tried labtalk scripts but I'm not good at it.
Col(A) is the x column and start from Col(B) are y columns:
Thank you very much. |
|
|
yuki_wu
896 Posts |
|
|
j1623
4 Posts |
Posted - 04/11/2022 : 04:58:06 AM
|
quote:
Originally posted by yuki_wu
Hi,
You can use cell formula. For example, if you need to find out the x value of the maximum value in column B, you can type the function below inside an empty cell:
=table(col(B),col(A),max(col(B)));
To learn more about cell formula, please see:
https://www.originlab.com/doc/Origin-Help/Using-Formulae-to-Set-Cell-Values
Regards, Yuki
Thank you Yuki.
Sorry I have a question on table(). Can it use to search value across columns?
Column A is x values and columns B-CX are Y values. In column CX and CY I have the column name(B-CX) and the index of their corresponding target vale.
How can I get the corresponding Y value in a column? For example, row 1: B[76], row 2: C[66], row 3: D[76], row 4: E[63], ...
Thank you very much! |
 |
|
|
yuki_wu
896 Posts |
|
| |
Topic |
|
|
|
find maximum in y columns & their x values