相邻相同数 往上 (11169)


重复的计算一个 E2=IF(ROW(A1)<B$2,"",SUMPRODUCT((COUNTIF(OFFSET(D2,,,-B$2),OFFSET(D2,,,-B$2))>1)*(MATCH(OFFSET(D2,,,-B$2),OFFSET(D2,,,-B$2),)=ROW(INDIRECT("1:"&B$2)))))


留言