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

[µo°Ý] ¤@­Ó¹ï§Ú¨Ó»¡«Ü½ÆÂøªº¦^¶Ç

[µo°Ý] ¤@­Ó¹ï§Ú¨Ó»¡«Ü½ÆÂøªº¦^¶Ç

¤@­Ó¦^¶Ç¤è­±ªº°ÝÃD

­«¶q°Oºâ.rar (8.75 KB)
sky

¥[»²§UÄæ³B²z
°Ñ¦Ò¬Ý¬Ý

«Ü¿ò¾ÑµLªk§¹¦¨¤£¨ú­«ÂЭÈ
¤½¦¡¸Õ¤F¦bÀɮפ¤F9¬Ý¨S°ÝÃD
¦ý´N¬OµLªkÅã²{¼Æ­È,¤£ª¾¦ó¬G
½Ð¥ý¶iÀ°¦£¬Ý¬Ý

A.rar (5.4 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ºñ¦rªº±Æ¦C¦³µL¯S§O³W©w?
¬O¨ÌÂŦâ¦r¥X²{ªº¶¶§Ç©Î¨Ì¤Wªíªº¶¶§Ç©ÎµL¶¶§Ç³£¥i¥H
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¤§«e¤]¦³­n¥Î¨ìÃþ¦üªºªF¦è¡A©Ò¥H°Ñ¦Ò¤F«Ü¦h¦³°µ¥XÃþ¦üªº¥\¯à
¤£¹L¥²»Ý§ïÅܤ@¤U²M³æªº®æ¦¡«h¥i¥H¥Î§Ú³o­Ó¤èªk°µ¥X¨Ó
Åv­­¤£°÷¤£¯à¤U¸ü¡A©Ò¥H¦Û¤vÀH«K§Ë¤F¤@­ÓÅý§A°Ñ¦Ò¬Ý¬Ý


aa.rar (6.66 KB)

¥t¥~°Ý­Ó°ÝÃD¡Arow¸Ì­±ªºªF¦è¥Nªí¤°»ò·N«ä¡Arow¸Ì­±ªºÀx¦s®æªø«×­n³]¦hªø¡A³o­Ó³¡¥÷¤@ª½³£·d¤£¤Ó²M·¡

TOP

¦^´_ 4# callinner


    ¨ä¹ê³o¯uªº«Ü½ÆÂø§Ú¥i¯à­n¬Ý«Ü¤[¡A§Ú´N¥ý¤U¸ü¨Ó¬Ý¬Ý
ÁÂÁ§Aªº¤À¨É
sky

TOP

¦^´_ 5# qwer7632


    ¸Õ¸Õ¬Ý
­«¶q°Oºâ.zip (9.68 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

H7:M7 ¿é¤J 1¡B2¡B3...7
H8¤½¦¡¦p¤U
=SUMPRODUCT((OFFSET($B$2:$B$3,,H$7*3-3)=$G8)*SUBSTITUTE(OFFSET($D$2:$D$3,,H$7*3-3),"G",))
¥k©Ô¦ÜM¡A¤U©Ô¦Ü14 ½Æ»s¤½¦¡

N8 ¦X­p
=SUM(H8:M8)
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ zz5151353 ©ó 2012-10-17 11:47 ½s¿è

¥t¤@ºØ¤èªk,½Ð°Ñ¦Ò

­«¶q°Oºâ.rar (5.1 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD