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:
Post a Comment