last data entry in column

C

CHW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Last value in column before blank 10
Copy last entry of column to bottom of column 3
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
help with formula for last input in column 6
Find the last number in a row 6
Go to cell below last entry in column and total 1
Last entry in a column/row function? 2

Top