excel表格中如何找出连续出现3次的姓名
=AND(A2=A3,A2=A4,A2<>A5,A2<>A1)
=IFERROR(INDIRECT("A"&SMALL(IF($C$2:$C$23,ROW($C$2:$C$23)),ROW(A1))),"")
钱二连续出现4次,大于3次,不符合条件。
=FREQUENCY(MATCH($A$2:$A$23,$A$2:$A$23,0),MATCH($A$2:$A$23,$A$2:$A$23,0))
按三键回车,它返回的数值为零则是重复值,大于0的是它重复的次数,直接筛选大于3的即可
热门标签: