how to get the recent values corresponds to the time
 

hi guys
suppose i have column like that
1 2
time activity
9:30 am 1st class
11:30am break
11:45am second class
1:00 pm third class

my question is i want to do the following
according to the time of the system suppose 10:30am the excel will tel
me the current activity is 1st class
and when i reach or pass 11:30 am will tell me "secod class"
so how can i make that happend in excel?

--
amrezza
-----------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=53890

how to get the recent values corresponds to the time
 

Look at the vlookup worksheet function

--
Regards,
Tom Ogilvy


"amrezzat" wrote:


hi guys
suppose i have column like that
1 2
time activity
9:30 am 1st class
11:30am break
11:45am second class
1:00 pm third class

my question is i want to do the following
according to the time of the system suppose 10:30am the excel will tell
me the current activity is 1st class
and when i reach or pass 11:30 am will tell me "secod class"
so how can i make that happend in excel??


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=538900