多字C2:G9=REPT(1,IFERROR(LOOKUP(1,0/MMULT(1-ISERR(0/(FIND(TRIM(MID(SUBSTITUTE($J$2:$J$5,",",REPT(" ",99)),{1,2,3,4,5}*99-98,99)),"@"&$B2)-1)),{1;1;1;1;1}),ROW($1:$5)),5)=COLUMN(A1))
單字母C2:G9{=REPT(1,IFERROR(LOOKUP(1,0/FIND(MID($B2,MATCH(1=1,ISERR(-MID($B2,ROW($1:$9),1)),),1),$J$2:$J$5),ROW($1:$4)),5)=COLUMN(A1))
留言
張貼留言