I have an excel spreadsheet that shows days ahead of behind schedule for a project. I want my last cell in each row (F3) to be automatically updated based on the most recent (last) ahead/behind data.
For example in Job 1, the following fields are populated:
A3 = -15
B3 = -10
C3 = 15
D3 = Blank
E3 = Blank
In this example F3 should contain 15.
Job 2 has the following fields populated:
A4 = -12
B4 = -5
C4 = -15
D4 = -8
E4 = -6
In this example F3 should contain -6.
Basically, I need F# to contain the value in the cell the furthest to the right, if it is not blank. Any help would be greatly appreciated.
For example in Job 1, the following fields are populated:
A3 = -15
B3 = -10
C3 = 15
D3 = Blank
E3 = Blank
In this example F3 should contain 15.
Job 2 has the following fields populated:
A4 = -12
B4 = -5
C4 = -15
D4 = -8
E4 = -6
In this example F3 should contain -6.
Basically, I need F# to contain the value in the cell the furthest to the right, if it is not blank. Any help would be greatly appreciated.