Ive beentrying to write a function that retunrs the last none empty value in a column. note that some cells in same column will be empty. From the manual, the recommended function is =INDEX(A2:A30,MAX(ROW(A2:A30)×(A2:A30 《》""))). This assumes the range from A2 to A30 for example. However I try the function does not work. Any suggestion or help on this ?