Min function with an offset


J

Jase

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top