How to use last entry in a column in a formula.

I have a spreadsheet for tracking a stock my wife has. I use the simple formula =B63-B5 (B63 the current value and B5 the starting value) with the result of total loss or gain shown in cell F5. Next month I will have to manually change cell B63 in the formula to B64 to reflect the current value of the stock and so on every month. How can I use a formula to cover the last entry in column B so I don't have to manually change it every month?

Answer rating: 100% (QA)

Use fol... View the full answer