A列有重复值,B列也有重复值,如何筛选出同时满足AB两列相同重复值?答:=INDEX(A:A,SMALL(IF((COUNTIF(A:A,$A$2:$A$100)>=2)*(COUNTIF(B:B,$A$2:$A$100)>=2)*(COUNTIF(D$1:D1,$A$2:$A$100)=0),ROW($2:$100),4^8),ROW(A1)))&""数组公式,先按住CTRL+SHIFT,最后回车 公式下拉
matlab中,数组x=[1,4,6,7,2,3,5,3,5],怎样筛选出出现的元素,使x=[1...答:用unique函数:>> x=[1,4,6,7,2,3,5,3,5]x = 1 4 6 7 2 3 5 3 5>> x=unique(x)x = 1 2 3 4 5 6 7