to retrieve the last value in a column
=LOOKUP(2,1/(-E1:E10<0),E1:E10)

Where A1:A10 is the range you're interested in.

Cheers
JulieD

Could someone explain the mechanics of the first two arguments in this
formula? I realize that Julie's comment referenced the wrong range in the
formula, but what is Excel doing when it reads this?

Mike F

Hi Mike

sorry, must have been having a bad day - for a full explaination of the
formula and a whole lot of other topics relating to last values check out
http://www.xldynamic.com/source/xld.LastValue.html

the article #012 - Using A Non-Array LOOKUP Formula
explains the formula that i posted.

Cheers
JulieD


"Mike Fogleman" wrote in message
...
to retrieve the last value in a column
=LOOKUP(2,1/(-E1:E10<0),E1:E10)

Where A1:A10 is the range you're interested in.

Cheers
JulieD

Could someone explain the mechanics of the first two arguments in this
formula? I realize that Julie's comment referenced the wrong range in the
formula, but what is Excel doing when it reads this?

Mike F