Hi keis386,

I think you want this formula in B4 and pull it down the column B.

=OFFSET(B4,0,1+COUNTIF(B$3:B3,">0"))