全部博文
-
编辑 删除
帮忙做的Excel公式
=IF(Sheet1!A1<>"",Sheet1!A1,LEFT(INDIRECT(ADDRESS(ROW()-1,COLUMN())),4))&"-"&TEXT(TODAY(),"yymm")&"-"&TEXT(IF(Sheet1!B1<>"",Sheet1!B1,RIGHT(INDIRECT(ADDRESS(ROW()-1,COLUMN())),4)),"000") ...
