Excel Lookup

[Closed]
Report
-
 Zeenath -
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?

Thanks

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?
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month