How to use last entry in a column in a formula. I have a spreadsheet for tracking
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Related Book For
Posted Date: