如何让excel排除重复数据,并对结果计数,使数据起码连续2,或者不连续3...答:=INDEX(A:A,SMALL(IF((COUNTIF(B$2:B$20,A$2:A$118)=0)*(COUNTIF(C$2:C$20,A$2:A$118)=0)*(COUNTIF(D$2:D$20,A$2:A$118)=0)*(MATCH(A$2:A$118,A$2:A$118,0)=ROW($2:$118)-1),ROW($2:$118),4^8),ROW(A1)))将A列不为重复值且不包含BCD列的数据...