[Closed -- moved to Commercial Services - feel free to look there]

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