IF Statement Table Help

[arceaf]

Hello,

I am trying to create a function that will allow me to identify th
start and end date of a particular project. The file is attached bellow
Each project contains a time line marked by 1s. I am looking for
formula that will allow me to determine the start and end date of eac
project based on these 1s. A "1" indicates the project is being worke
on. When there are no ones, then the project is either complete o
hasn't started. There's an example on the first row in the fil
attached.

Thanks you so much for the help,and please feel free to commend o
suggest any alternative ways.

Thanks!!

-Gre

+-------------------------------------------------------------------
|Filename: Capture.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=883
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Wed, 12 Jun 2013 22:56:08 +0100 schrieb arceaf:

I am trying to create a function that will allow me to identify the
start and end date of a particular project. The file is attached bellow.
Each project contains a time line marked by 1s. I am looking for a
formula that will allow me to determine the start and end date of each
project based on these 1s. A "1" indicates the project is being worked
on. When there are no ones, then the project is either complete or
hasn't started. There's an example on the first row in the file
attached.

for Start Date in B2:
=MIN(IF(D2:L2=1,$D$1:$L$1))
for End Date in C2:
=MAX(IF(D2:L2=1,$D$1:$L$1))
and enter both array formulas with CTRL+Shift+Enter


Regards
Claus Busch