Separation of column based on cell value

Question

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

InputOutputYes AAABBBBYes-CCCDDD EEEYesYes Yes-YesYes YesYesYes YesYesYesYesYesAAABBB-

Please help me on this.

AngelosPachis · Accepted Answer

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