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)
- Columns of versions are in ascending order yes. But MAX gives me the highest value in any of the versions, not necesarily the value of the latest version.
Later versions can have lower values in their cell than previous versions. I dont need the number of the version, I need the value of that. Ersion of the report. The score if you want.- Did you try the second suggestion using Lookup?
JMB17 yes, still shows the MAX,not the value of the latest version
