| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
| Lookup to find the last value based on name and date field | Excel Discussion (Misc queries) | |||
| xls vba find method to find row that contains the current date | Excel Programming | |||
| how do I find duplicate text enteries in Excel | Excel Discussion (Misc queries) | |||
| Function to find row with most current date | Excel Worksheet Functions | |||
Threaded Mode
