Is there an easy way to reference the bottom row of column if there are gaps in the data?
We are after a way to return the most recent/bottom entry of a column, however the column will often have gaps of blanks.
I have got sort of close with:
=INDEX(Change:Change, COUNTIFS(Change:Change, <>""))
However any gaps you have make it look at the cell(s) above the bottom.
Is there a way to get a IF NOT BLANK type function to COUNTIFS that would allow the formula handle the blanks in the column?
Help Article Resources
Check out the Formula Handbook template!