Yesterday I asked for help to show all projects on a contract that were 95% or more completed even in one of the projects did not fall within that range. I got a great solution from p45cal but now my boss wants something different.
I have a list of contract numbers (J2:J732), some of which are duplicated because the contract contains multiple projects. In another column I have a list of percentages (O2:O732). These percentages reflect the amount of work that has been completed.
I need to show projects that are 95% or more completed but only if all the projects with the same contract number are also 95% or more completed. This could be shown as true/false.
I appreciate your help.
I have a list of contract numbers (J2:J732), some of which are duplicated because the contract contains multiple projects. In another column I have a list of percentages (O2:O732). These percentages reflect the amount of work that has been completed.
I need to show projects that are 95% or more completed but only if all the projects with the same contract number are also 95% or more completed. This could be shown as true/false.
I appreciate your help.