I have a list of non-unique values in Plays!E2:E73. I'm able to get a list of unique values with this formula:
{=IFERROR(INDEX(Plays!$E$2:$E$73,MATCH(0,COUNTIF($A$45:A45,Plays!$E$2:$E$73),0)),"")}
However, I'd like to put a conditional on them that says Plays:I of that particular row = Yes. I'd appreciate some help here.

Thanks!