日期不同 加字符行 (9347)


C3=IFERROR(IF(ISNUMBER(FIND("汇总",C2))+(ROW(A1)=1),TEXT(N(OFFSET(A$2,ROW(A1)-COUNTIF(C$2:C2,"*汇总"),)),"YYY/M/D;;"),TEXT(C2*1,"YYY/M/D")&IF(OFFSET(A$2,ROW(A1)-COUNTIF(C$2:C2,"*汇总"),)-C2=0,""," 汇总")),"")


留言