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.
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
Hi guydegrieck
Your formula worked for something that i'm working in
But i just want to know what do number 2 and number 1 divided by range of cells mean?
why number 2?
why number 1 divided by range of cells?
this is something that i didn´t get
LOOKUP(2,1/($E3:$AI3<>0),$E3:$AI3),0)