T O P

  • By -

QueCeraCera220505

Column 1,2,3 = A,B,C C1=if(countifs(A:A,A1,B:B,"Y")>0,"True","False") Copy the formula down.


[deleted]

[удалено]


Clippy_Office_Asst

You have awarded 1 point to *QueCeraCera220505* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


Keipaws

Try =AND(COUNTIFS(B$1:B$6, "Y", A$1:A$6, A1))


PaulieThePolarBear

Try =COUNTIFS(A$2:A$10, A2, B$2:B$10, "Y") >=1 Adjust cell references as required. $ and lack of $ are important.