Hi all,
I hope you are all well and safe.
I am trying to get a formula that returns the value of the last non-empty cell of a row.
I am currently using the following formula which returns the last value of the last cell of the row but not the value of the last non-empty cell:
=IFERROR(LOOKUP(2,1/(A1:F1<>""), A1:F1), "")
Your help is much appreciated!
Bookmarks