I am using the following formula to return the value of the last entry in a range that is not blank.
=IF(AD14<>"",(INDEX(N14:AD14,MATCH(REPT("z",255),N14:AD14))),"")
However, it is not functioning as expected; it simply returns the value of the last cell in the range.
Solved by Z. S. in 24 mins