Hi All,
I have been racking my brain on this one and I can't seem to work out a way around it, so I thought I would put it to a wider audience.
I have a 'Project Schedule' workbook in Excel 365 where you can have 3 types of groups. Stage, Task and Milestone. Each Stage needs to be able to work out the minimum start date out of all the Tasks and Milestones in that stage with a varying number of tasks in each stage. Normally this would be simple enough, but all the stages are stacked so you can't simply just put a min function for the column. There also isn't a unique ID for each stage (unless it is the only way around the problem) to be able to work it out. I was trying to work out if there was a way to say 'get the min value between this row and the next row that has 'Stage' in column C'
I have attached a screenshot of the file but I'm not able to upload the file as it has sensitive information within it. The cells I'm trying to populate with the formula are in column F on each of the 'Stage' rows and they only look at the rows between the current row and the next 'Stage' row.
Hopefully this makes sense and I can get some suggestions on how to try and solve it.
Thank you in advance
Jon
I have been racking my brain on this one and I can't seem to work out a way around it, so I thought I would put it to a wider audience.
I have a 'Project Schedule' workbook in Excel 365 where you can have 3 types of groups. Stage, Task and Milestone. Each Stage needs to be able to work out the minimum start date out of all the Tasks and Milestones in that stage with a varying number of tasks in each stage. Normally this would be simple enough, but all the stages are stacked so you can't simply just put a min function for the column. There also isn't a unique ID for each stage (unless it is the only way around the problem) to be able to work it out. I was trying to work out if there was a way to say 'get the min value between this row and the next row that has 'Stage' in column C'
I have attached a screenshot of the file but I'm not able to upload the file as it has sensitive information within it. The cells I'm trying to populate with the formula are in column F on each of the 'Stage' rows and they only look at the rows between the current row and the next 'Stage' row.
Hopefully this makes sense and I can get some suggestions on how to try and solve it.
Thank you in advance
Jon