christian fei's blog

agile developer

clean code connoisseur && testing aficionado

read more about me or what i am doing now

read some posts that i wrote

follow me on twitter and connect with me on linkedin

distilling customer feedback at wonderflow

Edit this page on GitHub

Get last non-empty cell value in a spreadsheet

written on Sun Apr 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)

by Christian Fei

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