试着把单词放在单词COMPLETE之后

Question

我在附表中有数据，我试图将这一行放在单词COMPLETE之后，但我的公式将该行放在COMPLETE之前。你对这个问题的帮助将不胜感激。

https://docs.google.com/spreadsheets/d/1jd7AVAvHwfznW_tpykhJb58cPvE7BLxtnJCq9fZy0WE/edit?usp=sharing

=ARRAYFORMULA(IF(A2:A9=B2:B9, REGEXREPLACE(A2:A9, "(COMPLETE)", "(No Measure Applicable) $1"), B2:B9))

Answer 1

看看这是否有帮助？

=ARRAYFORMULA(IF(A2:A9=B2:B9, REGEXREPLACE(A2:A9, "(COMPLETE)",  "$1 (No Measure Applicable)"), B2:B9))