B2 D E列公式設定99行 預留空白=LOOKUP(1,0/MMULT(1-ISERR(0/(FIND(TRIM(MID(SUBSTITUTE(D$2:D$99,",",REPT(" ",99)),{1,2,3}*99-98,99)),"@"&A2)>1)),{1;1;1}),E$2:E$99)
D E列無法預留空白=LOOKUP(1,0/MMULT(1-ISERR(FIND(TEXT({1,-1,0}%,SUBSTITUTE(D$2:D$11,",",";")),A2)),{1;1;1}),E$2:E$11)
留言
張貼留言