Finding start & end dates?

[haw]

C1 through Z1 contain dates: 9/1/05, 9/8/05, 9/15/05, etc.
C2 through Z10 contain numbers between 0 and 40 (or are empty)

I need a formula in B2 (that I can then copy down through B10) that will:
1) find the first cell containing a positive number in the range C2:Z2
2) return the value from the corresponding cell in row 1, above that cell.

If C1, D1, E1 = 9/1, 9/8, 9/15,
and C2, D2, E2 = 0, 10, 10
Then I need the result to be the value (date) 9/8.

I also need the same type of formula to find the date for the LAST cell containing a number.

 

[haw]

Very interesting!

I understand now that I must press CNTL-SHIFT-ENTER while EDITING the formula ... as opposed to simply pressing those keys while the desired cell is selected (but is not in edit mode). So now those other functions work, also! This is excellent! Thanks for all your help ...

Now I'm gonna have to spend some time studying those formulas, to see WHY they work! I haven't previously had occasion to use INDEX, MATCH, or Arrays within formulas.

Thanks again for the help.