ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸ó­¶¥X³f³æ¾ú¥v²Î­p

¸ó­¶¥X³f³æ¾ú¥v²Î­p

¦pÃD»Ý­n¸ó­¶¥X³f³æ¾ú¥v²Î­p

1.¦p¦ó¦b¥X³f³æ¾ú¥v²Î­pªí¤¤Åã¥Ü¥X³f³æ¸ê®Æ

2.¥X³f³æ  ²Î­p§¹«á·í¤éÁÙ¥iÄ~Äò¿é¤J²Ä2µ§¤£¦P«È¤áªº¸ê®Æ  ¤]·|Ä~ÄòÅã¥Ü¦b¥X³f³æ¾ú¥v²Î­pªí¤¤

­n¦p¦ó¤~¯à°µ¥X¨Ó£z

ÁÂÁÂ:dizzy:

¥X³f³æ¾ú¥v²Î­p.rar (3.3 KB)

«Øij¨Ï¥Î¦X¨Ö¦C¦L¤ñ¸û¤è«K..@@
conier..¦b¦¹½Ð¦h«ü±Ð¤F..^^

TOP

G5ªº¤½¦¡´N­È±o°Óºe¡G
¦pªG¦P¤@¤Ñ¦³¦h笔业务ªº¡§NO."¬O¬Û¦Pªº话¡A¡§³æ        ¸¹¡¨´N会­«Î`¡C
¤½ªÀ¬O´Êªø«CÃÃ,ªÀ­û³£¬OÃäWªº¥Ê.

TOP

¬y¤ô½s¸¹À³±q¾ú¥v¬ö¿ý¤¤§ä¥X¸ê®Æ
G5°}¦C¤½¦¡
=TEXT($G$4,"yyyymmdd")&TEXT(MAX(IF(LEFT(¥X³f³æ¾ú¥v²Î­p!$A$3:$A$65536,8)=TEXT($G$4,"yyyymmdd"),--RIGHT(¥X³f³æ¾ú¥v²Î­p!$A$3:$A$65536,3),""))+1,"000")
¤£¹L¡A­n±N¥X³f³æ¤º®eÂà¦s¦Ü¾ú¥v¬ö¿ý¤¤¡AÀ³¸Ó¤£¬O¦X¨Ö¦C¦L©Î¬O¨ç¼Æ¨Ó§¹¦¨
«Øij¦Üµ{¦¡°Ï¤¤µo°Ý¡A¨Ï¥ÎVBA¸Ñ¨M
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦pªGG5°}¦C¤½¦¡
=TEXT($G$4,"yyyymmdd")&TEXT(MAX(IF(LEFT(¥X³f³æ¾ú¥v²Î­p!$A$3A$65536,8)=TEXT($G$4,"yyyymmdd"),--RIGHT(¥X³f³æ¾ú¥v²Î­p!$A$3A$65536,3),""))+1,"000")
·|±o¨ì#VALUE!

TOP

¦^´_ 5# janejacky

À³¸Ó¬O§A¨S¦³¥ÎCTRL+SHIFT+ENTER¿é¤J¡A¥B¾ú¥v¸ê®Æ¨ÃµL¸Ó¤é´Áªº³æ¸¹¦s¦b¤~·|¥X²{¦¹¿ù»~
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD