This is an update that probably closes out this thread.
I found two things that help me.
1) I found that I can generate the month and year string using
TEXT(ref;"MMMM YYYY").
2) I found that I can find the row that contains that month and year string
using
MATCH("MMMM YYYY";ref_to_the_column_vector;0)
These two discoveries will make my task very much easier.
--
Jim
On Saturday, March 03, 2007 2:06 PM -0800 I wrote:
I am looking for a function or combination of functions that can search a
column for a cell that contains a specific string (e.g. "January 2007")
and return a reference to that cell so that I can use it as the first
parameter in an OFFSET() function call.. The data I want to access
begins in the row following the one in which the string exists and ends
in the row before the one containing the formula invoking the
function(s) so I don't see how I can use any of the variations of
LOOKUP(). I need a function that will return a cell reference
In effect I am wanting to break up my sheet of financial data into tables
that are dynamically defined and named. At the bottom of each month I
want to create totals for each column for that month. That involves
locating the top of that month's entries and I don't want to have to
create the formula manually each month. I plan to use the MONTH()
function on the date of the final entry for the month as the first
parameter given to the CHOOSE() function to select the month name and
concatenate that with the YEAR() function in order to create the search
string. Each month has a header displays the month and year generated
the same way from the date of the first entry for the month.
If there's a better way to accomplish this then please feel free to point
out my ignorance and show me how I could accomplish this task more
simply.
My project is quite small since it relates to financial data for shared
household expenses (rent, gas, electricity, phone, water, sewer, trash,
Internet, tv, yard, misc.).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
