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

¦p¦óÅý®É¶¡¤é´Á¹ïÀ³¬P´Á~¨C¶g¥u§ì5~6¤Ñ(5/4§ó·s¡AHsieh ¸Ñµª¤F§Úªº»Ý¨D)

¦p¦óÅý®É¶¡¤é´Á¹ïÀ³¬P´Á~¨C¶g¥u§ì5~6¤Ñ(5/4§ó·s¡AHsieh ¸Ñµª¤F§Úªº»Ý¨D)

¥»©«³Ì«á¥Ñ av8d ©ó 2012-5-4 09:56 ½s¿è

Flood.rar (2.35 KB)
¦p¦óÅý®É¶¡¤é´Á¹ïÀ³¬P´Á~¨C¶g¥u§ì5¤Ñ

§Ú§Æ±æ¥i¥H§Ö³tªº»s§@¥XÂù¤ë¥÷ªí®æ
¨Ò¦p§Ú­n°µ5~6¤ë
¥ªÃ䨺¤@±Æ´N¬O5¤ë¥kÃä´N¬O¤»¤ë~¤é´Á©M¬P´Á·|¦Û°Ê¹ïÀ³~
¨C¶g§ì5¤Ñ~°¸º¸Â§«ô¤»­n¸É¤W¯Z~
ÃC¦â·|¦Û°ÊÅܦâ~¥u¬O¬°¤F°Ï¹j®e©ö¿ë»{~

·s¤HµLªk¤U¸ü
¦h¼L²VÂI¼Æ
=week( ) ¥i±o¬P´Á´X ¼Æ­È

¤é´Á®æ¦¡®æ¦¡ ¦Û­q ©P´X(aaa) ©Î ¬P´Á´X (aaaa)
¤Þ¥Î(µLªk¤W¶Ç SORRY  ¤£·|¶Kªí®æ)

TOP

¦^´_ 1# av8d

¦³
1.¨ç¼Æ
2.¦WºÙ/©w¸q
3.³]©w®æ¦¡¤Æ±ø¥ó
½Ð¦Û¦æ°Ñ¾\ÀÉ®×

Flood.rar (5.18 KB)

TOP

¦^´_ 2# Ä|¤l
©³¦âÅܦ⠭n ®æ¦¡----   ³]©w®æ¦¡¤Æ±ø¥ó  ¥H=week() ¨ºÄæ>5 ¨Ó§P©w ¶g¥½

TOP

¦^´_ 1# av8d
¸É¤W¯Z¤ñ¸û³Â·Ð
Flood.rar (5.44 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-3-8 14:27 ½s¿è

¦^´_ 3# register313


    ·PÁ¦U¦ì¤j¤j~

½Ð°Ý¤j¤j±zªº3¤ë1¤é©M4¤ë1¤é¬O§_¦³ª½±µ¼g¦b¸Ì­±ªº¤èªk©O? ÁÂÁÂ!

½Ð°Ý¤@¤U~¬P´Áªº³¡¥÷
=IF(C2="","","("&RIGHT(TEXT(WEEKDAY(C2,1),"aaa"))&")")

¦pªGC2¤º®e¤À¶}
Åܦ¨C1 ¦~¥÷  C2 ¤ë¥÷  C3¤é´Á   ¬O§_¦³¿ìªk?

TOP

¦^´_ 6# av8d

½Ð°Ý¤j¤j±zªº3¤ë1¤é©M4¤ë1¤é¬O§_¦³ª½±µ¼g¦b¸Ì­±ªº¤èªk©O? ÁÂÁÂ!
==>
§ï¦¨3»P4
­Y§t¦b¤½¦¡¸Ì­±,­Y­n§ï§@5¤ë6¤ë,§A´N­n§ï¤½¦¡,¤£·|¤ñ¸û¦n
§ï¦¨3(¤ë) »P4(¤ë)
¬Ý²Å¤£²Å»Ý¨D
Flood1.rar (6.31 KB)


¦pªGC2¤º®e¤À¶}
Åܦ¨C1 ¦~¥÷  C2 ¤ë¥÷  C3¤é´Á   ¬O§_¦³¿ìªk?
==>
¦~¥÷ ¤ë¥÷ ¤é´Á ¤À3­ÓÄæ¦ìÅã¥Ü,¦n¹³¤]¤£»Ý­n,¸ê®Æ­«ÂЩʤӰª
¬Ý§Aªº»Ý¨D°Õ

TOP

¦^´_ 7# register313


    ½Ð°Ý¤j¤j~­×§ï¤ë¥÷·|¥X²{#NAME?~

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2012-3-13 10:23 ½s¿è

¦^´_ 5# Hsieh



«D±`·PÁÂ~­ì¨Ó´«·s¨t²Î´N¨S°ÝÃD¤F~ÁÂÁÂ!

TOP

¦^´_ 8# av8d

­×§ï¦~:A2¿é¤J99©Î100©Î101©Î102....(¤£­n¿é¤J"¦~")
­×§ï¤ë:A3(D3)¿é¤J1~12(¤£­n¿é¤J"¤ë")
´ú¸Õ¬OOKªº

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD