=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")
提问:上面这弄的是啥啊???
回答,熬了一晚上弄的一个Excel函数公式。。。
效果图:
F523 | 3 | F523-1206-003 |
4 | F523-1206-004 | |
9 | F523-1206-009 | |
G612 | 1 | G612-1206-001 |
C702 | 4 | C702-1206-004 |
C702-1206--004 | ||
C702-1206--004 | ||
C702-1206--004 | ||
A190 | 2 | A190-1206-002 |
A190-1206--002 | ||
C260 | 5 | C260-1206-005 |
1 | C260-1206-001 | |
4 | C260-1206-004 | |
3 | C260-1206-003 | |
6 | C260-1206-006 | |
148B | 1 | 148B-1206-001 |
2600 | 10 | 2600-1206-010 |
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
2600-1206--010 | ||
3300 | 6 | 3300-1206-006 |
3300-1206--006 | ||
3300-1206--006 | ||
3300-1206--006 | ||
3300-1206--006 | ||
3300-1206--006 | ||
1920 | 1 | 1920-1206-001 |
1930 | 1 | 1930-1206-001 |
1300 | 4 | 1300-1206-004 |
1300-1206--004 | ||
1300-1206--004 | ||
1300-1206--004 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15233475/viewspace-732866/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15233475/viewspace-732866/