Dear all,



Kindly help me to create a formula for reference last non empty cell in row.
I have attached a LOG file and there is a column named CURRENT STATUS, here the current status of documents should be the latest status of document in the same row.
I want to do it by creating a formula so that this field will be updated automatically according the last cell. There are two fields: Current Status and Status date- I want both field to be updated using excel formula.
Kind check in the attached file.

Now I am updating CURRENT STATUS field manually but it is annoying while updating to many documents.

I highly appreciate you time and help.

Thank you very much.

Attached Files

LOG 2.xlsx (139.7 KB, 13 views)