In iWork Numbers (v3.5.2) I would like to display the last value (not int or bool) from a row. I have an image of what I'm looking to do below.
In row 1 I have the Current pulling the value from the latest value, in this case the B under Spring. If possible I would like to be able to leave empty columns at the end of the row and have the Current only update if there's new data.
Is this possible?