Remove the column '$' lock, apply it for row only. Do (in column A) : =IF(ISBLANK(A$7),,REGEXMATCH(A$10,$A7)). Then copy & paste to column B ...
確定! 回上一頁