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.