ªð¦^¦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¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD