D2=if ((a2=$a$1)*(b2=$b$1)*(c2=$c$1),"重复","")下拉
我没理解对你的意思,修改一下
D1=if(sumproduct((a2:a65536)=a1)*(b2:b65536=$b$1)*(c2:c65546=$c$1))>0,"重复","")
D2=if ((a2=$a$1)*(b2=$b$1)*(c2=$c$1),"重复","")下拉
我没理解对你的意思,修改一下
D1=if(sumproduct((a2:a65536)=a1)*(b2:b65536=$b$1)*(c2:c65546=$c$1))>0,"重复","")