return the bottom value in a column
Hi Gord,
Would you be willing to explain the last one of these three you offered.
Thanks
AD108
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=LOOKUP(9.99999999999999E+307,F:F) willl fetch the last numeric value in
F
=LOOKUP(REPT("z",255),B2:B10000) If column B data is of 'text' type, use
this
=LOOKUP(2,1/(A1:A65535<""),A1:A65535) will fetch last value, number or
text
Gord Dibben MS Excel MVP
On Mon, 27 Nov 2006 00:42:05 +0000, anthonyberet
wrote:
I have a worksheet which is updated regularly with a new line, working
from the top down. I would like to find worksheet function which can
return the value in the bottom cell of a column which is not blank, so
that this value can be used in another worksheet.
ie I want to be able to return the most recent value in a column at any
time.
I had hoped there would be a ready-made function for this, but it
appears not.
Any ideas?
|