I have data file which has 3 columns. I need to find the maximum values each from column 2 and 3 and then find the values in column 1 for which the values in column 2 and 3 are 0.24 of the maximum values of column 2 and 3. How to do this?

I have data file which has 3 columns. I need to find the maximum values each from column 2 and 3 and then find the values in column 1 for which the values in column 2 and 3 are 0.24 of the maximum values of column 2 and 3.

[Bob Thompson]

You can use max() to find the maximum values of the two columns, just index to only look at those columns.

You can use find() to determine the location of values which are 0.24*max in the second and third columns.

You can find the values of the first column which relate through indexing.