Sorry, that was a typo.. for Str3, the result should be 3 and not 2.If the result for Str3 is correct then =COUNTIF(B2:F2,">0")
Dear Jason, this is amazing... both solutions are working as desired.In that case try one of
Excel Formula:=MATCH(2,INDEX(1/(B2:F2>0),0))
Excel Formula:=LOOKUP(2,1/(B2:F2>0),B$1:F$1)