in a columnGet to first positive value

[a m spock]

A formula delivers a result 0 or 1 in certain conditions in all the cells in
a coluumn.

I need to start scanning from row 1 to bypass the initial 0 value cells to
reach the first positive value in the column.

How do I do it?

 

[Don Guillett]

=INDEX(L1:L20,MIN(IF(L1:L20>0,ROW(L1:L20))))

 

[Don Guillett]

Dont forget to array enter using ctrl+shift +enter