1 reply
Hello,
I am using excel for analysing my data.
I have time in column A and temperature in other 10 columns.
I need to find the maximum value in each column (from column B to column K) , and should get the time (value in column A) corresponding to the maximum temperature value.
I have 100s of temperature columns and hence i need an easy way to do this.
Can anyone help me with this?
I am using excel for analysing my data.
I have time in column A and temperature in other 10 columns.
I need to find the maximum value in each column (from column B to column K) , and should get the time (value in column A) corresponding to the maximum temperature value.
I have 100s of temperature columns and hence i need an easy way to do this.
Can anyone help me with this?
