View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a m spock a m spock is offline
external usenet poster
 
Posts: 50
Default in a columnGet to first positive value

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?