Re: Excel 2003 - VBA - Lookup to determine ROW of Match

Giganews Newsgroups
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
= ROW()

Or you could use database functions to extract only the data which
corresponds to a specific month or range of dates.

Z.

"Craig Brandt" <brandtcra…@att.net> a écrit dans le message de news:
bFodk.31990$ZE5.231…@nlpi061.nbdc.sbc.com...
> Hi;
>
> I would like to do a lookup with the intent of determining the row of the
> match.
>
> 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.
>
> Thanks,
> Craig

Replies

None

In response to

Excel 2003 - VBA - Lookup to determine ROW of Match posted by Craig Brandt on Thu, 10 Jul 2008