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

[µo°Ý] ¦p¦ó¨ú±o¨C¤Ñ¸ê®Æªº§ó·s·|¦Û°Ê²£¥Í¦b¤U¤@­ÓÀx¦s®æ¸Ìªº¨º¤å¦r

[µo°Ý] ¦p¦ó¨ú±o¨C¤Ñ¸ê®Æªº§ó·s·|¦Û°Ê²£¥Í¦b¤U¤@­ÓÀx¦s®æ¸Ìªº¨º¤å¦r

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2012-7-7 11:51): ½Ð±NÀÉ®×À£ÁY¤W¶Ç»¡©ú

¦U¦ì¤j¤j
§Ú¥Ø«e·Q¦bEXCEL¬YÄæ¦ìªº°Ï°ì¤¤~ §ä¥X¦]fx¤½¦¡©Ò²£¥Íªº¤å¦r~
¦Ó­n§äªº¨º¤å¦r~ ·|¦]¨C¤Ñ¸ê®Æªº§ó·s·|¦Û°Ê²£¥Í¦b¸ÓÄæ¦ìªº¤U¤@­ÓÀx¦s®æ¸Ì~
¨Ã¯à±N¸Ó¤å¦r©T©wÅã¥Ü¦b¸ÓÄæ¦ìªº¤U¤è¬Y¤@Àx¦s®æªº¦ì¸m¤W~
¨Ò¦p:
¤µ¤Ñ¦]fx¤½¦¡IF(H113>=K113,"¬O","§_")·|¦bÄæ¦ìªºÀx¦s®æ²£¥Í¥X"¬O"¦r~
¦¸¤@¤é¦]fx¤½¦¡IF(H113>=K113,"¬O","§_")²£¥Í¥X"§_"¦r(·|¸¨¦b¤U¤@®æ)~ ¨Ì¦¹Ãþ±À~
¨º§Ú§Æ±æ³o¨Ç²£¥Íªº"¬O"©Î"§_"¯à©T©w¦b¥t¤@Àx¦s®æ¤¤ÅÜ´«~ ¨º¸ÓÀx¦s®æªºfx¤½¦¡¸Ó¦p¦ó¼g?¦p¦ó³]©w?
¤w¸g§xÂZ¦n¤[
·P®¦

¹ï¤£°_
²{¦b§âÀɮ׶ǤW¥hÅo
ÁÂÁª©¥D¤Î¦U¦ì¤j¤j

±ý³B²zÀÉ®×.rar (11.51 KB)

TOP

¦^´_ 2# wghost

C1=TODAY()
C2=TEXT(TODAY(),"aaa")
C9=IF(ISERROR(HLOOKUP(TODAY(),$D$1:$AF$9,9,0)),"µL¤µ¤é¸ê®Æ",HLOOKUP(TODAY(),$D$1:$AF$9,9,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¶W¯Åª©¥D~
¯uªºÁÂÁ§A~
¶W¯Å¦n¥Îªº~¤]¾Ç¨ì¤F³o¨Ç«ü¥Oªº¥Îªk~
§Ú¥i¥H¦A½Ð°Ý¤@­Ó°ÝÃD¶Ü~
­Y¬Û¦Pªº³o­ÓEXECLªí~§Ú¥i¥H¦p¦óÅý©P¤»¤Î©P¤é(µL¤µ¤é¸ê®Æ)¨ÌµM¥uÅã¥Ü°±¯d¦b­ì©P¤­ªºµ²ªG("¬O"©Î"§_")¶Ü~·N«ä´N¬O©P¤»»P©P¤é§Ú¬O¤£°µ¸ê®Æªº«Ø¥ßªº~
¯u±o¦A¦¸·P®¦~
ÁÂÁÂ~

TOP

¦^´_ 4# wghost

C1=LOOKUP(TODAY(),$D$1:$AF$1)
C2=TEXT(C1,"aaa")
C9=HLOOKUP(TODAY(),$D$1:$AF$9,9,1)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh¶W¯Åª©¥D:·Q½Ð°Ý§A¦X¨Ö¦h­ÓEXCEL¾×¨ì¦P¤@­Ó¤À­¶ªº°ÝÃD

TOP

¤£ª¾¹D«ç»òª©¥D¹ï¸Ü~

TOP

§Ú§Æ±æ¥L¥i¥H¦X¨Ö«á¤£¬O¥Î¤À­¶ªº¤è¦¡¥h°µ¡A¦Ó¬O±µÄò¤W­±¨º¤@­Ó¦ì¸mÄ~Äò©¹¤U¶K ³o¼Ë¥i¥H°µ¶Ü??

TOP

¹ê¦b¤Ó·PÁÂHsieh¶W¯Åª©¥D~
¯uªºÁÂÁ§A~
°ÝÃD¯uªº¸Ñ¨M¤F~
§A¯uªº¦n¼F®`~¨ØªA¨ØªA~
ÁÂÁÂ~·P®¦~~~

TOP

¦^´_ 6# qwern
°ÝÃD­n»¡©ú²M·¡¤~ª¾¹D¦p¦ó¦^µª§A
½Ð¤W¶ÇÀɮרû¡©ú§Aªº»Ý¨D
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD