如何用简称判断出原来的医院名单

leepoison

=@LET(a,BYROW(1*ISNUMBER(REDUCE("",REGEXP(B2,"."),LAMBDA(x,y,HSTACK(x,HSTACK(FIND(y,$B$2:$B$10)))))),SUM)+LEN($B$2:$B$10)/100,FILTER($B$2:$B$10,a=MAX(a)))

hxj119

1. =LET(a,B2:B10,MAP(a,LAMBDA(k,REDUCE("",FILTER(a,a<>k),LAMBDA(x,y,LET(res,REDUCE(1,REGEXP(k,"."),LAMBDA(m,n,m*REGEXP(y,n,1))),IF(res,y,x)))))))

复制代码