Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|