Forum Discussion
Show value of last cell to the left that has a value
Column A has unique references of reports. Columns B to F show versions of those reports, version 1, version 2 etc...... in the cells of columns B to F is a number (4, 7, 2 etc) But not all report...
I would assume the version numbers are in ascending order? If so, then perhaps this is what you want?
=MAX(B2:F2)
If that is not the case, then maybe this?
=LOOKUP(MAX(B2:F2)+1,B2:F2)
=MAX(B2:F2)
If that is not the case, then maybe this?
=LOOKUP(MAX(B2:F2)+1,B2:F2)
