software

Hello everyone

I am currently using the formula =LOOKUP(9.99999999999999E 307,A:A) to
find the last number in a colmn (The above formula was thanks from
Aladin) But unfortuneately it will not work if there are formulas in
the column. does anyone know how to solve this problem as I really do
need to keep this formula in that column.

Thankyou

Paul Maynard
Moscow.--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: www.excelforum.com/member.php...oamp;userid=28776
View this thread: www.excelforum.com/showthread...hreadid=524023For alternative formulae see:

www.xldynamic.com/source/xld....l#last_numeric
--
Gary's Studentquot;paulrm906quot; wrote:

gt;
gt; Hello everyone
gt;
gt; I am currently using the formula =LOOKUP(9.99999999999999E 307,A:A) to
gt; find the last number in a colmn (The above formula was thanks from
gt; Aladin) But unfortuneately it will not work if there are formulas in
gt; the column. does anyone know how to solve this problem as I really do
gt; need to keep this formula in that column.
gt;
gt; Thankyou
gt;
gt; Paul Maynard
gt; Moscow.
gt;
gt;
gt; --
gt; paulrm906
gt; ------------------------------------------------------------------------
gt; paulrm906's Profile: www.excelforum.com/member.php...oamp;userid=28776
gt; View this thread: www.excelforum.com/showthread...hreadid=524023
gt;
gt;


Thanks Gary's Student

It works great and the link as many useful formulas also

Thankyou

Paul Maynard--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: www.excelforum.com/member.php...oamp;userid=28776
View this thread: www.excelforum.com/showthread...hreadid=524023