Forum Discussion
XLOOKUP last non-empty cell in a table column
Hi all, This is my first time posting here. I'm trying to return the last non-empty value of a specific column of a table to another sheet but it keeps returning the error "This formula is missing...
It works for me.
Alternatively:
=LOOKUP(9^99,TblData[Running Total])
=INDEX(TblData[Running Total],COUNT(TblData[Running Total]))