View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgiessler pgiessler is offline
external usenet poster
 
Posts: 17
Default Lookup Current Date and Find Next 5 enteries

Hi,

I am looking for a good way (something that works in 2007 & 2003) for find
the current date in a list of data and return that data plus the next 4
subsequent data points on a separate worksheet.


28-Apr-2009 Columbus
29-Apr-2009 Denver
5-May-2009 Canton
10-May-2009 Detroit
11-May-2009 Houston
11-May-2009 Dallas
20-May-2009 Boston

So, in the data set shown above ... I would just want the date and city data
in rows 2 through 6.

Any ideas would be greatly appreciated.