对位显示中错求函数公式。冬至快乐，谢谢大家

azsxd

zwzc

=IFNA(LOOKUP(1,0/(MID(E1,{1,2,3},1)=MID(F1,{1,2,3},1)),{"中","中","中"}),"错")

丢丢表格

=IF(SEARCH(SUBSTITUTE(F1,"*","?"),E1&F1)=1,"中","错")

azsxd

zwzc 发表于 2024-12-22 18:58
=IFNA(LOOKUP(1,0/(MID(E1,{1,2,3},1)=MID(F1,{1,2,3},1)),{"中","中","中"}),"错")

谢谢。。。。冬至快乐

azsxd

丢丢表格 发表于 2024-12-22 19:01
=IF(SEARCH(SUBSTITUTE(F1,"*","?"),E1&F1)=1,"中","错")

zwzc 发表于 2024-12-22 18:58
=IFNA(LOOKUP(1,0/(MID(E1,{1,2,3},1)=MID(F1,{1,2,3},1)),{"中","中","中"}),"错")

谢谢。。。。冬至快乐

xxy1721

IF(SUMPRODUCT((REGEXP(F1,".")=REGEXP(E1,"."))*1)>0,"中","错")

leepoison

=IF(OR(REGEXP(E1,".")=REGEXP(F1,".")),"中","错")

我走我流

=IF(COUNT(SEARCH(REPLACE("???",{1,2,3},1,MID(E1,{1,2,3},1)),F1)),"中","错")

mykitami

=IF(OR(MID(E1,ROW($1:$3),1)=MID(F1,ROW($1:$3),1)),"中","错")

无关岁月

1. =IF(REGEXP(E1,REGEXP(F1,"\*",2,"."),1),"中","错")

复制代码