I have a column (A:A) and some cells are empty. In B1, I would like to get
the value of the 2nd last value in column A.

e.g. example 1

A1 = 434
A2 = 4343
A3= <empty
A4 = 11
A5 = <empty
A6= <empty
A7 = 343
A8 = 43

In B1, I want it to be 343 (A7)

example 2

A1 = 434
A2 = 4343
A3= <empty
A4 = 11
A5 = <empty
A6= <empty
A7 = <empty
A8 = 43

In B1, I want it to be 11 (A4)


Thanks.

Man