Imagine:
Jan Feb Mar Apri May June July Aug Sep Oct Nov Dec
part 1 2 2.5 2.5 3 3.25
part 2 1 1.1
part 3 6 7 34

I'm looking for a seperate column that will list out the last value entered
in a series of colums: hense (part 1) = 3.25 (part two) = 1.1 (part 3) = 34.

In my attempt to find a formula I thought of something like
=lastvalue(b3:b15) but that's not a formula.

Does anyone have any suggestions? As usual thanks in advance.