请问=if(countif(a:a,b1)>0,"",b1) 和=if(countif(a:a,b1)>0,b1,"")

请问=if(countif(a:a,b1)>0,"",b1) 和=if(countif(a:a,b1)>0,b1,"") excel中,=IF(COUNTIF(A:A,B1)>0,B1, =IF(COUNTIF($A$1:$A$22,B1) =IF(COUNTIF($A$1:$B$21,B1)>1,"重复","") EXCEL公式解读:B2=INDEX(A:A,MIN(IF(COUNTIF(B$1:B1,A$1:A$1000)=0,R =MATCH(0,COUNTIF($B$1:B1,$A$2:$A$15),)数组公式, EXCEL里的公式 =IF(COUNTIF(A:B,B1)>1,B1,"") 是什么意思,请直接汉语翻译出来,越详细越好 求高手挑错=IF(countif(MID(B1:B5,1,LEN(B1:B5)-8),A1)>0,A1,"") B2=INDEX($A$2:$A$100,MATCH(,COUNTIF($B$1:B1,$A$2:$A$100),))& =countif(B:B,B1)是什么意思?B1 B1呢? 如何理解=LOOKUP(1,0/NOT(COUNTIF($b$1:$b1,sheet1!$a$1:$a$200)),sh =IF(ISERROR(SUMPRODUCT(1/(COUNTIF(B1:F1,B1:F1)-3))),"相同","")