If multiple criteria are met, then .. for all values based on 1 criteria

Hi,

I'm stuck on a formula which I hope is even possible to write without VBA.

Column A = my parameter, which is duplicated in multiple rows. So let's say I have 5 rows with "X", 4 rows with "Y" and 7 rows with "Z".
Column B = finished: Y/N
Column C = where the formula should come

If I take parameter "X" as example. In 3/5 rows finished is N and in 2/5 rows finished is Y.

I want my formula to do the following:

If Parameter = Parameter (so for all values with "X")
And at least 1 row has Finished = Yes
Then all cells in C have value = "Yes"

Any tips on how to achieve this?

Parameter Finished Desired Output
X Y Y
X Y Y
X N Y
X N Y
X N Y
Y Y Y
Y N Y
Y N Y
Y N Y
Z N N
Z N N
Z N N
Z N N
Z N N
Z N N
Z N N

Try

Formula:

Please Login or Register  to view this content.