ANGELA

A1=100430001
A2=IFERROR((TEXT(RIGHT(YEAR(TODAY()),2),"00")&TEXT(MONTH(TODAY()),"00")&TEXT(DAY(TODAY()),"00")&TEXT(RIGHT(LOOKUP(2,1/(LEFT($A$1:A1,6)=TEXT(RIGHT(YEAR(TODAY()),2),"00")&TEXT(MONTH(TODAY()),"00")&TEXT(DAY(TODAY()),"00")),$A$1:A1),3),"000"))+1,--(RIGHT(YEAR(TODAY()),2)&TEXT(MONTH(TODAY()),"00")&TEXT(DAY(TODAY()),"00")&"001"))
©¹¤UCOPY

Hsieh

¦^´_ 1# ¥ô§Ú¦æ


    ²³æ°µ­Ó½d¨ÒÀɨѰѦÒ
°e³f³æ.rar (10.46 KB)

¤U¸ü¦¸¼Æ: 14

2010-5-19 22:59

gong

¦¹ÃD¤£¾A¥Î©ó¤@¯ë°Ï,¥i¯à·|¦³­«½Æ°Ñ·Óªº°ÝÃD,«Øij²¾¦Üµ{¦¡°Ïµo°Ý