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
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?
Step by Step Solution
3.56 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
Use fol...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Marketing Mistakes And Successes
Authors: James F. Dartley
11th Edition
978-0470169810, 0470169818
