Formula for reference last non empty cell in row
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.
|