Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying values from zero on graph | Excel Discussion (Misc queries) |