Hi All,
I have implemented a logic to fetch the last value in a set of data(from a set of columns) by a formula like =LOOKUP(900000000000,'Sheet 1'!N1:Z1).
So with this formula I am able to fetch the last value populated in Sheet 1 from the columns N until Z.
If columns X, Y and Z are not filled then this formula fetches the value from column W. And so on.
The issue is that I want to do the same thing in MS Project. So all you excel experts, please help me.
Regards.
I have implemented a logic to fetch the last value in a set of data(from a set of columns) by a formula like =LOOKUP(900000000000,'Sheet 1'!N1:Z1).
So with this formula I am able to fetch the last value populated in Sheet 1 from the columns N until Z.
If columns X, Y and Z are not filled then this formula fetches the value from column W. And so on.
The issue is that I want to do the same thing in MS Project. So all you excel experts, please help me.
Regards.
