Excel怎样去掉重复姓名的同时保留最高成绩答:C2=IF(A1=A2,"",MAX(C$1:C1)+1)向下复制 E2=IF(ISERROR(VLOOKUP(ROW(A1),IF({1,0},$C$2:$C$14,$A$2:$A$14),2,)),"",VLOOKUP(ROW(A1),IF({1,0},$C$2:$C$14,$A$2:$A$14),2,))向下复制 F2=MAX(($A$2:$A$14=E2)*$B$2:$B$14)向下复制,数组公式公式...
excel中同一列中相同数字的上下相邻数字如何筛选出来并统计重复数_百度...答:如下图,在C3中输入公式 =INDEX($B:$B,SMALL(IF($B$2:$B$18=$B3,ROW($2:$18)+IF(COLUMN(A1)<=COUNTIF($B:$B,$B3),1,-1),999),IF(COLUMN(A1)<=COUNTIF($B:$B,$B3),COLUMN(A1),COLUMN(A1)-COUNTIF($B:$B,$B3)))按【组合键】确认后右拖、下拉填充。