View Single Post
  #1   Report Post  
ExcelMonkey
 
Posts: n/a
Default First Occurence of Non Blank Cell in row array

I have an array of yearly dates in A2:A20. I then have
an array below it B2:B20 that the user can enter costs
into. I want to be able to identify the year that the
first cost appears in. The cells that do not have
numbers will be left blank. How do I do this? I know I
can count the occurences of cells with data:

Sumproduct(--(B2:B200))

But how do I identify which column or year the first of
these occurs in?

Thanks