need a formula
 

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.

need a formula
 

If 0's in the intervening columns
=MATCH(1,26:26,1)
if blanks
=MATCH(1,26:26,-1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
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.

need a formula
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
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.