D3{=TRIM(MID(SUBSTITUTE(SUBSTITUTE(INDEX(B:B,MAX(ISNUMBER(FIND(","&ROW(A1)&",",SUBSTITUTE(SUBSTITUTE(B$3:B$7&",",":",","),";",",")))*ROW($3:$7))),":",";"),";",REPT(" ",99)),MAX(1,(SUM(ISNUMBER(FIND(","&ROW(A1)&",",SUBSTITUTE(TRIM(MID(SUBSTITUTE(B$3:B$7,";",REPT(" ",99)),COLUMN(A:I)*99-98,99)),":",",")&","))*COLUMN(A:I))-1)*198),99))
E3=IF(D3="","",ROW(A1))
F3=IF(D3="","",LOOKUP(1,0/FIND(D3,B$3:B$7),A$3:A$7))
留言
張貼留言