2010.02.18 Thursday
Âçºå¥»¥ß¥Ê¡¼¤È¥á¥ë¥Þ¥¬
¢£VBA¥»¥ß¥Ê¡¼¤Î4·î³«ºÅͽÄê¤ò¸ø³«¤·¤Þ¤·¤¿¡£
¥ê¥¯¥¨¥¹¥È¤¬¤¢¤Ã¤¿¤Î¤Ç¡¢4·î¤ÏÂçºå¤Ç¤â¤ä¤ê¤Þ¤¹¡£
ºÇ¶á¡¢ÂçºåÊýÌ̤˹ԤäƤ¤¤Ê¤¤¤Î¤Ç¡¢¤¿¤Þ¤Ë¤Ï¥¦¥Þ¥¤¤â¤ó¿©¤¤¤¿¤¤¤Ç¤¹(¾Ð)
2010ǯ2·î20Æü(ÅÚ)-21Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ2·î27Æü(ÅÚ)-28Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
2010ǯ3·î20Æü(ÅÚ)-21Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ3·î27Æü(ÅÚ)-28Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
2010ǯ4·î10Æü(ÅÚ)-11Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯ (Âçºå)
2010ǯ4·î17Æü(ÅÚ)-18Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ4·î24Æü(ÅÚ)-25Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
Âçºå¤Ï¡¢5·î¤Ë¥¹¥¿¥ó¥À¡¼¥É¤ò¤ä¤ëͽÄê¤Ç¤¹¡£
¢§¾Ü¤·¤¯¤Ï¡¢¤³¤Á¤é
http://officetanaka.net/seminar/index.htm
-------------------------------------------------
¢£¥á¥ë¥Þ¥¬»Ï¤á¤Þ¤·¤¿
Office TANAKA¤Î¥á¥ë¥Þ¥¬(¥á¡¼¥ë¥Þ¥¬¥¸¥ó)¤ò»Ï¤á¤Þ¤·¤¿¡£
̵ÎÁ¤Ç¤¹¡£
Excel¤Î¥Í¥¿¤Ï¤â¤Á¤í¤ó¡¢¥»¥ß¥Ê¡¼¤ä¹Ö±é¤ÎͽÄê¡¢Office TANAKA¥µ¥¤¥È¤Î¿·Ãå¤ä¤ªÁ¦¤á¥³¥ó¥Æ¥ó¥Ä¡¢¤Á¤ç¤Ã¤È¸ø¤Ë¤Ï¸À¤¤¤Ë¤¯¤¤Î¢¾ðÊó¤Ê¤É¤òÇÛ¿®¤·¤Þ¤¹¡£
¤È¤ê¤¢¤¨¤ºÅÐÏ¿¤·¤Þ¤»¤ó¤«¡©ÌµÎÁ¤Ç¤¹¤«¤é(¾Ð)
¢§¾Ü¤·¤¯¤Ï¡¢¤³¤Á¤é
http://officetanaka.net/magazine/index.htm
2009.12.07 Monday
1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø
´ò¤·¤¤¤³¤È¤ËËè²ó¿¤¯¤ÎÊý¤¬»²²Ã¤·¤Æ¤¯¤ì¤ë¡ÖVBA¥»¥ß¥Ê¡¼¡×¤Ç¤¹¤¬¡¢2010ǯ1·î¡Á3·î¤Î¼Â»ÜÆüÄø¤¬·è¤Þ¤ê¤Þ¤·¤¿¡£
2010ǯ1·î23Æü(ÅÚ)-24Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ1·î30Æü(ÅÚ)-31Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
2010ǯ2·î20Æü(ÅÚ)-21Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ2·î27Æü(ÅÚ)-28Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
2010ǯ3·î20Æü(ÅÚ)-21Æü(Æü)¡¡¥Ù¡¼¥·¥Ã¥¯
2010ǯ3·î27Æü(ÅÚ)-28Æü(Æü)¡¡¥¹¥¿¥ó¥À¡¼¥É
¤Û¤ÜËè²ó¡¢ËþÀʤǥ¥ã¥ó¥»¥ëÂÔ¤Á¤Ë¤Ê¤ê¤Þ¤¹¤Î¤Ç¡¢¤ª¿½¤·¹þ¤ß¤Ï¤ªÁá¤á¤Ë¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
¥Í¥Ã¥È¤Ç¸¡º÷¤·¤¿¥³¡¼¥É¤ò¥³¥Ô¥Ú¤·¤Æ¤ë¤À¤±¤Ç¤Ï¡¢¤¤¤Ä¤Þ¤Ç¤¿¤Ã¤Æ¤âVBA¤Ï¥Þ¥¹¥¿¡¼¤Ç¤¤Þ¤»¤ó¡£¼«Ê¬¤Ç¥Þ¥¯¥í¤òºî¤Ã¤¿¤ê¡¢Â¾¿Í¤Îºî¤Ã¤¿¥Þ¥¯¥í¤òÆɤá¤ë¤è¤¦¤Ë¤Ê¤ë¤Ë¤Ï¡¢VBA¤Î´ðÁäò³Ø½¬¤¹¤ë°Ê³°¤ËÊýË¡¤Ï¤¢¤ê¤Þ¤»¤ó¡£
2Æü´Ö¤Ç¡¢É¬¤º¥Þ¥¯¥í¤òºîÀ®¤Ç¤¤ë¤è¤¦¤Ë¤·¤Æ¤ß¤»¤Þ¤¹¡£
¤â¤Á¤í¤ó¡ÖVBA¥¨¥¥¹¥Ñ¡¼¥È¡×¤Ë¤â¡¢É¬¤º¹ç³Ê¤µ¤»¤Þ¤¹¡£
»ä¤Ï¡¢ÆüËܤǤϿô¾¯¤Ê¤¤"Excel¤Î¥×¥í"¤Ç¤¹¡£
»ä¤ò¿®¤¸¤Æ¤¯¤À¤µ¤¤¡£
2009.10.01 Thursday
Excel 2010¤Î¥ì¥Ó¥å¡¼»Ï¤á¤Þ¤·¤¿
Íèǯ(2010ǯ)ȯÇäͽÄê¤Î¡ÖExcel 2010¡×¤ò¥ì¥Ó¥å¡¼¤·¤Þ¤¹¡£
11·îº¢¤Ë¤Ï¥Ù¡¼¥¿ÈǤ¬ÇÛÉÛ¤µ¤ì¤ë¤È¤¤¤¦±½¤âʹ¤¤¤Æ¤¤¤Þ¤¹¡£¥Ñ¥½¥³¥ó»¨»ï¤äWeb¤Ç¤â¡¢¥ì¥Ó¥å¡¼µ»ö¤¬·ÇºÜ¤µ¤ì¤ë¤Ç¤·¤ç¤¦¡£¤¿¤À¡¢¤½¤¦¤·¤¿µ»ö¤Ï°ìÈÌŪ¤Ë¡¢Microsoft¤«¤éÄ󶡤µ¤ì¤ë»ñÎÁ¤ò¸µ¤Ë½ñ¤«¤ì¤Þ¤¹¤«¤é¡¢Microsoft¤Î"¥ª¥¹¥¹¥áµ¡Ç½"¤¬Ãæ¿´¤Ë¤Ê¤ê¤Þ¤¹¡£
¤Ç¤â¡¢¼ÂºÝ¤Ë»È¤Ã¤Æ¤ß¤ë¤È¡¢¤½¤¦¤·¤¿Â礤ʵ¡Ç½ÊѲ½¤è¤ê¤â¡¢¤Á¤ç¤Ã¤È¤·¤¿¾®¤µ¤Êµ¡Ç½Êѹ¹¤ä»ÅÍÍÊѹ¹¤¬»È¤¤¾¡¼ê¤ËÂ礤¯±Æ¶Á¤òÍ¿¤¨¤Þ¤¹¡£¤Ê¤Î¤Ç¡¢¤½¤¦¤·¤¿¡Ö¼ÂºÝ¤Ë¿¨¤Ã¤Æ¤ß¤Ê¤¤¤È¤ï¤«¤é¤Ê¤¤Êѹ¹ÅÀ¡×¤ÈÃæ¿´¤Ë¥ì¥Ó¥å¡¼¤·¤Þ¤¹¡£
http://officetanaka.net/excel/excel2010/
11·îº¢¤Ë¤Ï¥Ù¡¼¥¿ÈǤ¬ÇÛÉÛ¤µ¤ì¤ë¤È¤¤¤¦±½¤âʹ¤¤¤Æ¤¤¤Þ¤¹¡£¥Ñ¥½¥³¥ó»¨»ï¤äWeb¤Ç¤â¡¢¥ì¥Ó¥å¡¼µ»ö¤¬·ÇºÜ¤µ¤ì¤ë¤Ç¤·¤ç¤¦¡£¤¿¤À¡¢¤½¤¦¤·¤¿µ»ö¤Ï°ìÈÌŪ¤Ë¡¢Microsoft¤«¤éÄ󶡤µ¤ì¤ë»ñÎÁ¤ò¸µ¤Ë½ñ¤«¤ì¤Þ¤¹¤«¤é¡¢Microsoft¤Î"¥ª¥¹¥¹¥áµ¡Ç½"¤¬Ãæ¿´¤Ë¤Ê¤ê¤Þ¤¹¡£
¤Ç¤â¡¢¼ÂºÝ¤Ë»È¤Ã¤Æ¤ß¤ë¤È¡¢¤½¤¦¤·¤¿Â礤ʵ¡Ç½ÊѲ½¤è¤ê¤â¡¢¤Á¤ç¤Ã¤È¤·¤¿¾®¤µ¤Êµ¡Ç½Êѹ¹¤ä»ÅÍÍÊѹ¹¤¬»È¤¤¾¡¼ê¤ËÂ礤¯±Æ¶Á¤òÍ¿¤¨¤Þ¤¹¡£¤Ê¤Î¤Ç¡¢¤½¤¦¤·¤¿¡Ö¼ÂºÝ¤Ë¿¨¤Ã¤Æ¤ß¤Ê¤¤¤È¤ï¤«¤é¤Ê¤¤Êѹ¹ÅÀ¡×¤ÈÃæ¿´¤Ë¥ì¥Ó¥å¡¼¤·¤Þ¤¹¡£
http://officetanaka.net/excel/excel2010/
2009.09.30 Wednesday
VBA¥»¥ß¥Ê¡¼¡Ö¥¹¥¿¥ó¥À¡¼¥É¡×¤ä¤ê¤Þ¤¹
Ëè²ó¿¤¯¤ÎÊý¤¬»²²Ã¤·¤Æ¤¯¤ì¤ë¥Ù¡¼¥·¥Ã¥¯¤Ë²Ã¤¨¤Æ¡¢¥ê¥¯¥¨¥¹¥È¤Î¿¤«¤Ã¤¿¥¹¥¿¥ó¥À¡¼¥É¸þ¤±¥»¥ß¥Ê¡¼¤ò¤ä¤ê¤Þ¤¹¡£
¶µ¼¼¤Î´Ø·¸¾å¡¢¥Ù¡¼¥·¥Ã¥¯¤ÈƱ¤¸¤Ç¡¢Äê°÷¤Ï10̾¤Þ¤Ç¤Ç¤¹¡£
¤Þ¤¿¡¢¤³¤ì¤Þ¤¿¶µ¼¼¤ò¼Ú¤ê¤ëÅÔ¹ç¾å¡¢¼¡²ó°Ê¹ß¤Î³«ºÅͽÄê¤Ï̤Äê¤Ç¤¹¡£
¾Ü¤·¤¯¤Ï¡¢°Ê²¼¤Î¥Ú¡¼¥¸¤ò¤´Í÷¤¯¤À¤µ¤¤¡£
¢£¥Ù¡¼¥·¥Ã¥¯¡§10·î17Æü¡Á18Æü
http://officetanaka.net/seminar/seminar1.htm
¢£¥¹¥¿¥ó¥À¡¼¥É¡§10·î24Æü¡Á25Æü
http://officetanaka.net/seminar/seminar2.htm
2009.08.25 Tuesday
¶ÛµÞÏ¢Íí
ºòÆü(2009-08-24)¤Î¸áÁ°Ã椫¤é¡¢Office TANAKA¥µ¥¤¥È(http://officetanaka.net)¤Ë¥¢¥¯¥»¥¹¤Ç¤¤Ê¤¤¾õ¶·¤¬Â³¤¤¤Æ¤¤¤Þ¤¹¡£
¼Ú¤ê¤Æ¤¤¤ë¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¡Ö¥ê¥ó¥¯¥¯¥é¥Ö¡×¤Î¥È¥é¥Ö¥ë¤È»×¤ï¤ì¤Þ¤¹¡£
¸½ºß¡¢¥Û¥¹¥Æ¥£¥ó¥°¥µ¡¼¥Ó¥¹¤ª¤è¤Ó¥É¥á¥¤¥ó¤Î°Ü´É¼ê³¤¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤â¤·¤«¤¹¤ë¤È¡¢¤·¤Ð¤é¤¯¥µ¥¤¥È¤¬ÍøÍѤǤ¤Ê¤¯¤Ê¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£
¤Þ¤¿¡¢¥É¥á¥¤¥ó¤Ë(¤¤¤í¤ó¤Ê°ÕÌ£¤Ç)¥È¥é¥Ö¥ë¤¬À¸¤¸¤ë¤È¡¢officetanaka.net¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤â»ÈÍѤǤ¤Ê¤¯¤Ê¤ë²ÄǽÀ¤¬¤¢¤ê¤Þ¤¹¡£
¤½¤ÎºÝ¤Ï¡¢¤³¤Î¥Ö¥í¥°¤Ë¥³¥á¥ó¥È¤·¤Æ¤¤¤¿¤À¤¯¤«¡¢
officetanaka@gmail.com
¤Þ¤Ç¤ªÁ÷¤ê¤¯¤À¤µ¤¤¤Þ¤¹¤è¤¦¤ª´ê¤¤¤·¤Þ¤¹¡£
¤Ã¤¿¤¯¡¦¡¦¡¦¥ê¥ó¥¯¥¯¥é¥Ö¤ÏºÇÄãºÇ°¤Ç¤¹¡£
¼Ú¤ê¤Æ¤¤¤ë¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼¡Ö¥ê¥ó¥¯¥¯¥é¥Ö¡×¤Î¥È¥é¥Ö¥ë¤È»×¤ï¤ì¤Þ¤¹¡£
¸½ºß¡¢¥Û¥¹¥Æ¥£¥ó¥°¥µ¡¼¥Ó¥¹¤ª¤è¤Ó¥É¥á¥¤¥ó¤Î°Ü´É¼ê³¤¤ò¹Ô¤Ã¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢¤â¤·¤«¤¹¤ë¤È¡¢¤·¤Ð¤é¤¯¥µ¥¤¥È¤¬ÍøÍѤǤ¤Ê¤¯¤Ê¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£
¤Þ¤¿¡¢¥É¥á¥¤¥ó¤Ë(¤¤¤í¤ó¤Ê°ÕÌ£¤Ç)¥È¥é¥Ö¥ë¤¬À¸¤¸¤ë¤È¡¢officetanaka.net¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤â»ÈÍѤǤ¤Ê¤¯¤Ê¤ë²ÄǽÀ¤¬¤¢¤ê¤Þ¤¹¡£
¤½¤ÎºÝ¤Ï¡¢¤³¤Î¥Ö¥í¥°¤Ë¥³¥á¥ó¥È¤·¤Æ¤¤¤¿¤À¤¯¤«¡¢
officetanaka@gmail.com
¤Þ¤Ç¤ªÁ÷¤ê¤¯¤À¤µ¤¤¤Þ¤¹¤è¤¦¤ª´ê¤¤¤·¤Þ¤¹¡£
¤Ã¤¿¤¯¡¦¡¦¡¦¥ê¥ó¥¯¥¯¥é¥Ö¤ÏºÇÄãºÇ°¤Ç¤¹¡£
2009.07.29 Wednesday
8·î¤ÎVBA¥»¥ß¥Ê¡¼¤ÏÅìµþ¤ÈÂçºå¤Ç³«ºÅ
Ëè²ó¤¿¤¯¤µ¤ó¤ÎÊý¤¬»²²Ã¤·¤Æ¤¯¤ì¤ëVBA¥»¥ß¥Ê¡¼¤ò¡¢8·î¤â³«ºÅ¤·¤Þ¤¹¡£
¥»¥ß¥Ê¡¼¤ÎÌÜŪ¤Î¤Ò¤È¤Ä¤Ï¡ÖVBA¥¨¥¥¹¥Ñ¡¼¥È¤Ë¹ç³Ê¤¹¤ë¤³¤È¡×¤Ç¤¹¤¬¡¢»î¸³Âкö¤ÎÆâÍƤǤϤ¢¤ê¤Þ¤»¤ó¡£Íפ¹¤ë¤Ë¡¢¥Ó¥¸¥Í¥¹¤Î¸½¾ì¤Ë¤ª¤±¤ëVBA¤Î´ðÁäò¤·¤Ã¤«¤ê¤È¿È¤Ë¤Ä¤±¤ë¤³¤È¡£
¥Þ¥¯¥í¤Î·Ð¸³¤¬¤Ê¤¤Êý¤Ç¤â¡¢2Æü´Ö¤Î¥»¥ß¥Ê¡¼¤ò¼õ¹Ö¤¹¤ì¤Ð¡¢É¬¤º¼«Ê¬¤Ç¥Þ¥¯¥í¤òºîÀ®¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£»ö¼Â¡¢º£¤Þ¤Ç»²²Ã¤µ¤ì¤¿Êý¤Ï¡¢¤ß¤Ê¤µ¤óºî¤ì¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
º£¤Þ¤Ç¡¢»¨»ï¤ä½ñÀÒ¤ÇVBA¤ò³Ø½¬¤·¤è¤¦¤È¤·¤ÆºÃÀÞ¤·¤¿Êý¤Ë¤Ï¡¢Æä˥ª¥¹¥¹¥á¤Ç¤¹¡£ºÃÀÞ¤·¤¿¸¶°ø¤Ï¡¢¤¢¤Ê¤¿¤ÎÍý²òÎϤ¬Â¤ê¤Ê¤¤¤Î¤Ç¤Ï¤Ê¤¯¡¢¶µ¤¨Êý¤¬°¤¤¤ó¤Ç¤¹¡£Æäˡ֥ޥ¯¥íµÏ¿¤«¤é»Ï¤á¤è¤¦¡×Ū¤Ê¶µºà¤Ë¤ÏÍ×Ãí°Õ¤Ç¤¹¡£VBA¤Î³Ø½¬¤ò¡¢¥Þ¥¯¥íµÏ¿¤«¤é»Ï¤á¤¿¤é¡¢¤Û¤È¤ó¤É¤Î¿Í¤ÏÍý²ò¤Ç¤¤Þ¤»¤ó¡£¡Ö¥Þ¥¯¥íµÏ¿¤«¤é»Ï¤á¤è¤¦¡×¤Ï¡¢¤½¤ì¤¬ºÇŬ¤Ê¶µ¤¨Êý¤Ê¤Î¤Ç¤Ï¤Ê¤¯¡¢¶µ¤¨¤ë¦(½ñ¤¯Â¦)¤Î¾¡¼ê¤ÊÅÔ¹ç¤Ç¤·¤«¤¢¤ê¤Þ¤»¤ó¡£
¤µ¤é¤Ë8·î¤Ï
Åìµþ¤ÈÂçºå¤Ç¤ä¤ê¤Þ¤¹¡£
º£¤Þ¤Ç²¿²ó¤«Åìµþ¤Ç³«ºÅ¤·¤Æ¤¤Þ¤·¤¿¤¬¡¢¤½¤Î¤¿¤Ó¡ÖÂçºå¤Ç¤ä¤é¤ó¤«¤¤¡ª¡×¤È¡¢ÃȤ«¤¤¤´Í×˾¤ò¤¿¤¯¤µ¤ó¤¤¤¿¤À¤¤Þ¤·¤¿¡£º£²ó¡¢¤è¤¦¤ä¤¯¶µ¼¼¤ò¤ª¼Ú¤ê¤Ç¤¤Þ¤·¤¿¤Î¤Ç¡¢8·î¤Î29Æü¡Á30Æü¤Ç³«ºÅ¤·¤Þ¤¹¡£¤¼¤Ò¡¢¤´»²²Ã¤¯¤À¤µ¤¤¡£
2009.07.05 Sunday
VBA¥»¥ß¥Ê¡¼¤ä¤ê¤Þ¤¹
VBA¤Î¥»¥ß¥Ê¡¼¤ä¤ê¤Þ¤¹¡£
»ÈÍѤ¹¤ë¥Æ¥¥¹¥È¤«¤é¡ÖVBA¥¨¥¥¹¥Ñ¡¼¥ÈÀäÂйç³Ê¥»¥ß¥Ê¡¼¡×¤ÈÌÃÂǤäƤ¤¤Þ¤¹¤¬¡¢Íפ¹¤ë¤Ë¡ÖVBA¤Î´ðËܤò¥Þ¥¹¥¿¡¼¤¹¤ë¥»¥ß¥Ê¡¼¡×¤Ç¤¹¡£
¼Â¤ÏÀè·î¡¢Æ±¤¸¥»¥ß¥Ê¡¼¤ò³«ºÅ¤·¤¿¤Î¤Ç¤¹¤¬¡¢¤Þ¤Ã¤¿¤¯¥Þ¥¯¥í¤òºî¤Ã¤¿¤³¤È¤¬¤Ê¤¤¿Í¤Ç¤â¡¢¥»¥ß¥Ê¡¼½ªÎ»¸å¤Ï¼«Ê¬¤ÎÎϤÀ¤±¤Ç¥Þ¥¯¥í¤òºîÀ®¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
¤Á¤Ê¤ß¤Ë¡¢¤½¤Î¥³¡¼¥É¤Ï¡¦¡¦¡¦
Sub juryosuukei()
¡¡¡¡Dim i As Long
¡¡¡¡Dim hantei As Long
¡¡¡¡Dim gyocount As Long
¡¡¡¡gyocount = Cells(Rows.Count, 1).End(xlUp).Row
¡¡¡¡'¥½¡¼¥È¥¡¼¤Ïȯ¹Ôâ ǼÆþÆü
¡¡¡¡Range(Cells(4, 1), Cells(gyocount, 13)).Sort key1:=Range("H4"), key2:=Range("G4")
¡¡¡¡For i = gyocount To 4 Step -1
¡¡¡¡'Ʊ¤¸È¯¹Ôâ¤Î¹Ô¤¬Ê£¿ô¤¢¤Ã¤¿¤é
¡¡¡¡¡¡¡¡If Cells(i, 8) = Cells(i - 1, 8) Then
¡¡¡¡¡¡¡¡¡¡¡¡'¿ôÎ̤ò¹ç·×¤¹¤ë
¡¡¡¡¡¡¡¡¡¡¡¡Cells(i, 6) = Cells(i, 6) + Cells(i - 1, 6)
¡¡¡¡¡¡¡¡¡¡¡¡'hantei¤Ï¡¢Æ±¤¸È¯¹Ôâ¤Î¹Ô¤¬¤¢¤Ã¤¿¤«¤É¤¦¤«¤ÎȽÄê¤Ë»ÈÍÑ
¡¡¡¡¡¡¡¡¡¡¡¡hantei = hantei + 1
¡¡¡¡¡¡¡¡Else
¡¡¡¡¡¡¡¡¡¡¡¡If hantei > 0 Then
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡'½ÅÊ£¹Ô¤òºï½ü
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Range(Cells(i, 2), Cells(i, 3)).EntireRow.Delete
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡'hantei¥«¥¦¥ó¥È¥¯¥ê¥¢
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡hantei = 0
¡¡¡¡¡¡¡¡¡¡¡¡End If
¡¡¡¡¡¡¡¡End If
¡¡¡¡Next i
End Sub
¤Ç¤¹¡£°ì¿Í¤Ç¤³¤³¤Þ¤ÇºîÀ®¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
»ä¤Î¥»¥ß¥Ê¡¼¤ò¼õ¤±¤ì¤Ð¡¢ÀäÂФ˥ޥ¯¥í¤òºîÀ®¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£
¤â¤·º£¤Þ¤ÇVBA¤Î³Ø½¬¤ËºÃÀÞ¤·¤¿¤Î¤Ê¤é¡¢¤½¤ì¤Ï¶µ¤¨¤ë¿Í¤¬°¤«¤Ã¤¿¤Î¤Ç¤·¤ç¤¦¡£¤¢¤Ê¤¿¤¬¸¶°ø¤Ç¤Ï¤Ê¤¤¤Î¤Ç¡¢¤¢¤¤é¤á¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó¤è¡£
Ëü¤¬°ì¡¢»ä¤Î¥»¥ß¥Ê¡¼¤Ë½Ð¤Æ¡¢¤½¤ì¤Ç¤â¥Þ¥¯¥í¤òºîÀ®¤Ç¤¤Ê¤¤¤È¤·¤¿¤é¡¢¤½¤ì¤Ï»ä¤ÎÀÕǤ¤Ç¤¹¡£»ä¤ÏExcel¤ò¶µ¤¨¤ë¥×¥í¤Ç¤¹¤«¤é¡¢°Â¿´¤·¤Æ¤ª¤Þ¤«¤»¤¯¤À¤µ¤¤¡£
¤È¤¤¤¦¤³¤È¤Ç¡¢¥»¥ß¥Ê¡¼¤Î¾ÜºÙ¤Ï²¼µ¤ò¤´Í÷¤¯¤À¤µ¤¤¡£
http://officetanaka.net/seminar/seminar1.htm
Íè·î¤¢¤¿¤ê¤Ï¡¢Âçºå¤Ç¤â¤ä¤ê¤¿¤¤¤È»×¤Ã¤Æ¤Þ¤¹¡£
¥Ñ¥½¥³¥ó¤ò»È¤¨¤ë¡¢°Â¤¤¶µ¼¼¤òõ¤·¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¦¡¦¡¦
¤É¤³¤«¡¢¤è¤¤¶µ¼¼¤ò¤´Â¸¤¸¤ÎÊý¤Ï¡¢¤¼¤Ò¶µ¤¨¤Æ¤¯¤À¤µ¤¤¤Ê¡£
¾ì½ê¤¬¤¢¤Ã¤Æ¡¢¼õ¹ÖÀ¸¤¬½¸¤Þ¤ì¤Ð¡¢Á´¹ñ¤É¤³¤Ø¤Ç¤â»ä¤Ï¹Ô¤¤Þ¤¹¡£
2008.11.11 Tuesday
Google Docs¤ÎSpreadsheet¤¬¥ä¥Ð¥¤·ï(1)
Google Docs¤ÎSpreadsheet¤¬¤ª¤â¤·¤í¤¤¤Ç¤¹¡£
¤¢¡¢¡Ö¥ä¥Ð¥¤¡×¤Ï¤Û¤á¸ÀÍդȤ·¤Æ¤Î°ÕÌ£¤Ç¤¹¡£
Ìܻؤ¹Êý¸þÀ¤¬°ã¤¤¤Þ¤¹¤«¤é¡¢¸½ºß¤ÎExcel¤ÈÈæ³Ó¤¹¤ë¤³¤È¤Ï¤¢¤Þ¤ê°ÕÌ£¤¬¤¢¤ê¤Þ¤»¤ó¤¬¡¢¤È¤ê¤¢¤¨¤º¡¢¼ÂÁõ¤·¤Æ¤¤¤ë¥ï¡¼¥¯¥·¡¼¥È´Ø¿ô¤òÈæ³Ó¤·¤Æ¤ß¤Þ¤·¤¿¡£
¤Þ¤º¡¢Excel 2007¤Ë¤Ï¤¢¤ë¤±¤É¡¢Google Spreadsheet¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ç¤¹¡£
ï¤â»È¤ï¤Ê¤¤¤è¤¦¤Ê´Ø¿ô¤Ï¤È¤â¤«¤¯¡¢¤è¤¯»È¤¦´Ø¿ô¤Ç¤Ï
¡¦Á´³Ñ¤Îʸ»úÎó¤òȾ³Ñ¤Ë¤¹¤ëASC´Ø¿ô¤ä¡¢È¾³Ñ¢ªÁ´³Ñ¤Ë¤¹¤ëJIS´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel 2007¤ÇÄɲ䵤줿¼¡¤Î´Ø¿ô¤Ï¤Ê¤¤
¡¡¡¡AVERAGEIF
¡¡¡¡AVERAGEIFS
¡¡¡¡COUNTIFS
¡¡¡¡SUMIFS
¡¡¡¡¤¿¤À¤·¡¢IFERROR´Ø¿ô¤Ï¤¢¤ë
¡¦¤Á¤ç¤Ã¤ÈÆüì¤ÊCELL´Ø¿ô¡¢EVALUATE´Ø¿ô¡¢INFO´Ø¿ô¡¢TYPE´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel¤Î±£¤·´Ø¿ô
¡¡¡¡DATEDIF
¡¡¡¡NUMBERSTRING
¡¡¡¡¤Ï¤Ê¤¤
¡¦DSUM´Ø¿ô¤äDAVERAGE´Ø¿ô¤Ê¤É¡¢¤¤¤ï¤æ¤ëD´Ø¿ô(¥Ç¡¼¥¿¥Ù¡¼¥¹´Ø¿ô)¤Ï¤Ê¤¤
¡¦FINDB´Ø¿ô¤Ê¤É¡¢¥Ð¥¤¥Ê¥ê¤ò°·¤¦¡Ö¡ÁB´Ø¿ô¡×¤Ï¤Ê¤¤
¡¦¥Ô¥Ü¥Ã¥È¥Æ¡¼¥Ö¥ë¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³GETPIVOTDATA´Ø¿ô¤â¤Ê¤¤
¡¦¤Õ¤ê¤¬¤Êµ¡Ç½¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³PHONETIC´Ø¿ô¤â¤Ê¤¤
¡¦LOOKUP´Ø¿ô¤¬¤Ê¤¤¤Î¤Ï¡¢¤Á¤ç¤Ã¤ÈÈᤷ¤¤
¡¦SUBTOTAL´Ø¿ô¤â¤Ê¤¤¤Î¤«
¡¦DATEVALUE´Ø¿ô¤Ï¤¢¤ë¤±¤É¡¢TIMEVALUE´Ø¿ô¤Ï¤Ê¤¤
¡¦WEEKNUM´Ø¿ô¤Ï¤Ê¤¤
¡¦YEN´Ø¿ô¤â¤Ê¤¤¡£¤Ê¤¯¤Æ¤¤¤¤¤±¤É
¼Â³²¤Ï¤¢¤ê¤Þ¤»¤ó¤Í¡£ÉáÄ̤˻Ȥ¦Ê¬¤Ë¤Ï¡Ö´Ø¿ô¤¬¤Ê¤¯¤Æº¤¤ë¡×¤È¤¤¤¦¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¡£¤Ç¤¤ì¤Ð¡¢LOOKUP´Ø¿ô¤ÏÍߤ·¤«¤Ã¤¿¤±¤É¡£
µÕ¤Ë¡¢Google Spreadsheet¤Ë¤Ï¤¢¤ë¤±¤É¡¢Excel¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ï¼¡¤ÎÄ̤ꡣ
ɽ¤Îº¸Îó¤Ë¤¢¤ë¤Î¤Ï¡¢¡Ü¤ä¡¿¤Ê¤É¤Î±é»»»Ò¤ÈƱ¤¸Æ¯¤¤ò¤¹¤ë´Ø¿ô¤Ç¤¹¡£
±é»»»Ò¤¬¤¢¤ë¤«¤é¡¢ÉáÄ̤ϻȤï¤Ê¤¤¤Ç¤·¤ç¤¦¡£
±¦Îó¤Ë¤¢¤ë´Ø¿ô¤ËÃíÌܤ·¤¿¤¤¤Ç¤¹¤Í¡£
¡ÖGoogle¡Á¡×¤ä¡ÖImport¡Á¡×¤Ï¡¢¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ê¤é¤Ç¤Ï¤ÎÆüì¤Ê´Ø¿ô¤Ç¤¹¡£
¤³¤ì¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤¢¤é¤¿¤á¤Æ¤¸¤Ã¤¯¤ê¾Ò²ð¤·¤Þ¤¹¤¬¡¢¤Þ¤º¤Ï
FILTER´Ø¿ô
SORT´Ø¿ô
SPLIT´Ø¿ô
UNIQUE´Ø¿ô
¤Ç¤¹¡£¤³¤¤¤Ä¤é¤¬¡¢¼Â¤Ë¤ª¤â¤·¤í¤¤¤Ç¤¹¡£ÀµÄ¾¡¢¼¡¤ÎExcel¤Ë¤â¼ÂÁõ¤·¤ÆÍߤ·¤¤¤Ç¤¹¤Í¡£
¤Þ¤º¡¢FILTER´Ø¿ô¤«¤é¡£
¤³¤¤¤Ä¤Ï¡¢¥ê¥¹¥È¤ò¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤À·ë²Ì¤òÊÖ¤¹´Ø¿ô¤Ç¤¹¡£¹Ê¤ê¹þ¤ó¤À·ï¿ô¤¸¤ã¤¢¤ê¤Þ¤»¤ó¡£¹Ê¤ê¹þ¤ó¤À·ë²Ì¤Î¥ê¥¹¥È¤òÊÖ¤·¤Þ¤¹¡£
¤¿¤È¤¨¤Ð¡¢²¼¿Þ¤Î¤è¤¦¤Ê¥ê¥¹¥È¤¬¤¢¤Ã¤¿¤È¤·¤Þ¤¹¡£
¤³¤Î¥ê¥¹¥È¤ò¡Ö¿ôÃͤ¬10¤è¤êÂ礤¤¡×¤È¤¤¤¦¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤Ç¤ß¤Þ¤¹¡£¥»¥ëD3¤Ë¡Ö=FILTER(A2:A13,B2:B13>19)¡×¤È¤¤¤¦¼°¤òÆþÎϤ·¤Þ¤¹¡£
Enter¥¡¼¤ò²¡¤·¤Æ³ÎÄꤹ¤ë¤È
¤È¡¢¤Ê¤ê¤Þ¤¹¡£¤Ê¤ó¤È¡¢¼°¤òÆþ¤ì¤Ê¤«¤Ã¤¿¥»¥ëÈÏ°ÏD3:D7¤Ë¤â¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£Excel¤Ç¤âÇÛÎó¤òÊÖ¤¹´Ø¿ô¤Ê¤É¤ò»È¤Ã¤¿¤È¤»÷¤¿¤è¤¦¤Ê·ë²Ì¤òÆÀ¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤âÆþÎÏ»þ¤Ë¤Ï¤¢¤é¤«¤¸¤á¥»¥ëÈϰϤòÁªÂò¤·¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£¤Ç¤â¡¢FILTER´Ø¿ô¤Ï·ë²Ì¤¬²¿·ï¤Ë¤Ê¤ë¤«Æþ¤ì¤Æ¤ß¤Ê¤±¤ì¤Ð¤ï¤«¤ê¤Þ¤»¤ó¤Î¤Ç¡¢¤½¤ì¤Ï̵Íý¤Ç¤¹¤Í¡£
¤Ç¡¢¤ª¤â¤·¤í¤¤¤Î¤¬¡¢¾¡¼ê¤Ë¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤¿¥»¥ëÈÏ°ÏD3:D7¤Ç¤¹¡£¼Â¤Ï¡¢¤³¤ì¤é¤Î¥»¥ë¤Ë¤Ï¼«Æ°Åª¤ËÊ̤δؿô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡ÖCONTINUE(D2,6,1)¡×¤È¤¤¤¦¤è¤¦¤Ê´Ø¿ô¤Ç¤¹¡£Spreadsheet¤Î´Ø¿ô°ìÍ÷¤Ë¤ÏµºÜ¤µ¤ì¤Æ¤¤¤Ê¤¤´Ø¿ô¤Ç¤¹¤«¤é¡¢¤ª¤½¤é¤¯Spreadsheet¤¬¾¡¼ê¤ËÆþ¤ì¤Æ¤¯¤ì¤ë´Ø¿ô¤Ç¤·¤ç¤¦¡£¤â¤Á¤í¤ó¡¢¥æ¡¼¥¶¡¼¤¬¼êÆþÎϤ·¤Æ»È¤¦¤³¤È¤â²Äǽ¤Ç¤¹¡£Excel¤Ç¤¤¤¦¤ÈSUBTOTAL´Ø¿ô¤ß¤¿¤¤¤Ê¤â¤Î¤«¤Ê¡£
CONTINUE¤È¤¤¤¦Ì¾Á°¤È°ú¿ô¤«¤éÁÛÁü¤¹¤ë¤È¡Ö¥»¥ëD2¤ËÆþÎϤ·¤¿¿ô¼°¤Î·ë²Ì¤ò6¹Ô¡ß1Îó¤Ë³ÈÄ¥¤·¤Æɽ¼¨¤»¤è¡×Ū¤Ê´Ø¿ô¤Ê¤ó¤Ç¤·¤ç¤¦¤Í¡£¤³¤Î¾õÂ֤ǡ¢¤¿¤È¤¨¤Ð¡¢BÎó¤Î¥Ç¡¼¥¿¤òÊÔ½¸¤·¤¿¤È¤·¤Þ¤¹¡£¥»¥ëB3¤òºï½ü¤¹¤ë¤È¡¢
¤³¤Î¤è¤¦¤Ë¡¢¤Á¤ã¤ó¤ÈÈ¿±Ç¤µ¤ì¤Þ¤¹¡£¤â¤Ã¤È¤âCONTINUE´Ø¿ô¤¬¡ÖCONTINUE(D2,6,1)¡×¤È¡¢·ë²Ì¤òÊÖ¤¹¥»¥ë¿ô¤ò¸ÇÄꤷ¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢ºÇ¸å¤Î¡Ö³ºÅö¤Ê¤·¡×¤Î¥»¥ë¤Ï¡Ö--¡×¤È¤Ê¤ê¤Þ¤¹¡£¤Ç¤Ï¡¢FILTER´Ø¿ô¤Î¾ò·ï¤ËÀßÄꤷ¤¿¡ÖB2:B13>19¡×¤Ë°ìÃפ¹¤ë¥Ç¡¼¥¿¤¬Áý¤¨¤¿¾ì¹ç¤Ï¤É¤¦¤Ç¤·¤ç¤¦¡£
¡¡¡¡¢
¤È¡¢º£Å٤ϤÁ¤ã¤ó¤ÈCONTINUE´Ø¿ô¤¬³ÈÄ¥¤µ¤ì¤Þ¤¹¡£¤¦¡Á¤ó¡¢Excel¤Ç¤Ï·Ð¸³¤·¤¿¤³¤È¤Î¤Ê¤¤·ë²Ì¤Ê¤Î¤Ç¾¯¤·°ãÏ´¶¤â¤¢¤ê¤Þ¤¹¤¬¡¢¤Ê¤«¤Ê¤«¸¤¤¤Ç¤¹¡£
¤â¤Á¤í¤ó¡¢Ê£¿ô¤Î¾ò·ï¤ò»ØÄꤹ¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
º£Å٤ϡֿôÃÍ(BÎó)¤¬10¤è¤êÂ礤¤¡×¤«¤Ä¡Ö¥Õ¥é¥°(CÎó)¤¬"OK"¡×¤È¤¤¤¦¾ò·ï¤Ç¤¹¡£¤¹¤ë¤È¡¢
¤Á¤ã¤ó¤È¹Ê¤ê¹þ¤ó¤Ç¤¯¤ì¤Þ¤¹¡£¥Ø¥ë¥×¤Ë¤è¤ë¤È¾ò·ï¤Ï30¸Ä¤Þ¤Ç»ØÄê¤Ç¤¤ë¤è¤¦¤Ç¤¹¤Í¡£¿ôŪ¤Ë¤ÏÌäÂê¤Ê¤¤¤Ç¤·¤ç¤¦¡£
>If there are multiple conditions, then all must be true for the corresponding values in the source array to be returned.
¤È¤¤¤¦¤³¤È¤Ç¤¹¤«¤é¡¢»ØÄꤷ¤¿Ê£¿ô¤Î¾ò·ï¤ÏAND(¤«¤Ä)¤ÇȽÄꤵ¤ì¤ë¤è¤¦¤Ç¤¹¡£¤Ê¤ª¡¢Âè1°ú¿ô¤ËÊ£¿ôÎó¤ò»ØÄꤹ¤ì¤ÐÊ£¿ôÎó¤òÊÖ¤·¤Æ¤¯¤ì¤Þ¤¹¡£
Excel¤Ç¤â¹©Éפ¹¤ì¤ÐƱ¤¸¤³¤È¤ò¼Â¸½¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤â¤¢¤é¤«¤¸¤á·ë²Ì¤¬É½¼¨¤µ¤ì¤ë¤Ç¤¢¤í¤¦¥»¥ë¤Ë¿ô¼°¤òÆþ¤ì¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
¾¤Ë¤â¤«¤Ê¤êÊØÍø¤Ê´Ø¿ô¤¬¼ÂÁõ¤µ¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢Ä¹¤¯¤Ê¤Ã¤¿¤Î¤Çº£²ó¤Ï¤³¤³¤Þ¤Ç¡£¼¡²ó¤Ë³¤¤Þ¤¹¡¦¡¦¡¦
¤¢¡¢¡Ö¥ä¥Ð¥¤¡×¤Ï¤Û¤á¸ÀÍդȤ·¤Æ¤Î°ÕÌ£¤Ç¤¹¡£
Ìܻؤ¹Êý¸þÀ¤¬°ã¤¤¤Þ¤¹¤«¤é¡¢¸½ºß¤ÎExcel¤ÈÈæ³Ó¤¹¤ë¤³¤È¤Ï¤¢¤Þ¤ê°ÕÌ£¤¬¤¢¤ê¤Þ¤»¤ó¤¬¡¢¤È¤ê¤¢¤¨¤º¡¢¼ÂÁõ¤·¤Æ¤¤¤ë¥ï¡¼¥¯¥·¡¼¥È´Ø¿ô¤òÈæ³Ó¤·¤Æ¤ß¤Þ¤·¤¿¡£
¤Þ¤º¡¢Excel 2007¤Ë¤Ï¤¢¤ë¤±¤É¡¢Google Spreadsheet¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ç¤¹¡£
|
ï¤â»È¤ï¤Ê¤¤¤è¤¦¤Ê´Ø¿ô¤Ï¤È¤â¤«¤¯¡¢¤è¤¯»È¤¦´Ø¿ô¤Ç¤Ï
¡¦Á´³Ñ¤Îʸ»úÎó¤òȾ³Ñ¤Ë¤¹¤ëASC´Ø¿ô¤ä¡¢È¾³Ñ¢ªÁ´³Ñ¤Ë¤¹¤ëJIS´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel 2007¤ÇÄɲ䵤줿¼¡¤Î´Ø¿ô¤Ï¤Ê¤¤
¡¡¡¡AVERAGEIF
¡¡¡¡AVERAGEIFS
¡¡¡¡COUNTIFS
¡¡¡¡SUMIFS
¡¡¡¡¤¿¤À¤·¡¢IFERROR´Ø¿ô¤Ï¤¢¤ë
¡¦¤Á¤ç¤Ã¤ÈÆüì¤ÊCELL´Ø¿ô¡¢EVALUATE´Ø¿ô¡¢INFO´Ø¿ô¡¢TYPE´Ø¿ô¤Ï¤Ê¤¤
¡¦Excel¤Î±£¤·´Ø¿ô
¡¡¡¡DATEDIF
¡¡¡¡NUMBERSTRING
¡¡¡¡¤Ï¤Ê¤¤
¡¦DSUM´Ø¿ô¤äDAVERAGE´Ø¿ô¤Ê¤É¡¢¤¤¤ï¤æ¤ëD´Ø¿ô(¥Ç¡¼¥¿¥Ù¡¼¥¹´Ø¿ô)¤Ï¤Ê¤¤
¡¦FINDB´Ø¿ô¤Ê¤É¡¢¥Ð¥¤¥Ê¥ê¤ò°·¤¦¡Ö¡ÁB´Ø¿ô¡×¤Ï¤Ê¤¤
¡¦¥Ô¥Ü¥Ã¥È¥Æ¡¼¥Ö¥ë¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³GETPIVOTDATA´Ø¿ô¤â¤Ê¤¤
¡¦¤Õ¤ê¤¬¤Êµ¡Ç½¤¬¤Ê¤¤¤Î¤À¤«¤é¡¢ÅöÁ³PHONETIC´Ø¿ô¤â¤Ê¤¤
¡¦LOOKUP´Ø¿ô¤¬¤Ê¤¤¤Î¤Ï¡¢¤Á¤ç¤Ã¤ÈÈᤷ¤¤
¡¦SUBTOTAL´Ø¿ô¤â¤Ê¤¤¤Î¤«
¡¦DATEVALUE´Ø¿ô¤Ï¤¢¤ë¤±¤É¡¢TIMEVALUE´Ø¿ô¤Ï¤Ê¤¤
¡¦WEEKNUM´Ø¿ô¤Ï¤Ê¤¤
¡¦YEN´Ø¿ô¤â¤Ê¤¤¡£¤Ê¤¯¤Æ¤¤¤¤¤±¤É
¼Â³²¤Ï¤¢¤ê¤Þ¤»¤ó¤Í¡£ÉáÄ̤˻Ȥ¦Ê¬¤Ë¤Ï¡Ö´Ø¿ô¤¬¤Ê¤¯¤Æº¤¤ë¡×¤È¤¤¤¦¤³¤È¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¡£¤Ç¤¤ì¤Ð¡¢LOOKUP´Ø¿ô¤ÏÍߤ·¤«¤Ã¤¿¤±¤É¡£
µÕ¤Ë¡¢Google Spreadsheet¤Ë¤Ï¤¢¤ë¤±¤É¡¢Excel¤Ë¤Ï¤Ê¤¤´Ø¿ô¤Ï¼¡¤ÎÄ̤ꡣ
|
ɽ¤Îº¸Îó¤Ë¤¢¤ë¤Î¤Ï¡¢¡Ü¤ä¡¿¤Ê¤É¤Î±é»»»Ò¤ÈƱ¤¸Æ¯¤¤ò¤¹¤ë´Ø¿ô¤Ç¤¹¡£
±é»»»Ò¤¬¤¢¤ë¤«¤é¡¢ÉáÄ̤ϻȤï¤Ê¤¤¤Ç¤·¤ç¤¦¡£
±¦Îó¤Ë¤¢¤ë´Ø¿ô¤ËÃíÌܤ·¤¿¤¤¤Ç¤¹¤Í¡£
¡ÖGoogle¡Á¡×¤ä¡ÖImport¡Á¡×¤Ï¡¢¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ê¤é¤Ç¤Ï¤ÎÆüì¤Ê´Ø¿ô¤Ç¤¹¡£
¤³¤ì¤Ë¤Ä¤¤¤Æ¤Ï¡¢¤¢¤é¤¿¤á¤Æ¤¸¤Ã¤¯¤ê¾Ò²ð¤·¤Þ¤¹¤¬¡¢¤Þ¤º¤Ï
FILTER´Ø¿ô
SORT´Ø¿ô
SPLIT´Ø¿ô
UNIQUE´Ø¿ô
¤Ç¤¹¡£¤³¤¤¤Ä¤é¤¬¡¢¼Â¤Ë¤ª¤â¤·¤í¤¤¤Ç¤¹¡£ÀµÄ¾¡¢¼¡¤ÎExcel¤Ë¤â¼ÂÁõ¤·¤ÆÍߤ·¤¤¤Ç¤¹¤Í¡£
¤Þ¤º¡¢FILTER´Ø¿ô¤«¤é¡£
¤³¤¤¤Ä¤Ï¡¢¥ê¥¹¥È¤ò¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤À·ë²Ì¤òÊÖ¤¹´Ø¿ô¤Ç¤¹¡£¹Ê¤ê¹þ¤ó¤À·ï¿ô¤¸¤ã¤¢¤ê¤Þ¤»¤ó¡£¹Ê¤ê¹þ¤ó¤À·ë²Ì¤Î¥ê¥¹¥È¤òÊÖ¤·¤Þ¤¹¡£
¤¿¤È¤¨¤Ð¡¢²¼¿Þ¤Î¤è¤¦¤Ê¥ê¥¹¥È¤¬¤¢¤Ã¤¿¤È¤·¤Þ¤¹¡£
¤³¤Î¥ê¥¹¥È¤ò¡Ö¿ôÃͤ¬10¤è¤êÂ礤¤¡×¤È¤¤¤¦¾ò·ï¤Ç¹Ê¤ê¹þ¤ó¤Ç¤ß¤Þ¤¹¡£¥»¥ëD3¤Ë¡Ö=FILTER(A2:A13,B2:B13>19)¡×¤È¤¤¤¦¼°¤òÆþÎϤ·¤Þ¤¹¡£
Enter¥¡¼¤ò²¡¤·¤Æ³ÎÄꤹ¤ë¤È
¤È¡¢¤Ê¤ê¤Þ¤¹¡£¤Ê¤ó¤È¡¢¼°¤òÆþ¤ì¤Ê¤«¤Ã¤¿¥»¥ëÈÏ°ÏD3:D7¤Ë¤â¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£Excel¤Ç¤âÇÛÎó¤òÊÖ¤¹´Ø¿ô¤Ê¤É¤ò»È¤Ã¤¿¤È¤»÷¤¿¤è¤¦¤Ê·ë²Ì¤òÆÀ¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤âÆþÎÏ»þ¤Ë¤Ï¤¢¤é¤«¤¸¤á¥»¥ëÈϰϤòÁªÂò¤·¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£¤Ç¤â¡¢FILTER´Ø¿ô¤Ï·ë²Ì¤¬²¿·ï¤Ë¤Ê¤ë¤«Æþ¤ì¤Æ¤ß¤Ê¤±¤ì¤Ð¤ï¤«¤ê¤Þ¤»¤ó¤Î¤Ç¡¢¤½¤ì¤Ï̵Íý¤Ç¤¹¤Í¡£
¤Ç¡¢¤ª¤â¤·¤í¤¤¤Î¤¬¡¢¾¡¼ê¤Ë¥Ç¡¼¥¿¤¬É½¼¨¤µ¤ì¤¿¥»¥ëÈÏ°ÏD3:D7¤Ç¤¹¡£¼Â¤Ï¡¢¤³¤ì¤é¤Î¥»¥ë¤Ë¤Ï¼«Æ°Åª¤ËÊ̤δؿô¤¬ÆþÎϤµ¤ì¤Æ¤¤¤Þ¤¹¡£
¡ÖCONTINUE(D2,6,1)¡×¤È¤¤¤¦¤è¤¦¤Ê´Ø¿ô¤Ç¤¹¡£Spreadsheet¤Î´Ø¿ô°ìÍ÷¤Ë¤ÏµºÜ¤µ¤ì¤Æ¤¤¤Ê¤¤´Ø¿ô¤Ç¤¹¤«¤é¡¢¤ª¤½¤é¤¯Spreadsheet¤¬¾¡¼ê¤ËÆþ¤ì¤Æ¤¯¤ì¤ë´Ø¿ô¤Ç¤·¤ç¤¦¡£¤â¤Á¤í¤ó¡¢¥æ¡¼¥¶¡¼¤¬¼êÆþÎϤ·¤Æ»È¤¦¤³¤È¤â²Äǽ¤Ç¤¹¡£Excel¤Ç¤¤¤¦¤ÈSUBTOTAL´Ø¿ô¤ß¤¿¤¤¤Ê¤â¤Î¤«¤Ê¡£
CONTINUE¤È¤¤¤¦Ì¾Á°¤È°ú¿ô¤«¤éÁÛÁü¤¹¤ë¤È¡Ö¥»¥ëD2¤ËÆþÎϤ·¤¿¿ô¼°¤Î·ë²Ì¤ò6¹Ô¡ß1Îó¤Ë³ÈÄ¥¤·¤Æɽ¼¨¤»¤è¡×Ū¤Ê´Ø¿ô¤Ê¤ó¤Ç¤·¤ç¤¦¤Í¡£¤³¤Î¾õÂ֤ǡ¢¤¿¤È¤¨¤Ð¡¢BÎó¤Î¥Ç¡¼¥¿¤òÊÔ½¸¤·¤¿¤È¤·¤Þ¤¹¡£¥»¥ëB3¤òºï½ü¤¹¤ë¤È¡¢
¤³¤Î¤è¤¦¤Ë¡¢¤Á¤ã¤ó¤ÈÈ¿±Ç¤µ¤ì¤Þ¤¹¡£¤â¤Ã¤È¤âCONTINUE´Ø¿ô¤¬¡ÖCONTINUE(D2,6,1)¡×¤È¡¢·ë²Ì¤òÊÖ¤¹¥»¥ë¿ô¤ò¸ÇÄꤷ¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢ºÇ¸å¤Î¡Ö³ºÅö¤Ê¤·¡×¤Î¥»¥ë¤Ï¡Ö--¡×¤È¤Ê¤ê¤Þ¤¹¡£¤Ç¤Ï¡¢FILTER´Ø¿ô¤Î¾ò·ï¤ËÀßÄꤷ¤¿¡ÖB2:B13>19¡×¤Ë°ìÃפ¹¤ë¥Ç¡¼¥¿¤¬Áý¤¨¤¿¾ì¹ç¤Ï¤É¤¦¤Ç¤·¤ç¤¦¡£
¡¡¡¡¢
¤È¡¢º£Å٤ϤÁ¤ã¤ó¤ÈCONTINUE´Ø¿ô¤¬³ÈÄ¥¤µ¤ì¤Þ¤¹¡£¤¦¡Á¤ó¡¢Excel¤Ç¤Ï·Ð¸³¤·¤¿¤³¤È¤Î¤Ê¤¤·ë²Ì¤Ê¤Î¤Ç¾¯¤·°ãÏ´¶¤â¤¢¤ê¤Þ¤¹¤¬¡¢¤Ê¤«¤Ê¤«¸¤¤¤Ç¤¹¡£
¤â¤Á¤í¤ó¡¢Ê£¿ô¤Î¾ò·ï¤ò»ØÄꤹ¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
º£Å٤ϡֿôÃÍ(BÎó)¤¬10¤è¤êÂ礤¤¡×¤«¤Ä¡Ö¥Õ¥é¥°(CÎó)¤¬"OK"¡×¤È¤¤¤¦¾ò·ï¤Ç¤¹¡£¤¹¤ë¤È¡¢
¤Á¤ã¤ó¤È¹Ê¤ê¹þ¤ó¤Ç¤¯¤ì¤Þ¤¹¡£¥Ø¥ë¥×¤Ë¤è¤ë¤È¾ò·ï¤Ï30¸Ä¤Þ¤Ç»ØÄê¤Ç¤¤ë¤è¤¦¤Ç¤¹¤Í¡£¿ôŪ¤Ë¤ÏÌäÂê¤Ê¤¤¤Ç¤·¤ç¤¦¡£
>If there are multiple conditions, then all must be true for the corresponding values in the source array to be returned.
¤È¤¤¤¦¤³¤È¤Ç¤¹¤«¤é¡¢»ØÄꤷ¤¿Ê£¿ô¤Î¾ò·ï¤ÏAND(¤«¤Ä)¤ÇȽÄꤵ¤ì¤ë¤è¤¦¤Ç¤¹¡£¤Ê¤ª¡¢Âè1°ú¿ô¤ËÊ£¿ôÎó¤ò»ØÄꤹ¤ì¤ÐÊ£¿ôÎó¤òÊÖ¤·¤Æ¤¯¤ì¤Þ¤¹¡£
Excel¤Ç¤â¹©Éפ¹¤ì¤ÐƱ¤¸¤³¤È¤ò¼Â¸½¤Ç¤¤Þ¤¹¤¬¡¢¤½¤ì¤Ë¤·¤Æ¤â¤¢¤é¤«¤¸¤á·ë²Ì¤¬É½¼¨¤µ¤ì¤ë¤Ç¤¢¤í¤¦¥»¥ë¤Ë¿ô¼°¤òÆþ¤ì¤Æ¤ª¤«¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
¾¤Ë¤â¤«¤Ê¤êÊØÍø¤Ê´Ø¿ô¤¬¼ÂÁõ¤µ¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢Ä¹¤¯¤Ê¤Ã¤¿¤Î¤Çº£²ó¤Ï¤³¤³¤Þ¤Ç¡£¼¡²ó¤Ë³¤¤Þ¤¹¡¦¡¦¡¦
2008.10.10 Friday
¥¿¥¤¥ß¥ó¥°
¤Á¤ç¤Ã¤È»ö¾ð¤¬¤¢¤Ã¤Æ¡¢¤³¤³¤Î¤È¤³¤í¡¢¼Â²È¤Î·»¤È¤Ò¤ó¤Ñ¤ó¤Ë²ñ¤Ã¤Æ¤¤¤Þ¤¹¡£
ÀèÆü¡¢¤½¤Î·»¤«¤é¡ÖBlu-ray Disc¤ò¸«¤Æ¤ß¤¿¤¤¤«¤é¥×¥ì¥¤¥ä¡¼¤òÇ㤦¡×¤È¤¤¤¦Ïäòʹ¤¤Þ¤·¤¿¡£
¤Ç¡¢¸õÊä¤Ë·è¤á¤¿¤Î¤¬PS3¡£¤Ê¤ë¤Û¤É¡¢PS3¤Ê¤é¥²¡¼¥à¤â³Ú¤·¤á¤Þ¤¹¤·¤Í¡£
¤Ê¤ó¤ÆÏäòʹ¤¤¤¿¤Î¤¬¡¢¤Ä¤¤ÀèÆü¤Î10·î6Æü¡£
¤Þ¤¡¡¢¸À¤Ã¤Æ¤ß¤ì¤Ð"¿Í¤´¤È"¤Ê¤Î¤Ç(^^; ¡Ö¤Õ¡Á¤ó¡¢¤½¤¦¤Ê¤ó¤À¡×ÄøÅÙ¤Ëʹ¤¤¤Æ¤¤¤Þ¤·¤¿¡£
2Æü¸å¤Î8Æü¡£¥Ê¥Ë¥²¤Ë¥Í¥Ã¥È¤Î¾ðÊó¤òµù¤Ã¤Æ¤¤¤ë¤È¡¢¼¡¤Î¤è¤¦¤Êµ»ö¤òȯ¸«¡£
¢£¥½¥Ë¡¼¤¬¤¤¤è¤¤¤èÌÀÆü¤Ë¿··¿PS3¤òȯɽ¤«¡¢¾®Ç䏤«¤é¤âºß¸Ë¾ÃÌÇ - GIGAZINE
http://gigazine.net/index.php?/news/comments/20081008_ps3_new/
¤¢¤¢¡¢¤Ê¤ë¤Û¤É¡£·»¤Ï¥³¥ì¤òÁÀ¤Ã¤Æ¤¤¤ë¤Î¤«¤È¡£
¤Õ¤à¤Õ¤à¡¢¤â¤¦¤½¤í¤½¤í»Ô¾ì¤«¤éºß¸Ë¤â¸º¤Ã¤Æ¤¤¤ë¤Î¤«¤È¡£
¤Ê¤ó¤Æ»×¤¤¤Ê¤¬¤é¡¢ºòÆü¤Î9Æü¤Ë²ñ¤Ã¤¿¤é¡ÖPS3¤òÇã¤Ã¤¿¤è¡×¤È¡£
¤Ø¡©¤â¤¦½Ð¤¿¤Î¡©¿··¿PS3¡£¤Æ¤«¡¢¤Þ¤À"ȯɽ¤«¡©"¤Ã¤ÆÃʳ¬¤À¤Ã¤¿¤Î¤Ç¤Ï¡©
¤¨¡©¤Þ¤µ¤«¡¢Çã¤Ã¤¿¤Î¤Ã¤Æ¡¢µì·¿¡©
¡¦¡¦¡¦¤À¤½¤¦¤Ç¤¹(^^; ¿··¿¤¬½Ð¤ë¤³¤È¤Ï¡¢¤Þ¤Ã¤¿¤¯ÃΤé¤Ê¤«¤Ã¤¿¤é¤·¤¤¤Ç¤¹¡£
¤É¤¦¤ê¤Ç¡¢¶á½ê¤Î¥·¥ç¥Ã¥×¤òõ¤·¤Æ¤â¡¢ºß¸Ë¤¬¤Ê¤¯¤Æº¤¤Ã¤¿¤½¤¦¤Ç¤¹¡£
Ź°÷¤â°ì¸À¤¯¤é¤¤¸À¤Ã¤Æ¤¯¤ì¤Æ¤â¤¤¤¤¤Î¤Ë¡£
¤¢¡¢¤½¤ì¤¸¤ãºß¸Ë¤¬½èʬ¤Ç¤¤Ê¤¤¤«¡£
¤½¤·¤Æ¤È¤¦¤È¤¦
¢£¥½¥Ë¡¼¤¬¿··¿PS3¤òÀµ¼°È¯É½¡¢HDDÍÆÎÌ2ÇܤÇDUALSHOCK3¤Ê¤É¤òƱº¡¢Äã¾ÃÈñÅÅÎϤâ - GIGAZINE
http://gigazine.net/index.php?/news/comments/20081009_ps3_80gb/
¤¢¤¢¡¢¿Í¤´¤È¤È¤Ï¸À¤¨¡¢¥¿¥¤¥ß¥ó¥°¤¬°¤«¤Ã¤¿¤Ç¤¹¤Í¡ä·»
¤·¤«¤âµ»ö¤Ë¤è¤ë¤È
>¤½¤·¤Æ¿··¿¤ÎȯÇä¤Ë¹ç¤ï¤»¤Æ½¾Íè¤Î40GB¥â¥Ç¥ë¤Ï10·î10Æü¡Ê¶â¡Ë¤«¤é¥ª¡¼¥×¥ó²Á³Ê¤Ë²þÄꤵ¤ì¤ë¤Û¤«¡¢¡Ö¥ê¥È¥ë¥Ó¥Ã¥°¥×¥é¥Í¥Ã¥È¡×¥½¥Õ¥ÈñÂΤȥ磻¥ä¥ì¥¹¥³¥ó¥È¥í¡¼¥é¡ÖDUALSHOCK3¡×¤òÁȤ߹ç¤ï¤»¤¿¡Ö¥ê¥È¥ë¥Ó¥Ã¥°¥×¥é¥Í¥Ã¥È DUALSHOCK3 ƱºÈǡפ¬¿ôÎ̸ÂÄê¤Ç10·î30Æü¤«¤é7980±ß¤ÇȯÇ䤵¤ì¤ë¤È¤·¤Æ¤¤¤Þ¤¹
Ó˸ơ¦¡¦¡¦°Ö¤á¤Î¸ÀÍÕ¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡¦¡¦¡¦
ÀèÆü¡¢¤½¤Î·»¤«¤é¡ÖBlu-ray Disc¤ò¸«¤Æ¤ß¤¿¤¤¤«¤é¥×¥ì¥¤¥ä¡¼¤òÇ㤦¡×¤È¤¤¤¦Ïäòʹ¤¤Þ¤·¤¿¡£
¤Ç¡¢¸õÊä¤Ë·è¤á¤¿¤Î¤¬PS3¡£¤Ê¤ë¤Û¤É¡¢PS3¤Ê¤é¥²¡¼¥à¤â³Ú¤·¤á¤Þ¤¹¤·¤Í¡£
¤Ê¤ó¤ÆÏäòʹ¤¤¤¿¤Î¤¬¡¢¤Ä¤¤ÀèÆü¤Î10·î6Æü¡£
¤Þ¤¡¡¢¸À¤Ã¤Æ¤ß¤ì¤Ð"¿Í¤´¤È"¤Ê¤Î¤Ç(^^; ¡Ö¤Õ¡Á¤ó¡¢¤½¤¦¤Ê¤ó¤À¡×ÄøÅÙ¤Ëʹ¤¤¤Æ¤¤¤Þ¤·¤¿¡£
2Æü¸å¤Î8Æü¡£¥Ê¥Ë¥²¤Ë¥Í¥Ã¥È¤Î¾ðÊó¤òµù¤Ã¤Æ¤¤¤ë¤È¡¢¼¡¤Î¤è¤¦¤Êµ»ö¤òȯ¸«¡£
¢£¥½¥Ë¡¼¤¬¤¤¤è¤¤¤èÌÀÆü¤Ë¿··¿PS3¤òȯɽ¤«¡¢¾®Ç䏤«¤é¤âºß¸Ë¾ÃÌÇ - GIGAZINE
http://gigazine.net/index.php?/news/comments/20081008_ps3_new/
¤¢¤¢¡¢¤Ê¤ë¤Û¤É¡£·»¤Ï¥³¥ì¤òÁÀ¤Ã¤Æ¤¤¤ë¤Î¤«¤È¡£
¤Õ¤à¤Õ¤à¡¢¤â¤¦¤½¤í¤½¤í»Ô¾ì¤«¤éºß¸Ë¤â¸º¤Ã¤Æ¤¤¤ë¤Î¤«¤È¡£
¤Ê¤ó¤Æ»×¤¤¤Ê¤¬¤é¡¢ºòÆü¤Î9Æü¤Ë²ñ¤Ã¤¿¤é¡ÖPS3¤òÇã¤Ã¤¿¤è¡×¤È¡£
¤Ø¡©¤â¤¦½Ð¤¿¤Î¡©¿··¿PS3¡£¤Æ¤«¡¢¤Þ¤À"ȯɽ¤«¡©"¤Ã¤ÆÃʳ¬¤À¤Ã¤¿¤Î¤Ç¤Ï¡©
¤¨¡©¤Þ¤µ¤«¡¢Çã¤Ã¤¿¤Î¤Ã¤Æ¡¢µì·¿¡©
¡¦¡¦¡¦¤À¤½¤¦¤Ç¤¹(^^; ¿··¿¤¬½Ð¤ë¤³¤È¤Ï¡¢¤Þ¤Ã¤¿¤¯ÃΤé¤Ê¤«¤Ã¤¿¤é¤·¤¤¤Ç¤¹¡£
¤É¤¦¤ê¤Ç¡¢¶á½ê¤Î¥·¥ç¥Ã¥×¤òõ¤·¤Æ¤â¡¢ºß¸Ë¤¬¤Ê¤¯¤Æº¤¤Ã¤¿¤½¤¦¤Ç¤¹¡£
Ź°÷¤â°ì¸À¤¯¤é¤¤¸À¤Ã¤Æ¤¯¤ì¤Æ¤â¤¤¤¤¤Î¤Ë¡£
¤¢¡¢¤½¤ì¤¸¤ãºß¸Ë¤¬½èʬ¤Ç¤¤Ê¤¤¤«¡£
¤½¤·¤Æ¤È¤¦¤È¤¦
¢£¥½¥Ë¡¼¤¬¿··¿PS3¤òÀµ¼°È¯É½¡¢HDDÍÆÎÌ2ÇܤÇDUALSHOCK3¤Ê¤É¤òƱº¡¢Äã¾ÃÈñÅÅÎϤâ - GIGAZINE
http://gigazine.net/index.php?/news/comments/20081009_ps3_80gb/
¤¢¤¢¡¢¿Í¤´¤È¤È¤Ï¸À¤¨¡¢¥¿¥¤¥ß¥ó¥°¤¬°¤«¤Ã¤¿¤Ç¤¹¤Í¡ä·»
¤·¤«¤âµ»ö¤Ë¤è¤ë¤È
>¤½¤·¤Æ¿··¿¤ÎȯÇä¤Ë¹ç¤ï¤»¤Æ½¾Íè¤Î40GB¥â¥Ç¥ë¤Ï10·î10Æü¡Ê¶â¡Ë¤«¤é¥ª¡¼¥×¥ó²Á³Ê¤Ë²þÄꤵ¤ì¤ë¤Û¤«¡¢¡Ö¥ê¥È¥ë¥Ó¥Ã¥°¥×¥é¥Í¥Ã¥È¡×¥½¥Õ¥ÈñÂΤȥ磻¥ä¥ì¥¹¥³¥ó¥È¥í¡¼¥é¡ÖDUALSHOCK3¡×¤òÁȤ߹ç¤ï¤»¤¿¡Ö¥ê¥È¥ë¥Ó¥Ã¥°¥×¥é¥Í¥Ã¥È DUALSHOCK3 ƱºÈǡפ¬¿ôÎ̸ÂÄê¤Ç10·î30Æü¤«¤é7980±ß¤ÇȯÇ䤵¤ì¤ë¤È¤·¤Æ¤¤¤Þ¤¹
Ó˸ơ¦¡¦¡¦°Ö¤á¤Î¸ÀÍÕ¤¬¸«¤Ä¤«¤ê¤Þ¤»¤ó¡¦¡¦¡¦
2008.08.21 Thursday
¥È¥é¥¤¥¢¥¹¥í¥ó
¤Ò¤È¤ê¤ÎÁª¼ê¤¬¡¦¿å±Ë¡¦¼«Å¾¼Ö¡¦¥é¥ó¥Ë¥ó¥°¤Î3¼ïÌܤò¹Ô¤¦¶¥µ»¤È¤¤¤¨¤Ð¡¢Í̾¤Ê¥È¥é¥¤¥¢¥¹¥í¥ó¤Ç¤¹¡£¥È¥é¥¤¥¢¥¹¥í¥ó¤Ë¤Ï¤¤¤í¤¤¤í¤Ê¼ïÎब¤¢¤ê¡¢¤½¤ÎÃæ¤Î¥¢¥¤¥¢¥ó¥Þ¥ó¤È¤â¤Ê¤ì¤Ð¡¢¿å±Ë3.8Km¡¦¼«Å¾¼Ö180Km¡¦¥é¥ó¥Ë¥ó¥°42.195Km¤È¤¤¤¦µ÷Î¥¡£ºÇ¸å¤Î¥é¥ó¥Ë¥ó¥°¤Ê¤ó¤Æ¡¢¥Õ¥ë¥Þ¥é¥½¥ó¤¸¤ã¤Ê¤¤¤Ç¤¹¤«¡£¤³¤ì¤òϢ³¤Ç¤³¤Ê¤¹¤È¤Ï¡¢¤Þ¤µ¤Ë¥¢¥¤¥¢¥ó¥Þ¥ó¡£
¥È¥é¥¤¥¢¥¹¥í¥ó¤È¤¤¤¦¶¥µ»Ì¾¤¸¤¿¤¤¤Ï¡¢¤º¤¤¤Ö¤óÀΤ«¤éÃΤäƤ¤¤Þ¤·¤¿¤¬¡¢²¿¤È¤Ê¤¯¸ì¸»¤«¤é¡Ö¥È¥é¥¤ = Try = Ä©Àï¡×¤Ã¤Æ°ÕÌ£¤Ç¡¢²¿¤«¤³¤¦¡¢¿Í´Ö¤Î¸Â³¦¤ËÄ©À魯¤ë¤è¤¦¤Ê¶¥µ»¤«¤È»×¤Ã¤Æ¤Þ¤·¤¿¡£
¤Ç¡¢ºÇ¶áË̵þ¥ª¥ê¥ó¥Ô¥Ã¥¯¤¬¹Ô¤ï¤ì¤Æ¤¤¤ë¤³¤È¤«¤é¡¢¥Ê¥Ë¥²¤Ë¶áÂå¸Þ¼ï¤Ë¤Ä¤¤¤ÆÄ´¤Ù¤Æ¤ß¤Þ¤·¤¿¡£¸Þ¼ï¤Ã¤Æ¡¢²¿¤ò¤ä¤ë¤ó¤À¤í¤¦¤Ã¤Æ¡£¶áÂå¸Þ¼ï¤Ï¡¢¼Í·â¡¦¥Õ¥§¥ó¥·¥ó¥°¡¦¿å±Ë¡¦ÇϽѡ¦¥é¥ó¥Ë¥ó¥°¤ò¤Ò¤È¤ê¤Ç¤³¤Ê¤¹¶¥µ»¤é¤·¤¤¤Ç¤¹¤¬¡¢µ¤¤Ë¤Ê¤Ã¤¿¤Î¤Ï±Ñ¸ìɽµ¡£¥Ú¥ó¥¿¥¹¥í¥ó¤È¸À¤¦¤Î¤À¤½¤¦¤Ç¤¹¡£
¤¢¡ª¡¦¡¦¡¦¤â¤·¤«¤·¤Æ¡¦¡¦¡¦
¥Ú¥ó¥¿¥¹¥í¥ó¤Î¥Ú¥ó¥¿¤Ï¡¢¤É¤¦¹Í¤¨¤Æ¤â¥Ú¥ó¥¿¥´¥ó¤Ê¤É¡Ö5¡×¤È¤¤¤¦°ÕÌ£¤Ç¤·¤ç¤¦¡£¤Á¤Ê¤ß¤Ë¥®¥ê¥·¥ã¸ì¤À¤½¤¦¤Ç¤¹¡£¤À¤«¤é¸Þ¼ï¶¥µ»¤¬¥Ú¥ó¥¿¥¹¥í¥ó¡£¤Æ¤³¤È¤Ï¡¢¥È¥é¥¤¥¢¥¹¥í¥ó¤Î¥È¥é¥¤¤â¡£¤½¤¦¤¤¤¨¤Ð»°³Ñ·Á¤Î¤³¤È¤ò¥È¥é¥¤¥¢¥ó¥°¥ë¤Ê¤ó¤Æ¸À¤¦¤·¤Ê¡£»°¼ïÎà¤Î¶¥µ»¤ò¤¹¤ë¤«¤é¥®¥ê¥·¥ã¸ì¤Î¡Ö3¡×¤ò°ÕÌ£¤¹¤ëtri¤Ë¡Ö¶¥µ»¡×¤Îathlon¤Ç¥È¥é¥¤¥¢¥¹¥í¥ó¤«¡£¤½¤Ã¤«¡£
¤½¤¦¤¤¤¨¤Ð¡¢Åßµ¨¥ª¥ê¥ó¥Ô¥Ã¥¯¤Ç¥Ð¥¤¥¢¥¹¥í¥ó¤Æ¶¥µ»¤¬¤¢¤Ã¤¿¤Ã¤±¡£¤â¤Á¤í¤ó¤³¤ì¤â¡¢¥®¥ê¥·¥ã¸ì¤Ç¡Ö2¤Ä¡×¤ò°ÕÌ£¤¹¤ëbi¤Ë¥¢¥¹¥í¥ó¤Ç¥Ð¥¤¥¢¥¹¥í¥ó¡£¥Ð¥¤¥ê¥ó¥¬¥ë¤È¤«¸À¤¦¤·¤Ê¡£¥¯¥í¥¹¥«¥ó¥È¥ê¡¼¥¹¥¡¼¤È¥é¥¤¥Õ¥ë¼Í·â¤Î2¼ïÌܤò¤Ò¤È¤ê¤ÎÁª¼ê¤¬¶¥¤¦¶¥µ»¤Ç¤¹¡£
Ä´¤Ù¤Æ¤ß¤ë¤È¡¢¤Þ¤À¤¢¤ê¤Þ¤·¤¿¡£
100m¥Ï¡¼¥É¥ë¡¦Áö¹âÄ·¡¦Ë¤´ÝÅꡦ200Áö¡¦ÁöÉýÄ·¡¦¤ä¤êÅꡦ800Áö¤Î¼·¼ï¶¥µ»(¥Ø¥×¥¿¥¹¥í¥ó)
100mÁö¡¦ÁöÉýÄ·¡¦Ë¤´ÝÅꡦÁö¹âÄ·¡¦400mÁö¡¦110m¥Ï¡¼¥É¥ë¡¦±ßÈ×ÅꡦËÀ¹âÄ·¡¦¤ä¤êÅꡦ1500Áö¤Î½½¼ï¶¥µ»(¥Ç¥«¥¹¥í¥ó)
100mÁö¡¦ÁöÉýÄ·¡¦200m¥Ï¡¼¥É¥ë¡¦Ë¤´ÝÅꡦ5000mÁö¡¦800mÁö¡¦Áö¹âÄ·¡¦400mÁö¡¦¥Ï¥ó¥Þ¡¼Åꡦ3000m¾ã³²Áö¡¦110m¥Ï¡¼¥É¥ë¡¦±ßÈ×Åꡦ200mÁö¡¦ËÀ¹âÄ·¡¦3000mÁö¡¦400m¥Ï¡¼¥É¥ë¡¦¤ä¤êÅꡦ1500mÁö¡¦»°ÃÊÄ·¡¦10000mÁö¤ÎÆ󽽼ﶥµ»(¥¢¥¤¥³¥µ¥¹¥í¥ó)
¤Þ¤ë¤Ç¡¢¤Ò¤È¤ê±¿Æ°²ñ¤Ç¤¹¤Í¡£¤É¤¦¤ä¤Ã¤ÆÎý½¬¤¹¤ë¤ó¤Ç¤·¤ç¤¦¤«¡£
¤Á¤Ê¤ß¤Ë¥¢¥¤¥³¥µ¥¹¥í¥ó¤Ï¡¢Ã˻ҤȽ÷»Ò¤Ç¼ïÌܤ¬°Û¤Ê¤ë¤½¤¦¤Ç¤¹¡£
¥È¥é¥¤¥¢¥¹¥í¥ó¤È¤¤¤¦¶¥µ»Ì¾¤¸¤¿¤¤¤Ï¡¢¤º¤¤¤Ö¤óÀΤ«¤éÃΤäƤ¤¤Þ¤·¤¿¤¬¡¢²¿¤È¤Ê¤¯¸ì¸»¤«¤é¡Ö¥È¥é¥¤ = Try = Ä©Àï¡×¤Ã¤Æ°ÕÌ£¤Ç¡¢²¿¤«¤³¤¦¡¢¿Í´Ö¤Î¸Â³¦¤ËÄ©À魯¤ë¤è¤¦¤Ê¶¥µ»¤«¤È»×¤Ã¤Æ¤Þ¤·¤¿¡£
¤Ç¡¢ºÇ¶áË̵þ¥ª¥ê¥ó¥Ô¥Ã¥¯¤¬¹Ô¤ï¤ì¤Æ¤¤¤ë¤³¤È¤«¤é¡¢¥Ê¥Ë¥²¤Ë¶áÂå¸Þ¼ï¤Ë¤Ä¤¤¤ÆÄ´¤Ù¤Æ¤ß¤Þ¤·¤¿¡£¸Þ¼ï¤Ã¤Æ¡¢²¿¤ò¤ä¤ë¤ó¤À¤í¤¦¤Ã¤Æ¡£¶áÂå¸Þ¼ï¤Ï¡¢¼Í·â¡¦¥Õ¥§¥ó¥·¥ó¥°¡¦¿å±Ë¡¦ÇϽѡ¦¥é¥ó¥Ë¥ó¥°¤ò¤Ò¤È¤ê¤Ç¤³¤Ê¤¹¶¥µ»¤é¤·¤¤¤Ç¤¹¤¬¡¢µ¤¤Ë¤Ê¤Ã¤¿¤Î¤Ï±Ñ¸ìɽµ¡£¥Ú¥ó¥¿¥¹¥í¥ó¤È¸À¤¦¤Î¤À¤½¤¦¤Ç¤¹¡£
¤¢¡ª¡¦¡¦¡¦¤â¤·¤«¤·¤Æ¡¦¡¦¡¦
¥Ú¥ó¥¿¥¹¥í¥ó¤Î¥Ú¥ó¥¿¤Ï¡¢¤É¤¦¹Í¤¨¤Æ¤â¥Ú¥ó¥¿¥´¥ó¤Ê¤É¡Ö5¡×¤È¤¤¤¦°ÕÌ£¤Ç¤·¤ç¤¦¡£¤Á¤Ê¤ß¤Ë¥®¥ê¥·¥ã¸ì¤À¤½¤¦¤Ç¤¹¡£¤À¤«¤é¸Þ¼ï¶¥µ»¤¬¥Ú¥ó¥¿¥¹¥í¥ó¡£¤Æ¤³¤È¤Ï¡¢¥È¥é¥¤¥¢¥¹¥í¥ó¤Î¥È¥é¥¤¤â¡£¤½¤¦¤¤¤¨¤Ð»°³Ñ·Á¤Î¤³¤È¤ò¥È¥é¥¤¥¢¥ó¥°¥ë¤Ê¤ó¤Æ¸À¤¦¤·¤Ê¡£»°¼ïÎà¤Î¶¥µ»¤ò¤¹¤ë¤«¤é¥®¥ê¥·¥ã¸ì¤Î¡Ö3¡×¤ò°ÕÌ£¤¹¤ëtri¤Ë¡Ö¶¥µ»¡×¤Îathlon¤Ç¥È¥é¥¤¥¢¥¹¥í¥ó¤«¡£¤½¤Ã¤«¡£
¤½¤¦¤¤¤¨¤Ð¡¢Åßµ¨¥ª¥ê¥ó¥Ô¥Ã¥¯¤Ç¥Ð¥¤¥¢¥¹¥í¥ó¤Æ¶¥µ»¤¬¤¢¤Ã¤¿¤Ã¤±¡£¤â¤Á¤í¤ó¤³¤ì¤â¡¢¥®¥ê¥·¥ã¸ì¤Ç¡Ö2¤Ä¡×¤ò°ÕÌ£¤¹¤ëbi¤Ë¥¢¥¹¥í¥ó¤Ç¥Ð¥¤¥¢¥¹¥í¥ó¡£¥Ð¥¤¥ê¥ó¥¬¥ë¤È¤«¸À¤¦¤·¤Ê¡£¥¯¥í¥¹¥«¥ó¥È¥ê¡¼¥¹¥¡¼¤È¥é¥¤¥Õ¥ë¼Í·â¤Î2¼ïÌܤò¤Ò¤È¤ê¤ÎÁª¼ê¤¬¶¥¤¦¶¥µ»¤Ç¤¹¡£
Ä´¤Ù¤Æ¤ß¤ë¤È¡¢¤Þ¤À¤¢¤ê¤Þ¤·¤¿¡£
100m¥Ï¡¼¥É¥ë¡¦Áö¹âÄ·¡¦Ë¤´ÝÅꡦ200Áö¡¦ÁöÉýÄ·¡¦¤ä¤êÅꡦ800Áö¤Î¼·¼ï¶¥µ»(¥Ø¥×¥¿¥¹¥í¥ó)
100mÁö¡¦ÁöÉýÄ·¡¦Ë¤´ÝÅꡦÁö¹âÄ·¡¦400mÁö¡¦110m¥Ï¡¼¥É¥ë¡¦±ßÈ×ÅꡦËÀ¹âÄ·¡¦¤ä¤êÅꡦ1500Áö¤Î½½¼ï¶¥µ»(¥Ç¥«¥¹¥í¥ó)
100mÁö¡¦ÁöÉýÄ·¡¦200m¥Ï¡¼¥É¥ë¡¦Ë¤´ÝÅꡦ5000mÁö¡¦800mÁö¡¦Áö¹âÄ·¡¦400mÁö¡¦¥Ï¥ó¥Þ¡¼Åꡦ3000m¾ã³²Áö¡¦110m¥Ï¡¼¥É¥ë¡¦±ßÈ×Åꡦ200mÁö¡¦ËÀ¹âÄ·¡¦3000mÁö¡¦400m¥Ï¡¼¥É¥ë¡¦¤ä¤êÅꡦ1500mÁö¡¦»°ÃÊÄ·¡¦10000mÁö¤ÎÆ󽽼ﶥµ»(¥¢¥¤¥³¥µ¥¹¥í¥ó)
¤Þ¤ë¤Ç¡¢¤Ò¤È¤ê±¿Æ°²ñ¤Ç¤¹¤Í¡£¤É¤¦¤ä¤Ã¤ÆÎý½¬¤¹¤ë¤ó¤Ç¤·¤ç¤¦¤«¡£
¤Á¤Ê¤ß¤Ë¥¢¥¤¥³¥µ¥¹¥í¥ó¤Ï¡¢Ã˻ҤȽ÷»Ò¤Ç¼ïÌܤ¬°Û¤Ê¤ë¤½¤¦¤Ç¤¹¡£
| 1/7 pages | >>
- Calendar
-
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
- Selected Entries
-
- Âçºå¥»¥ß¥Ê¡¼¤È¥á¥ë¥Þ¥¬ (02/18)
- 1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø (12/07)
- Excel 2010¤Î¥ì¥Ó¥å¡¼»Ï¤á¤Þ¤·¤¿ (10/01)
- VBA¥»¥ß¥Ê¡¼¡Ö¥¹¥¿¥ó¥À¡¼¥É¡×¤ä¤ê¤Þ¤¹ (09/30)
- ¶ÛµÞÏ¢Íí (08/25)
- 8·î¤ÎVBA¥»¥ß¥Ê¡¼¤ÏÅìµþ¤ÈÂçºå¤Ç³«ºÅ (07/29)
- VBA¥»¥ß¥Ê¡¼¤ä¤ê¤Þ¤¹ (07/05)
- Google Docs¤ÎSpreadsheet¤¬¥ä¥Ð¥¤·ï(1) (11/11)
- ¥¿¥¤¥ß¥ó¥° (10/10)
- ¥È¥é¥¤¥¢¥¹¥í¥ó (08/21)
- Categories
-
- Excel (19)
- ¥Ñ¥½¥³¥ó (12)
- ¥ª¥ó¥é¥¤¥ó¥½¥Õ¥È (1)
- ¥Æ¥ì¥Ó (1)
- »¨µ (32)
- Archives
-
- February 2010 (1)
- December 2009 (1)
- October 2009 (1)
- September 2009 (1)
- August 2009 (1)
- July 2009 (2)
- November 2008 (1)
- October 2008 (1)
- August 2008 (1)
- July 2008 (2)
- June 2008 (10)
- May 2008 (4)
- April 2008 (2)
- March 2008 (2)
- February 2008 (1)
- January 2008 (1)
- December 2007 (3)
- November 2007 (4)
- October 2007 (1)
- September 2007 (1)
- November 2006 (2)
- October 2006 (1)
- March 2006 (1)
- February 2006 (1)
- January 2006 (17)
- December 2005 (2)
- Recent Comment
-
- ¥Õ¥£¥ì¥ª¤Ã¤Æ²¿¡©
¢Í ¥Õ¥£¥ì¥ª¡½ (03/27) - Excel¤Î¥Ð¥°
¢Í ¥ª¥¬¥ï (03/09) - ¥Õ¥£¥ì¥ª¤Ã¤Æ²¿¡©
¢Í ¤¦¤Ã¤Á¡¼ (04/08) - Excel 2007¤Î¥Ö¥í¥°
¢Í uchan (11/19) - ¥Õ¥£¥ì¥ª¤Ã¤Æ²¿¡©
¢Í (03/28) - ¥È¥é¥¤¥¢¥¹¥í¥ó
¢Í (02/23) - 1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø
¢Í ¥«¥ë¥¤¥· (02/09) - 1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø
¢Í ÅÄÃæµü (02/08) - 1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø
¢Í ¥«¥ë¥¤¥· (02/08) - 1·î¡Á3·î¤Î¥»¥ß¥Ê¡¼ÆüÄø
¢Í ÅÄÃæµü (02/08)
- ¥Õ¥£¥ì¥ª¤Ã¤Æ²¿¡©
- Recent Trackback
-
- ÍƵ¿¼ÔX¤Î¸¥¿È
¢Í Å°Ä쥵¡¼¥Á (10/04) - Excel¤Î¥Ð¥°
¢Í WEB¤Î¾ðÊó´Ì¡ª (07/10) - ºÇ°¤ÎÆü¡¹
¢Í freepoker (04/17) - ·Ç¼¨Èĸø³«±ä´ü¤Î¤ªÃΤ餻
¢Í freeonlinegames (04/17) - ºÇ°¤ÎÆü¡¹
¢Í Á°»õ¤ÎÃî»õ¼£ÎÅ¡ÚÁ°»õ¤ÎÃî»õ¤ò¤Ê¤¯¤½¤¦¡Û (04/16) - ¥í¥ê¥Ý¥Ö¥í¥°
¢Í mothers day cards (04/16) - ¥í¥ê¥Ý¥Ö¥í¥°
¢Í mothers day (04/16) - ¥í¥ê¥Ý¥Ö¥í¥°
¢Í peoplesearch (04/12) - ºÇ°¤ÎÆü¡¹
¢Í free ringtones (04/11) - ºÇ°¤ÎÆü¡¹
¢Í southwest airlines (04/11)
- ÍƵ¿¼ÔX¤Î¸¥¿È
- Recommend
- Recommend
- Recommend
- Recommend
- Recommend
- Links
- Profile
- Search this site.
- Others
- Mobile