Separation of column based on cell value

[Gsiva3]

Hi Team I have values in column A as mentioned below. My requirement I want output of the cells that contains only "Yes"

Input	Output
Yes AAABBBBYes	-
CCCDDD EEEYesYes Yes	-
YesYes Yes	Yes
Yes Yes	Yes
Yes	Yes
YesAAABBB	-

Please help me on this.

[AngelosPachis · Accepted solution]

Hey @Gsiva3 ,

You can use a regex match function in a formula tool to check if the only value there is Yes (and maybe a whitespace)

Hope that helps,

Angelos

[Gsiva3]

@AngelosPachis 

Thank you so much Angelos!!!

It working fine!!!