Display last and second last values from populated cells in a column. Say A1:A10 with

This could apply where it is required to generate the number of hours of work in each of the last two working weeks in a 10 week period. Not all 10 weeks will have hours; some will be blank. The formula should remain true in another 10 week period with different weeks being blank. What are the formulas to display the results in A11 and A12?

Your post is hard to follow - I'm afraid - could you post an example ?

Finding the last value is straightforward enough

=LOOKUP(9.99999999999999E+307,A1:A10)

The approach for finding the penultimate value will vary based on specifics of the file... of which we know little.

=LOOKUP(9.99999999999999E+307,A1:INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10)-1))

If range is A1:A8

Then Last value:

=LOOKUP(9.9999999E+307,$A$1:$A$8)

2nd last:

=LOOKUP(9.9999999E+307,A1:INDEX($A$1:$A$8,MATCH(9.9999999E+307,$A$1:$A$8)-1),$A$1:$A$8)

The formulae provided should do what you want just place that for last value in A12 and the penultimate in A11.