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
Bookmarks