Get last non-empty cell value in a spreadsheet

by Christian Fei @ 2019-04-07

50 words, 1 minute reading time

#post #tutorial 

this

Let's say your values are in the range B2:B.

To get the last value of all non-empty cells in that range, use the following formula:

=INDEX(B2:B,COUNTA(B2:B))

Where:

Based on this article for Microsoft Excel

this

Leave a comment

Better web scraping with node.js My blogging stack in 2020 Run cypress integration tests with github actions workflow Simple telegram message with github actions Deploy eleventy site with github actions on aws s3 Simple ad and trackers blocking with dns Build for a slow connection Upgrade mongodb 3 to 4 on ubuntu Publishing org scoped npm packages with travis A story about npm publish / unpublish