|Subject:||Re: Excel 2003 - VBA - Lookup to determine ROW of Match|
|Posted by:||Zumble (Zumb…@Zumble.Zumble)|
|Date:||Thu, 10 Jul 2008|
There is a function in XL which returns the rownumber
Or you could use database functions to extract only the data which
corresponds to a specific month or range of dates.
"Craig Brandt" <brandtcra…@att.net> a écrit dans le message de news:
> I would like to do a lookup with the intent of determining the row of the
> I have several years of data in a flat file and am interested in doing a
> vertical lookup confined to a months worth of data. To do this I need to
> know what row the month starts and what row it ends.
Excel 2003 - VBA - Lookup to determine ROW of Match posted by Craig Brandt on Thu, 10 Jul 2008