Lookup last entry in column
 

Hello all,
I have created a worksheet where I am continually adding to a variety of
columns.
Is there a function I can use to refer a cell to lookup the last cell in a
column with an entry?

Thanks in advance,

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !

Hi Angelo

here's a couple of formulas for you
non-zeros

=LOOKUP(2,1/(-A1:A10<0),A1:A10)

any numerical value

=INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10))

also check out

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

Cheers
JulieD
Perth, Western Australia


"Angelo Sartore" wrote in message
...
Hello all,
I have created a worksheet where I am continually adding to a variety of
columns.
Is there a function I can use to refer a cell to lookup the last cell in a
column with an entry?

Thanks in advance,

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !

Take a look at http://www.xldynamic.com/source/xld.LastValue.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Angelo Sartore" wrote in message
...
Hello all,
I have created a worksheet where I am continually adding to a variety of
columns.
Is there a function I can use to refer a cell to lookup the last cell in a
column with an entry?

Thanks in advance,

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !

Many thanks to you all. It work a treat!

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !