B2=INDEX($A$2:$A$100,MATCH(,COUNTIF($B$1:B1,$A$2:$A$100),))&

B2=INDEX($A$2:$A$100,MATCH(,COUNTIF($B$1:B1,$A$2:$A$100),))& ={INDEX(A$2:A$100,MATCH(0,COUNTIF(G$1:G1,A$2:A$100),))&""} 看 =MATCH(0,COUNTIF($B$1:B1,$A$2:$A$15),)数组公式, execl 能不能给我说说.=IFERROR(INDEX($A$2:$A$66,MATCH(0,COUNTIF($B$1 EXCEL公式解读:B2=INDEX(A:A,MIN(IF(COUNTIF(B$1:B1,A$1:A$1000)=0,R =INDEX(商品进货!A:A,MATCH(0,COUNTIF(O$2:O36,商品进货!$A$2:$A$49),)+1 excel 函数翻译B2=IF(COUNTIF($A$2:$A$100,A2)>1,A2,"") 求解此数组函数表达的函义 {=INDEX(A:A,MATCH(0,COUNTIF(N$2:N2,$A$2:$A$50), 在C2输入公式=INDEX(A:A,MIN(IF(COUNTIF(C$1:C1,A$2:A$100)=0,ROW($2: =IF(COUNTIF($A$1:$B$21,B1)>1,"重复","") 有个数组公式：countif（B$1:B1,$A$2:$A$13), =IF(COUNTIF($A$1:$A$22,B1)