字符最多相同的匹配 (13287)

B2{=INDEX(E:E,RIGHT(MAX(MMULT(1-ISERR(FIND(MID(D$2:D$6,COLUMN(A:I),1),A2)/(MID(D$2:D$6,COLUMN(A:I),1)<>"")),ROW(1:9)^0)/1%+ROW($2:$6)),2))



留言