last data entry in column
 

I have a column of numbers follow by two blank rows then a calculation
using the last entry in the column.

How do I reference the last data entry?

When I insert a new row and copy the formulas the formula below the
blank rows doe not adjust.

Thanks in advance.

CW

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

--
Regards
Frank Kabel
Frankfurt, Germany


CHW wrote:
I have a column of numbers follow by two blank rows then a
calculation
using the last entry in the column.

How do I reference the last data entry?

When I insert a new row and copy the formulas the formula below the
blank rows doe not adjust.

Thanks in advance.

CW