IF Statement Table Help
1 Attachment(s)
Hello,
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. Thanks you so much for the help,and please feel free to commend or suggest any alternative ways. Thanks!! -Greg |
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 |
All times are GMT +1. The time now is 09:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com