You can add the following formula to Column C: =ARRAYFORMULA(IF(A2:A9=B2:B9, REGEXREPLACE(A2:A9, "(\*+)$", "(No Measure Applicable) $1"), ...
確定! 回上一頁