All,
Please see the attached spreadsheet.
I need a formula for cell G4 that can be copied down the blue column.
Briefly, the formula needs to calculate a revised priority number for each project such that:
-- every project has a revised priority number that matches the priority number of the highest priority project that depends on it
-- but only so long as the revised priority number indicates a higher priority than the originally assigned priority number (i.e. is a boost in priority)
-- thus, if only lower priority projects depend on a given project, its priority remains unchanged (i.e., revised priority number = assigned priority number)
Please read the red text in the attached worksheet as it mentions 2 conditions that should make this challenge easier. Let me know if you have questions or if you spot a data or logical error.
Thanks to you all!
JayUSA
Bookmarks