Previous Topic Next Topic

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
Related:

1 response

Answer 1 / 1
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?

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses
Find my Gmail account
Dabang -
HelpiOS -

Hello, Help me to find my Gmail account

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses