Display last number.

[kc27315]

I'm attatching a spreadsheet to show what I'm trying to do. In column B from row 1 to row 26, I have formulas that are dependent on wether I type a "1" in the corresponding row of column A. If there's a "1" in column A of a row, then the corresponding row in column B displays a number, otherwise it displays the text "". I type in the number "1" starting in row 1 and proceeding downward.

What I want is for cell D1 to display the last number from column B. I currently have "=B13" typed into cell D1, so it displays 4.76. That does me no good though because if I type a 1 in A14, I want D1 to display "5.32".

Does anyone have any ideas on a function that will display the last number from rows 1 to 26 that is not text?

Thanks, kc