=LOOKUP(9.999E+307,A1:A44)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"DME" <craigjoseathotmaildotcom wrote in message
...
Is there a formula to display the last number in a column.

I have data rows 1-31 in 12 different columns. I want a to be able to
pick
up a the last number entered in each of the columns. So for instance and
have data in rows 1-23 in column A, the data in rows 1-31 ni col B. Is
there a formula to put in row 45 that will pick up the last # entered in a
column.

Thanks for the help.