=INDEX(L1:L20,MIN(IF(L1:L200,ROW(L1:L20))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"a m spock" wrote in message
...
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?