Finding most recently entered number within a column

  • Thread starter Thread starter The Stoat
  • Start date Start date
T

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.
 
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.
 
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.
 
Hi,

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

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