IF Statement Table Help
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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|