Your question is not as clear as I would like. Are you looking for the value
in the last filled cell in a particular column? If so, try this formula...

=LOOKUP(2,1/(A1:A65535<""),A:A)

where you would change all the A's to whatever column designation you want
to work in.

--
Rick (MVP - Excel)


"The Stoat" wrote in message
...
Hi,

Does anyone know how to find the most recently entered number within a
column and apply to a calculation?

I have a spreadsheet that has an extra row added every week, so the most
recently added figures are not in the same cells for the formula.

Another way would be to find the lowest visual number (as opposed to
lowest
numerically) within a column.

Hope this makes sense!

Thanks for any help,

Matt.