Get last non blanc value of another row

[MrMaster]

Hi,

My sheet has values in column B (these are 'towage', 'mob', 'demob', 'coaster' + a few others). The colums next to this contain other info. Not every row however has a value in this column

In column C I wish to have the last non bank value mentioned from column B. In my example this would lead to C2 and C3 to mention 'Sleep', C4 and C5 'Sleep' as well, C6 'Mob, and so on.

How do I set this up?

Thanks in advance.

Best regards,

[Fluff13]

How about
In C2 copied down
=IF(B2<>"",B2,C1)

[MrMaster]

Ashamed. ASHAMED I tell you i am. Yes indeed, it was as simple as that. Thanks Fluff. :-)

[Fluff13]

You're welcome & thanks for the feedback.