L
Lamb Chop
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
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