Hi all,
I m a relative newbie to excel and would really appreciate some assistance with a formula I'm playing with.
Example problem: I have a list of train times and am trying to get excel to load up the next train time from the list based on the current time.
The formula I am using is:
$B$12:$B$83 is the source list of times
$B$1 is the current time
Although the formula does match to the nearest train time from the list, sometimes this time is in the past (e.g. current time 21:10, but excel highlights 20:56 as the next train time as its the nearest match to the list).
Is there a way I can tweak the formula so that it matches to the next greatest timing from the list?
Thanks in advance
E
I m a relative newbie to excel and would really appreciate some assistance with a formula I'm playing with.
Example problem: I have a list of train times and am trying to get excel to load up the next train time from the list based on the current time.
The formula I am using is:
Excel Formula:
=INDEX($B$12:$B$83,MATCH(MIN(ABS($B$12:$B$83-$B$1)),ABS($B$12:$B$83-$B$1),0))
$B$12:$B$83 is the source list of times
$B$1 is the current time
Although the formula does match to the nearest train time from the list, sometimes this time is in the past (e.g. current time 21:10, but excel highlights 20:56 as the next train time as its the nearest match to the list).
Is there a way I can tweak the formula so that it matches to the next greatest timing from the list?
Thanks in advance
E