What is the figure in the last cell?

[Maddoktor]

Hi all,

If column A had values in cells from A1 to A8, I would like to know of a
formula that will check column A, find the value in the last cell (that
would be A8) and copy that value into another cell.

Thank you in advance.

 

[Paul B]

Maddoktor, have a look here for info on finding the last valve

http://www.xldynamic.com/source/xld.LastValue.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Maddoktor]

Thanx Paul.

It worked the way I hoped for.

Maddoktor, have a look here for info on finding the last valve

http://www.xldynamic.com/source/xld.LastValue.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003