Min function with an offset
 

I have a range of data about 2 coulmns and 30 rows worth. I need to find the
minimum value in column2, so I use the min function. Then also I need to find
the corresponding time in column 1 that will be in the same row as the
minimum found.

For example the data below if -60 is my low, I use the min function to tell
me that but I need another function to tell me the time of the lowest value.
i.e.
A B
12:00 -48
1:00 24
2:00 -60
3:00 -5

Any ideas?

thanks,

Jase

Min function with an offset
 

Try this

=INDEX(A1:A6,MATCH(MIN(B1:B6),B1:B6,FALSE),1)

Mike

"Jase" wrote:

I have a range of data about 2 coulmns and 30 rows worth. I need to find the
minimum value in column2, so I use the min function. Then also I need to find
the corresponding time in column 1 that will be in the same row as the
minimum found.

For example the data below if -60 is my low, I use the min function to tell
me that but I need another function to tell me the time of the lowest value.
i.e.
A B
12:00 -48
1:00 24
2:00 -60
3:00 -5

Any ideas?

thanks,

Jase