Total Pageviews

2019/07/13

[Google Sheet] How to get the last non-empty value from a row?

Scenario
I have a history data regarding selling quantity from January to May.
Assume the latest data is April, how do I get the last non-empty value from a row?



How-To
We can use index and counta function to fulfill this requirement.
counta is used to get the index value of non-empty cell index.
Then pass the value which get from counta to index function to get the last value.




No comments: