用公式也是可以做到的,但是需要用到自定义名称:
len=ROW(INDIRECT("1:"&LEN(B2)))
mmult=MMULT(--ISNUMBER(FIND(TRANSPOSE(MID(B2,len,1)),Sheet1!A$2:A$6)),ROW(INDIRECT("1:"&LEN(B2))))
data=MMULT(LEN($A$2:$A$6)-LEN(SUBSTITUTE($A$2:$A$6,MID(B2,COLUMN(1:1),1),,1)),ROW($1:$256)^0)
C2公式:=LOOKUP(1,0/(data=MAX(data)),A$2:A$5)