Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
Use of OFFSET function | Excel Worksheet Functions | |||
Help with OffSet Function! | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
help with offset function | Excel Worksheet Functions |