The find last non empty cell function does not work because they are actually "" not really blank
LOOKUP(2,1/(1-ISBLANK(H13:H19)),H13:H19)
H13:H19 contains formulas that return ""
so how do make the above formula work to find the last non "" cell?
Bookmarks