finding values and displaying adjacent values

W

willy3211

I have an Excel File that I am trying to pull data from.

I'm dealing with Time, and Temperature.

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

I want to create a macro that will find any value, that is closest to 100,
or is less than 100 down to 99.6. I then want it to list the time adjacent to
that value.
In this example, it would list 13:32, 13:34, 13:36, and 14:30, 14:32...and
so on It would be even better if it would list only 13:34 and 14:32

Note, the colums have up to 5000 rows...and the values will re-occur
throughout. I know how to make a macro...I just need the formula or
formulas!!

HELP!

Thanks,

Will
 
F

Faz

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 betwee
99.6 and 100. (Closest to 100 first)

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

=IF(B1>100,"",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 an
D, sort in descending order by column C, this should give you the lis
you are looking for
 
Top