Finding most recently entered number within a column

[The Stoat]

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.

 

[Rick Rothstein]

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.

 

[T. Valko]

In other words, you want to return the *last* number entered in a vertical
list?

Try this:

=LOOKUP(1E100,A:A)

That will return the *last* numeric value entered in cloumn A.

 

[Shane Devenshire]

Hi,

You really should show us the formula you currently have. But in lue of that

=YourFormula(LOOKUP(9^9,A:A))