Excel Lookup

Closed
Zeenath - Feb 17, 2009 at 09:05 AM
 Zeenath - Feb 17, 2009 at 09:33 AM
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