Thread
:
need a formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett