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.
Solved! Go to 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