Referencing the latest entry in a column
 

I want to reference the latest entry in a column. So that every time the
column is updated, and subsequently has another cell added to it, I don't
have to update the formula for referencing it.

Referencing the latest entry in a column
 

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

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

I want to reference the latest entry in a column. So that every time the
column is updated, and subsequently has another cell added to it, I don't
have to update the formula for referencing it.

Referencing the latest entry in a column
 

Hi,

Suppose the data is in range F11:F17. In cell F10, give a heading, say
dummy. Now select F10:F17 and convert it to a List (Ctrl+L). Then try this
formula

If the column has numeric data =LOOKUP(99^99,F11:F17)
If the column has non-numeric data =LOOKUP(REPT("z",99),F11:F17)

As you keep adding data to the range I.e. row 18 onwards, the range in the
lookup formula will keep expanding

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"John" wrote in message
...
I want to reference the latest entry in a column. So that every time the
column is updated, and subsequently has another cell added to it, I don't
have to update the formula for referencing it.