Find Min Date of Results

[brianmock]

I am trying to calculate the min date of available results
Row 1 has possible dates
Row 65 has possible results
Col A has headings

1 A B C D E
11/1/13 12/1/13 1/1/14 2/1/14
:
:
65 - - .25 .35

Row 65 has an IFERROR( calculation, "-") so the first possiblle result is Jan 2014

I cannot make a combination of Min, sumproduct, and isnumber work
I cannot make a combination of Index, Match, and isnumber work
Suggestions

 

[Jake Collins]

Dear brianmock

INDEX(Dates,1,MATCH(1,ISNUMBER(Results)*1,0))

where dates is a named range referring to the dates in row 1 and results in a named range referring to the results in row 65 seems to work.

 

[brianmock]

I was trying to use -- ISNUMBER(results) instead of ISNUMBER(results)*1 does same thing

I was not entering it an an array formula, which is the error
Thank You