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

[µo°Ý] ­«·sµo°Ý~~¦p¦ó±Nsheet2¦³®Ä¤é´Á³Ì¤j­È¶×¤Jsheet1«ü©w¦ì¸m¤¤

[µo°Ý] ­«·sµo°Ý~~¦p¦ó±Nsheet2¦³®Ä¤é´Á³Ì¤j­È¶×¤Jsheet1«ü©w¦ì¸m¤¤

¥»©«³Ì«á¥Ñ pupai ©ó 2010-9-26 23:07 ½s¿è

¥ý«e¥i¯à¦U¦ì»~·|§Ú·N«ä
§Ú­«·sµo°Ý~~~~
Sheet2ªºB2Äæ¦ì¤é´Á¸ê®Æ¬O¤å¦r®æ¦¡,§Ú¤£¯à¥h§ïÅÜ¥¦ªº®æ¦¡,¤]¤£·Q¥Î¨â«h¥H¤Wªº¤½¦¡
©Ò¥H§Ú·Q¦³¨S¦³¥u¦³¤@«h¤½¦¡(¤@­Ó°Ê§@§¹¥þ·d©w)
¤@¦¸±NSheet2ªºB2Äæ¤å¦rÂର¤é´Á®æ¦¡¡A¨ú¥X³Ì¤j­È¡AµM«á¥H¤é´Á®æ¦¡¶×¤J²Ä¤@¥÷Sheet1ªº«ü©w¦ì¸m¸Ì­±¡C
ÁÂÁÂ!!!

¸ê®ÆÀÉ.rar (56.52 KB)

¦Ñ¤j
§Ú¤]«ÜµL©`°Ú!!
±Ð°Vªº¬O~~
ÁÂÁÂ
¾Ç²ß´r§Ö

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-27 13:45 ½s¿è

­n©}´N¤£¥¿½Tªº¸ê®Æ«¬ºA,¼g¤@¤j¦ê¤½¦¡
³y¦¨¤j¶q¸ê®Æ­pºâ®É·í¾÷ªº¥i¯à¦s¦bÁô¼~
Åý¦ÑÁó»{¬°§A«Ü¦£¨º´NÄ~Äò¿ù¤U¥h
¦pªG·Q­n´£¤É®Ä²v
´N§â¸ê®Æ«¬ºA§ó¥¿(­åªR´N¥i¹F¨ì)
¹B¥Î¼Ï¯Ã¤ÀªR(¤@¦¸¸Ñ¨M¦W³æ¤Î²Î­p)
ªþ¥ó¬°¼Ï¯Ã¤ÀªRªí¸Ñªk
¸ê®ÆÀÉ.zip (615.02 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# pupai


database¨Ó¦Û¨ä¥L¨t²Î,¬Û«Hpupai¤]«ÜµL©`
b2Åã¥Ü¤é´Á®æ¦¡
°}¦C¤½¦¡
=IF(SUM((±b¥»!$A$2:$A$54=¸ê®Æ!A2)*(±b¥»!$B$2:$B$54<>"")),MAX((±b¥»!$A$2:$A$54=¸ê®Æ!A2)*IF(±b¥»!$B$2:$B$54="",0,(DATE(LEFT(±b¥»!$B$2:$B$54,3)+1911,MID(±b¥»!$B$2:$B$54,5,2),RIGHT(±b¥»!$B$2:$B$54,2))))),"")
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

¦^´_ 1# pupai

¦Û°Q­W¦Y
B2°}¦C¤½¦¡
{=IF(ISERROR(DATEVALUE(TEXT(MAX(IF(±b¥»!$A$2:$A$54=¸ê®Æ!A2,--SUBSTITUTE(±b¥»!$B$2:$B$54,"/","")))+19110000,"0000-00-00"))),"",TEXT(DATEVALUE(TEXT(MAX(IF(±b¥»!$A$2:$A$54=¸ê®Æ!A2,--SUBSTITUTE(±b¥»!$B$2:$B$54,"/","")))+19110000,"0000-00-00")),"e/mm/dd"))}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD