I'm trying to get a formula result to return the value in the last filled row
of a column on a worksheet in another book. I've used "LASTINCOLUMN" before,
but can't seem to make it work this time. Additionally, the last row in the
appropriate column contains a subtotal. Could that be throwing me off?

Anyone have any ideas?

One way, assuming numerical values:

=OFFSET(A1,MATCH(9.99999999999999E+307,A:A)-1,)

For text strings *and* numerical values:

=INDEX(A:A,MAX(IF(ISBLANK(A1:A65535),0,ROW(A1:A655 35))))

Array-entered. Press ctrl + shift + enter. To learn more,
see:

http://www.xldynamic.com/source/xld.LastValue.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to get a formula result to return the value
in the last filled row
of a column on a worksheet in another book. I've
used "LASTINCOLUMN" before,
but can't seem to make it work this time. Additionally,
the last row in the
appropriate column contains a subtotal. Could that be
throwing me off?

Anyone have any ideas?
.

=LOOKUP(9.99999999999999E+307,A:A)

would pick up the last numerical value in column A.

EAN wrote:
I'm trying to get a formula result to return the value in the last filled row
of a column on a worksheet in another book. I've used "LASTINCOLUMN" before,
but can't seem to make it work this time. Additionally, the last row in the
appropriate column contains a subtotal. Could that be throwing me off?

Anyone have any ideas?

Thanks so much for your help!

"EAN" wrote:

I'm trying to get a formula result to return the value in the last filled row
of a column on a worksheet in another book. I've used "LASTINCOLUMN" before,
but can't seem to make it work this time. Additionally, the last row in the
appropriate column contains a subtotal. Could that be throwing me off?

Anyone have any ideas?