Lookup last entry in column

[Angelo Sartore]

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 !

 

[JulieD]

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

 

[Bob Phillips]

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]

Many thanks to you all. It work a treat!

Angelo Sartore

Melbourne
AUSTRALIA

ADOPT, ADAPT, INVENT, DESTROY !