Time: Temp
13:32 99.6
13:34 99.8
13:36 100.0
.......
14:30 100.0
14:32 99.8

List all values (out of 5000 rows) for the time when temp is between
99.6 and 100. (Closest to 100 first)

Create an equation in column C, which will be dragged down to the last
row. (I'm assuming you start at row 1, so this is what to put in cell
C1)

=IF(B1100,"",IF(B1<99.6,"",B1))

Also put this in cell D1:

=IF(C1="","",C1)

Create a macro that highlights every row in the table for columns C and
D, sort in descending order by column C, this should give you the list
you are looking for.


--
Faz
------------------------------------------------------------------------
Faz's Profile: http://www.excelforum.com/member.php...o&userid=27830
View this thread: http://www.excelforum.com/showthread...hreadid=475446