So strange. I use a spreadsheet that is updated monthly. I use the following formula to find the value of the last cell with data in a row.
All the sudden, it returns nothing. (data is still there in the rows) What could have gone wrong?
=LOOKUP(1,1/(A10:Z10<>""),A10:Z10)
Thanks,
Oscar