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

[µo°Ý] (¤w¸Ñ¨M)ªÑ¥«¶R½æÂI¥i¥H¥Î¦r¨å°µ¶Ü

¦^´_ 10# Hsieh


    ª©¥D
   ³o¬O§Ú­nªº
   ¦Ó¥B¤£¥Î¸g¹LSÄæ
   ¦r¨åªGµM«Ü§Ö
    ¤£¹L¤U­±¹ï§Ú¦Ó¨¥¦³ÂI¥È
    f = IIf(d.Count > 0 And d.Count Mod 2 > 0, "=RC[-1]-R[-1]C[-1]", "")
      d(Ar(i, 1)) = Array(Ar(i, 1), Ar(i, 5), f)
      .[W2].Resize(d.Count, 3) = Application.Transpose(Application.Transpose(d.items))

    ¬Ý¾é´X¤Ñªº¦r¨å §Ú¥H¬°¦³ÂI²z¸Ñ¦r¨å²{¦b¤S·PıÂ÷§Ú§ó»»»·
   §Ú¥H¬°d.count ¬O¥h­pºâ±M®×¼Æ À³¸Ó­n¥ý¦³ªF¦èÅý¥Lºâ§a?
   d.items¦b³o¸Ì¬O¤°»ò¶µ¥Ø?
   ¥i¥H±q­þ¸Ì¬Ý¨ì¶Ü?
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 11# freeffly


    ¦r¨åÅU¦W«ä¸q¡A¨C­Ó¯Á¤Þ­È(key)·|¹ïÀ³¤@­Ó¤º®e(item)
´N¦p¦P°ê»y¦r¨å¡A­Y¥H³¡­º¬d¸ß¡A¦P³¡­ºªº¦r·|«Ü¦h
³¡­º´N¬O¯Á¤Þ­È¡A¦Ó³o¨Ç¤£¦Pªº¦r´N¬O¤º®e
¦pªG¯Á¤Þ­È¹ïÀ³ªº¤º®e¬O³æ¤@¶µ¥Ø¡A¨º´N¤ñ¸û®e©ö²z¸Ñ
dictionary(key)=item
·í¹ïÀ³¤º®e¤£¥u¤@­Óªº®É­Ô¡A§A´N­n¬Ý§Aªº¤º®e­nªº¬O¬Æ»ò?
¦b¦¹½d¨Ò¤¤¡Akey¬O¤é´Á
·í±ø¥ó¦¨¥ßªº®É­Ô­n§â³o¤é´Áªº¦¬½L»ù¬ö¿ý¤U¨Ó
·íµM³o¬O³æ¤@¤º®e¡A¤£¹L¡A·í§A­n¼g¤J¤u§@ªí®É
¬O­n¦³3Ä檺¸ê®Æ:1.¤é´Á¡A2.¦¬½L»ù¡A3.»ù®t
³o­Ó»ù®t¬O2­Ó¤é´Áªº®tÃB¡A­Y­n¦b¦r¨å¤º¨ú±o«e¤@­Óªº»ù®æ¡A·|¼W¥[³\¦h§xÃø
©Ò¥H¡A±N²Ä3Äæ¥Î¤½¦¡±a¤J¡A¦b¸Ó¦³¤½¦¡ªº®É­ÔÅý°}¦Cªº²Ä3­Ó¤¸¯À¼g¤J¤½¦¡
³o¼Ë¶]§¹¥þ³¡¸ê®Æ«á¡A¦r¨å´N·|¦³­Y¤z­Ókey
¦r¨åªºcountÄÝ©Ê´N¬Okeyªº¼Æ¶q
keys«hªí¥Ü©Ò¦³ªº¯Á¤Þ­È¡A©Ò§Î¦¨ªº°}¦C
items«hªí¥Ü©Ò¦³ªº¤º®e
¦]¬°¦¹½d¨Ò¤¤¨C­Óitem³£¬O¤@­Ó¤@ºû°}¦C
©Ò¥Hitems´Nµ¥©ó¬O¤Gºû°}¦C
³oÃä­nª`·N¤@ÂI¡A¦pªG¤Gºû°}¦C¡A­ì¥»¥u­nª½±µ¼g¤JÀx¦s®æ§Y¥i
¦b³oÃäitems³o­Ó¤Gºû°}¦C¡A¹ê»Ú¤W¥L¬O¤@ºû°}¦C¡A¥u¤£¹L³o­Ó¤@ºû°}¦Cªº¨C­Ó¤¸¯À³£¥]§tµÛ¤@­Ó¤@ºû°}¦C
©Ò¥H¥²¶·¨Ï¥Î¨â¦¸ªºÂà¸m(Transpose)°Ê§@¡A¤~·|Åܦ¨¯u¥¿ªº¤Gºû°}¦C¡A¤~¥iª½±µ¼g¤J¤u§@ªí
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 12# Hsieh


    ª©¥DÁ¿ªº¦n¸Ô²Ó
   Åý§Ú¦³¨Ç²z¸Ñ
   §Ú·Q§Ú¥i¯à­n³z¹L«Ü¦h¨Ò¤l¤~¯à¦Û¤v¹B¥Î
   
   ÁöµM¦r¨å¤£¬O°ß¤@¤èªk
   ¦ý¬O¦r¨å«Ü¬¯
   ¦Ó¥B³t«×«Ü§Ö
   Åý§Ú·Q­n¾Ç²ß
   
   ¦A¨Óª¦¤å...
    ¸ô³~ÁÙ¯u»»»·
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 1# freeffly


½Ð±Ð¤j¤j¡A§AÀɮפ¤ªº ¤j½L¸ê®Æ ¬O¦p¦ó¨ú±oªº¡H
¬O³z¹LÂ^¨úºô­¶¸ê®Æªº¤è¦¡¶Ü¡H¦³µL¬ÛÃöªºµ{¦¡½X¥i¥H¤À¨É
ÁÂÁÂ

TOP

¦^´_ 14# jsleee


    §K¶O¥æ©ö³nÅé¸Ì­±ªº¸ê®Æ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

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