need a formula

[dennis.mccarthy]

I have a worksheet that I am using to schedule capacity in our
workshop. It has a serious of columns representing each week.
There will be data in one of the 52 colums. I am looking for a
formula that will return a value (the week number) in the first row of
the column that has data in it.

Ex:

Week 40 41 42 43

Hours job1 0 0 5 0

the formula would return week 42


Thanks in advance.

 

[Don Guillett]

If 0's in the intervening columns
=MATCH(1,26:26,1)
if blanks
=MATCH(1,26:26,-1)

 

[Don Guillett]

Use this instead. ARRAY entered using ctrl+shift+enter
=MATCH(MIN(IF(A26:$IV26>0,A26:$IV26)),26:26)