formula to find last payment in year

[Pizzio]

I'm sorry by html post isn't working. what i'm looking for is a formula that can identify the last month a payment was processed, As you can see item 1 has a skipped payment in april but continues with payments beyond that but item two has stopped payments in Mar. Once the formula identifies the last month with a payment i need it to populate the payment as if it were continuous in another spreadsheet. See below as an example.


Data
Item Jan Feb Mar Apr May
1 $50 $50 $0 $50 $50
2 $30 $30 $0 $0 $0


Formula data
Item Jan Feb Mar Apr May
1
2 $30 $30 $30

 

[Pizzio]

Here is a better example. as you can see item 1 skipped a payment in february but was not the last payment made in the year where the following month was $0.00 but item 2 did have such an example. So what i need is for the formula to populate on a separate spreadsheet $10.00 in Mar going forward. Any ideas?

Book1
	A	B	C	D	E
1		Jan	Feb	Mar	April
2	1	$50.00	$-	$50.00	$50.00
3	2	$10.00	$10.00	$-	$-
Sheet1