Hi, Akbreezo
If your data is in columns A:B and you ranges are name Dive_1, Dive_2,
etc, I think this will work for you:
1)Put the name of the range to query in Cell C1 (eg dive_1).
2)Put the depth to test in Cell C2 (eg 40).
3)Start time of test depth is in cell D1
D1: =MIN(IF(OFFSET(INDIRECT(C1),,1,,1)=C2,OFFSET(INDIR ECT(C1),,,,1)))
4)End time of test depth is in cell D2
D2:
=MIN(IF(OFFSET(INDIRECT(C1),,,,1)D1,IF(OFFSET(IND IRECT(C1),,1,,1)<C2,OFFSET(INDIRECT(C1),,,,1))))
(Note: Commit those array formulas using [Ctrl]+[Shift]+[Enter]
To check dive_2, just type "dive_2" in Cell C1 and change the test
depth in C2.
Does that give you what you're looking for?
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=379185