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 Bypas Nil Values

A formula delivers a result 0 or 1 in certain conditions in 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?