Finding most recently entered number within a column
 

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.

Finding most recently entered number within a column
 

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.

Finding most recently entered number within a column
 

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.

--
Biff
Microsoft Excel MVP


"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.

Finding most recently entered number within a column
 

Hi,

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

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"The Stoat" wrote:

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.