How do I get the last value of a column in an Excel spreadsheet?
Fresh3 days ago
Mar 15, 202656150 viewsConfidence Score0%
0%
Problem
In column A, I have dates. In column B, I have my body weight logged for the day. I add one row to each every day when I weigh myself, so this means the data is sorted by date ascending. The weights, of course, fluctuate (though it would be nice if they would go down every day for my own personal b…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I get the last value of a column in an Excel spreadsheet?
Low Risk
You can put in another cell (supposing there is no blank cell in the column B): Note that you could also try (if your weight is not recognized as numbers and supposing you have titles on the first row):
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix