hello -
I need some help in getting the start date and end date in the entire duration project allocation using a formula or function. I've attached a sample for your reference.
hello -
I need some help in getting the start date and end date in the entire duration project allocation using a formula or function. I've attached a sample for your reference.
why F5 is 02-Feb even-though V3=5
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Good point, please ignore the 5 in V3. Ideally, allocation for Base contract is until Feb 2 (friday)
Try the following array entered formulas*.
In E5: =MIN(IF((I$3:I$20=B5)*(J$3:J$20=C5)*(K$3:K$20=D5)*(M$3:V$20>0),M$2:V$2))
In F5: =MAX(IF((I$3:I$20=B5)*(J$3:J$20=C5)*(K$3:K$20=D5)*(M$3:V$20>0),M$2:V$2))+4
1) Select the cell in which you want to put the first formula (E5),
2) Paste the formula into the formula bar,
3) *Simultaneously press the Ctrl, Shift and Enter keys,
4) Drag the fill handle down.
Repeat these steps for the second formula.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks