christian at agile venture bolzano 2019 christian fei's blog

agile developer, clean code connoisseur && testing aficionado

read more about me

scroll through posts that i wrote

follow me on twitter and github

Get last non-empty cell value in a spreadsheet

written on 2019-04-07 by Christian Fei

#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