How to find the first element at the array witch is more than zero

[Jiurasic]

Hello to all!
A have an array of data (one row)…. I want to find the first element at this array witch is more than zero, and get it’s number of column.

Can I received it without any macros, only with Excel formulas?

 

[onlyadrafter]

Hello,

is this giving expected results?

=INDEX(1:1,0,MATCH(0,1:1,1)+1)

will return the value

=MATCH(0,1:1,1)+1

will return the column number.

where your data is in Row 1.