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

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 8 (ÁÂÁÂ)

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 8 (ÁÂÁÂ)

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-11-20 10:52 ½s¿è

¤]¬O±Æ¦Cªº°ÝÃD¡A½Ð±Ð¦Ñ®v«e½úÁÂÁ¡C



test011.rar (2.02 KB)
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

¦^´_ 1# binargoo

B5=MOD(ROW(A1)+1,5)*10+MOD($B$3+ROW(A1)*11,10)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

±Nb3²¾¨ìb4
b5=IF((B4+11)>50,MOD(B4+11,10),B4+11)
¤U©Ô¤½¦¡
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-11-13 11:21 ½s¿è

¦^´_ 3# gong


   ·PÁ gong ¦Ñ®v«e½ú´£¨Ñ«ü¾É¡AÁÂÁ¦AÁÂÁ¡C

   ¾Ç¥Í¤§«e°µªk¦p¦P (C12:C13¤§¶¡¦n¹³¤Ö¤F¤°»ò) ¬Gµo°Ý¡C

Booko2.jpg (107.83 KB)

Booko2.jpg

¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¦^´_ 2# Hsieh


    ·PÁ Hsieh ¶W¤j¦Ñ®v´£¨Ñ«ü¾É¡A¸g¹L´ú¸Õ OK¡A«D±`·PÁ¡C

    °l¥[½Ð±Ð 2 ÂI¡G
    1.¦b°µ¤½¦¡¬ã¨s®ÉÆ[©À¦³¨Ç·d²V¡A¯à§_µy§@»¡©ú·PÁ¡C
    2.¬Û¦P±ø¥ó¦pªG¦V¥k±Æ¦C¡A¤½¦¡¸Ó«ç»ò°µ¡H
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¦^´_ 5# binargoo


    §Aªº°ÝÃDÀ³¸Ó±N¤Q¦ì¼Æ»P­Ó¦ì¼Æ¤À¶}°Q½×
¦]¬°¤Q¦ì¼Æ­n¦b0~4¤¤¶¡°µ´`Àô¡A¥L·|¦³¤@­ÓÂk¹sªº°ÝÃD¦s¦b
·í¥[Á`µ²ªG¬O3¦ì¼Æ®É¡A­Y¥H«e2¦ì¼Æ­È¡A°£¥H5·|¦]¬°10ªº­¿¼Æ­ì¦]¡A³y¦¨µ¥®t¼Æ¦Cªº¿òº|
¦Ó§A»Ý­nªº¤Q¦ì¼Æ´`Àô¡A·í®É¬°¼Æ¤j©ó4´N¥²¶·Âk¹s¡AµM«á±q1¶}©l³sÄò½s¸¹
³o¥i¥H§Q¥Î¦C¸¹¨ÓÅý³o¼Æ¦CÅܦ¨§¹¾ã¼Æ¦C
MOD(ROW(A1)+1,5)
³o¬O¦b¼Æ¦C¶}©lªº²Ä¤@­Ó¦ì¸m­n¶Ç¦^ªº¥¿½T¤Q¦ì¼Æ¥Nªí­È
§ó¥¿½Tªº»¡ªkÀ³¸Ó¬O
MOD(ROW(A1)+INT($B$3/10),5)
³o¼Ë¤~·|¨Ì¾ÚB3³o­Ó°_©l­È°µÅܤÆ
©Ò¥H¡A§A­n±N³o­Ó°ÝÃDÂন¾î¦V
¨º´N´«¦¨¨ú¥ÎÄ渹COLUMN
MOD(COLUMN(A1)+INT($B$3/10),5)
³o¼Ë¦V¥k½Æ»s
´N»PMOD(ROW(A1)+INT($B$3/10),5)¦V¤U½Æ»s
¦¨¬°Áa¾î¤£¦Pªº¬Û¦P¼Æ¦C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-11-19 13:45 ½s¿è

¦^´_ 6# Hsieh


    ÁÂÁ Hsieh ¶W¤j¦Ñ®v²Ó¤ß¸Ñ»¡¡A¾Ç¥Í»â·|¤F¡C¦A¦¸·PÁ¡I
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD