D2{=MID(B2,MATCH(,0/MMULT(N(COUNTIF(B2:B6,"*"&MID(B2,ROW(1:9),COLUMN(A:I))&"*")*(MID(B2,ROW(1:9),COLUMN(A:I))<>"")=5),ROW(1:9)^0),),MIN(MMULT(1-ISERR(FIND(MID(B2,MATCH(,0/MMULT(N(COUNTIF(B2:B6,"*"&MID(B2,ROW(1:9),COLUMN(A:I))&"*")*(MID(B2,ROW(1:9),COLUMN(A:I))<>"")=5),ROW(1:9)^0),),COLUMN(A:I)),B2:B6)),ROW(1:9)^0)))
留言
張貼留言