大师作文网SUMPRODUCT((B$1:B$100>B1)*(1/COUNTIF($B$1:$B$100,$B$1:$B$100
SUMPRODUCT((B$1:B$100>B1)*(1/COUNTIF($B$1:$B$100,$B$1:$B$100
=SUMPRODUCT(($B$3:$B$8>$B3)/COUNTIF($B$3:$B$8,$B$3:$B$8))+1
excel中=COUNTIF($B:$B,B1)>1
B2=INDEX($A$2:$A$100,MATCH(,COUNTIF($B$1:B1,$A$2:$A$100),))&
=IF(COUNTIF($A$1:$B$21,B1)>1,"重复","")
Excel公式countif($B$1:B1,$B$1是指什么?
=countif(B:B,B1)是什么意思?B1 B1呢?
=IF(COUNTIF(b:b,b1&"*")>1,"重复","唯一") 这个筛选B拦的公式是否正确
excel =IF(ROW(B1)>COUNTIF(B:B,L$1),"",L$1)=INDEX(C:C,SMALL(I
有个数组公式：countif（B$1:B1,$A$2:$A$13),
=MATCH(0,COUNTIF($B$1:B1,$A$2:$A$15),)数组公式,
D2中输入 =IF(COUNTIF($B$2:B2,B2)=1,SUMPRODUCT((B2:B999=B2)*C2:C