Formula
opts = [ "Signed by CEO" "Signed by Director" "Signed by Managing Director" "Signed by Chairman" ] if [m1].flat().filter( (v) -> opts.includes v).length "Yes" else "No"
opts = [ "Signed by CEO" "Signed by Director" "Signed by Managing Director" "Signed by Chairman" ] if [m1].flat().filter( (v) -> opts.includes v).length "Yes" else "No"