|
ɽ¤È¤¤¤¨¤ÐExcel¡¢¥Ç¡¼¥¿¤È¤¤¤¨¤ÐExcel¡¢·×»»¤È¤¤¤¨¤ÐExcel¡£
»ä¤ÈExcel¤Î½Ð²ñ¤¤¤Ï¡¢¤Þ¤ÀMacÈǤ·¤«¤Ê¤«¤Ã¤¿º¢¡£
»þÂå¤Ï¾¼Ï¤ǡ¢»ä¤â¤Þ¤ÀÂç³ØÀ¸¤À¤Ã¤¿¤³¤í¤Ç¤·¤¿¡£
À¤´Ö¤Ç¤Ï¡¢Lotus 1-2-3¤ò»È¤Ã¤Æ¤¤¤Æ¡¢Mac¤¬·Ú¼«Æ°¼Ö¤ÈƱ¤¸ÃÍÃʤΤ³¤í¤Ç¤·¤¿¡£
ºÇ½é¤Ë¥Ç¥â¤â¸«¤»¤Æ¤â¤é¤Ã¤¿¤ó¤Ç¤¹¤è¡£
Åìµþ¡¦ÀéÂÌ¥öë¤ÎÈ·¤Î¿¹¿À¼Ò¤ÎÏÆ¤Ë¤¢¤Ã¤¿¡¢
HyperDAX¤È¤¤¤¦Å¹¤ÎŹƬ¥Þ¥·¥ó¤Ç¡¢
º£É÷¤Ë¤¤¤¨¤Ð¡Ö¥«¥ê¥¹¥Þ¤ª¤Í¡¼¤µ¤ó¡×¤¬¤ª¤é¤ì¤¿¡£
¤½¤Î²ÚÎï¤ÊExcel¤µ¤Ð¤¤ò¸«¤Æ¡¢
Excel¤³¤½¤Ï¡Ö¿À¡×¤Ë°ã¤¤¤Ê¤¤¤È³Î¿®¤·¤Æ¤«¤é¤Î¤ªÉÕ¤¹ç¤¤¤Ç¤¹¡£
¡Ê¤ª¤Í¡¼¤µ¤ó¤Î¤Û¤¦¤¸¤ã¤Í¡¼¤Î¤«¤è¡¢¤È¤«¤¤¤¦¥Ä¥Ã¥³¥ß¤Ï¤Ê¤·¤Ç¡Ë
¤³¤ó¤Ê¤³¤È¤ò¸ì¤Ã¤Æ¤¤¤ë¤ÈËÜÂê¤Ë¤¤¤±¤Ê¤¤¤Î¤Ç¡¢
¤¤¤¤Ê¤êËÜÂê¡£
Excel¤Ç¥Ç¡¼¥¿¤ò¤Ä¤¯¤Ã¤Æ¤ª¤¤¤Æ¡¢
¤½¤Î¥Ç¡¼¥¿¤ò¾¤Î¥ï¡¼¥¯¥·¡¼¥È¤Ç»È¤¤¤Þ¤ï¤·¤·¤¿¤¯¤Ê¤ë»þ¤¢¤ê¤Þ¤¹¤è¤Í¡£
Ʊ¤¸¥Ç¡¼¥¿¤ÇƱ¤¸Ê¤Ӥʤ顢¥³¥Ô¡¼¤·¤ÆÅ½¤êÉÕ¤±¤ì¤Ð¤¤¤¤¤·¡¢
¤¢¤ë¤¤¤Ï¡¢¡áA5¡¡¤ß¤¿¤¤¤Ë»²¾È¤¹¤ì¤Ð¤½¤ì¤ÇºÑ¤à¡£
¤·¤«¤·¡¢ºî¤Ã¤Æ¤ª¤¤¤¿É½¤È¡¢¿·¤¿¤Ë¤Ä¤¯¤ëɽ¤Ç¡¢
¡¡¡¡¥Ç¡¼¥¿¤Î½çÈÖ¤¬°ã¤¦¡¢
¡¡¡¡È´¤±¤Æ¤¤¤ë¥Ç¡¼¥¿¤¬¤¢¤ë¡¢
¡¡¡¡²¿²ó¤«Æ±¤¸¥Ç¡¼¥¿¤¬¤¢¤ë¡¢
¤È¤Ê¤ë¤È¡¢°ìµ¤¤Ëº¤¤Ã¤Æ¤·¤Þ¤¦¤Î¤Ç¤¹¡£
¥³¥Ô¡¼¤Ç¤â¡¢¡áA5¡¡¤ß¤¿¤¤¤Ê»²¾È¤Ç¤â¡¢
·ë¶É¡¢°ì¹Ô¡¦°ì¹Ô¡¢¤ä¤ë¤·¤«¤Ê¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¦¤«¤é¤Ç¤¹¡£
Î㤨¤Ð¡¢
¡¡¡¡¡¦½»½êÏ¿¡Ê̾Á°¡¢½»½ê¡¢ÅÅÏÃÈֹ桢¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ë
¤¬´û¤Ë¤¢¤ë¤È¤·¤Þ¤¹¡£
¤½¤³¤Ç¥Ñ¡¼¥Æ¥£¤ò´ë²è¤·¡¢¤½¤Î»²²Ã¼Ô¤À¤±¤Î¥ê¥¹¥È¤ò¤Ä¤¯¤ë¤È¤·¤Þ¤·¤ç¤¦¡£
»²²Ã¼Ô¥ê¥¹¥È¤Ë¤Ï¡¢ÊØÍø¤Î¤¿¤á¤Ë¡¢ÅÅÏÃÈÖ¹æ¤È¥á¡¼¥ë¥¢¥É¥ì¥¹¤â¤Î¤»¤¿¤¤¤È¤·¤Þ¤·¤ç¤¦¡£
¤µ¤Æ¡¢
¡¡¡¡¡¦»²²Ã¼Ô¥ê¥¹¥È
¤Ë¡¢¤â¤¦°ìÅÙ¡¢ÅÅÏÃÈÖ¹æ¤ä¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÆþÎϤ·¤Ê¤¤¤È¤¤¤±¤Ê¤¤¤Î¤Ç¤·¤ç¤¦¤«¡©
¥¢¥Û¤é¤·¤¤¤Ç¤¹¡£¿Í¿ô¤¬¾¯¤Ê¤±¤ì¤Ð¤¤¤¤¤Ç¤¹¡£¤·¤«¤·¡¢½»½êÏ¿¤¬£±£°£°Ì¾¡¢»²²Ã¼Ô£²£°Ì¾¤¯¤é¤¤¤À¤È¡¢ºÇÄã¤Ç¤â£²£°²óƱ¤¸ºî¶È¤¬É¬ÍפǤ¹¡£¥ß¥¹¤â¤·¤Þ¤¹¡£
À¤³¦Ãæ¤Ç¤³¤¦¤¤¤¦¤³¤Èº¤¤Ã¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£
¤Ç¤¹¤«¤é¡¢¤³¤¦¤¤¤¦ÌäÂê¤ò¤¢¤Ã¤µ¤ê¤È²ò·è¤¹¤ëÊýË¡¡Ê´Ø¿ô¡Ë¤¬ÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£
INDEX´Ø¿ô¤ÈMATCH´Ø¿ô¡¡¤Ç¤¹¡£
»ä¤Ï¡¢Excel¤Çɽ¤òºî¤ë¤È¤¡¢
¡¡¡¡¡¦¸¶Â§¤È¤·¤Æ¡¢£±¥·¡¼¥È¡¢£±É½
¤Ë¤·¤Æ¤¤¤Þ¤¹¡£¤³¤¦¤·¤Æ¤ª¤¯¤È¡¢ºî¤ë¼°¤¬´Êñ¤Ë¤Ê¤ë¤«¤é¤Ç¤¹¡£
¤³¤Î¸å¤ÎÀâÌÀ¤Ï¡¢¤³¤ì¤ò¸¶Â§¤Ë¤·¤Þ¤¹¡£
¥ï¡¼¥¯¥·¡¼¥È¤Ë¡¢¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤È¡¢¡Ö½»½êÏ¿¡×¥·¡¼¥È¤¬¤¢¤ê¤Þ¤¹¡£
¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Ë¡¢¥Ñ¡¼¥Æ¥£¤Î»²²Ã¼Ô̾Êí¤ò¤Ä¤¯¤ë¤Î¤¬ºÇ½ªÌÜɸ¤Ç¤¹¡£
¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Ï¡¢£±¹ÔÌܤË
¡¡¡¡¡¦½Ð·ç¡Ê¶õÍó¡¢ÅöÆüµÆþÍÑ¡Ë
¡¡¡¡¡¦Ì¾Á°
¡¡¡¡¡¦¥Õ¥ê¥¬¥Ê
¡¡¡¡¡¦ÅÅÏÃÈÖ¹æ
¡¡¡¡¡¦¥á¡¼¥ë¥¢¥É¥ì¥¹
¤òºî¤Ã¤Æ¤ª¤¤Þ¤¹¡£
ºî¶È¤ÎÌÜɸ¤Ï¡¢¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Ç
¡¡¡¡¡Ö̾Á°¡×¤µ¤¨Æþ¤ì¤ì¤Ð¡¢
¡¡¡¡¸å¤Î¥Ç¡¼¥¿¤Ï¡¢¼«Æ°Åª¤Ë¡Ö½»½êÏ¿¡×¥·¡¼¥È¤«¤éËä¤á¤Æ¤¯¤ì¤ë
¤è¤¦¤Ë¤¹¤ë»ö¤Ç¤¹¡£
¿Í¤¬ºî¶È¤¹¤ë¤Ê¤é¡¢
»²²Ã¼Ô°ì¿Í¤Å¤Ä¡Ö̾Á°¡×¤ò¸«¤Æ¡¢
¤½¤Î¿Í¤Î¡Ö̾Á°¡×¤ò¡Ö½»½êÏ¿¡×¥·¡¼¥È¤«¤éõ¤·¡¢
¤½¤Î¿Í¤Î¡Ö¥Õ¥ê¥¬¥Ê¡×¡ÖÅÅÏÃÈÖ¹æ¡×¡Ö¥á¡¼¥ë¥¢¥É¥ì¥¹¡×¤ò¥³¥Ô¡¼¤·¤Æ
¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤ËŽ¤ë¡¢
¤È¤¤¤¦ºî¶È¤ò¤·¤Þ¤¹¡£
¤·¤«¤·¡¢INDEX´Ø¿ô¤ÈMATCH´Ø¿ô¤ò»È¤¨¤Ð¡¢
¡¡¡¡¤³¤Îºî¶È¤Ï¼°¤ò½ñ¤¤¤Æ¥³¥Ô¡¼¤¹¤ë
¤À¤±¤Ë¤Ê¤ê¤Þ¤¹¡£
Àè¤Ë·ëÏÀ¤ò½ñ¤¤¤Æ¤ª¤¯¤È
¡¡¡¡=INDEX(¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î¥Ç¡¼¥¿¤ÎÎó, MATCH(¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤Î¥»¥ë, ¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎó, 0))
¤Ç¤¹¡£¤³¤Î¼öʸ¤ò¾§¤¨¤Æ¡¢¥³¥Ô¡¼¤¹¤ì¤Ð¤¤¤¤¤À¤±¤Ç¤¹¡£
¤½¤ì¤Ç¤Ï¡¢Îã¤È¤·¤Æ¡¢¼¡¤Îɽ¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£¡ÖËÒÌîÊÆ»Ò¡×¤µ¤ó¤Î̾Á°¤òÆþ¤ì¤Æ¤¢¤ë¤Î¤Ç¡¢¥Õ¥ê¥¬¥Ê¡¦ÅÅÏÃÈֹ桦Email¤ò¡Ö½»½êÏ¿¡×¤«¤é¼è¤Ã¤Æ¤¯¤ë¤³¤È¤ò¹Í¤¨¤Þ¤·¤ç¤¦¡£
¤Þ¤º¡¢MATCH´Ø¿ô¤«¤é¤Ç¤¹¡£¤³¤Î´Ø¿ô¤Ï¡¢
¡¡¡¡¡¦¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤ò¡¢¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎ󤫤éõ¤¹
¤³¤È¤ò¤·¤Æ¤¤¤Þ¤¹¡£Ì¾Á°¤òÌܤÇÄɤ¦ºî¶È¤òÊѤï¤ê¤Ë¤ä¤Ã¤Æ¤¯¤ì¤Æ¤¤¤Þ¤¹¡£
MATCH¤È¤¤¤¦¤Î¤Ï¡¢¶áÆ£ÀµÉ§¡Ê¤½¤¦¤¤¤¦Ç¯Âå¤Ê¤ó¤Ç¡Ë¤Ç¤Ï¤Ê¤¯¡¢¡Ö¾È¹ç¡×¤Î¤³¤È¤Ç¤¹¡£
¾å¤«¤é²¿ÈÖÌÜ¡¢¤È¤¤¤¦·ë²Ì¤¬ÆÀ¤é¤ì¤Þ¤¹¡£
¤³¤ÎÎã¤Î¾ì¹ç¡¢¡ÖËÒÌîÊÆ»Ò¡×¤µ¤ó¤Î̾Á°¤ò¡Ö½»½êÏ¿¡×¥·¡¼¥È¤«¤éõ¤·½Ð¤¹¤³¤È¤Ç¤¹¡£
¤³¤ÎÎã¤Ç¤Ï¡¢¾å¤«¤é£¶ÈÖÌܤιԤǤ¹¤Í¡£
¼¡¤Ë¡¢INDEX´Ø¿ô¤Ç¤¹¡£¤³¤Î´Ø¿ô¤Ï¡¢
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î³ºÅö¹Ô¤Î¥Ç¡¼¥¿¤ò»ØÄê¹Ô¤«¤é¼è¤Ã¤Æ¤¯¤ë
¤³¤È¤ò¤·¤Þ¤¹¡£Îó¤ò·è¤á¤Æ¤ª¤±¤Ð¡¢¤½¤ÎÃæ¤Ç»ØÄꤷ¤¿¥Ç¡¼¥¿¤ò¤È¤Ã¤Æ¤¤Æ¤¯¤ì¤Þ¤¹¡£
»ØÄê¤Î»ÅÊý¤Ï¡¢¾å¤«¤é²¿ÈÖÌܤȤ¤¤¦·Á¤Ç¤·¤Þ¤¹¡£
INDEX¤Ï¡¢¡Öº÷°ú¡×¤È¤¤¤¦°ÕÌ£¤Ç¤¹¡£²¿ÈÖÌܤȤ¤¤¨¤Ð½Ð¤Æ¤¯¤ë´¶¤¸¤Ç¤¹¡£
Àè¤Û¤É¤ÎMATCH¤Ç²¿ÈÖÌܤ«¤¬Ê¬¤«¤Ã¤Æ¤¤¤Þ¤¹¡£
¤³¤Î·ë²Ì¤ò¤Ä¤«¤Ã¤Æ¡¢¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î»ØÄê¹Ô¤Î¾å¤«¤é¿ô¤¨¡¢
¤³¤Î¹ÔÌܤΥǡ¼¥¿¤òÊÖ¤·¤Þ¤¹¡£
¤³¤ÎÎã¤Ç¤Ï¡¢£¶ÈÖÌܤ¬¡ÖËÒÌîÊÆ»Ò¡×¤µ¤ó¤Î¹Ô¤Ç¤·¤¿¡£
£¶¹ÔÌܤ«¤é¥Ç¡¼¥¿¤ò¤È¤Ã¤Æ¤¯¤ë¤Î¤¬INDEX´Ø¿ô¤ÎÌò³ä¤Ç¤¹¡£
£²Ãʳ¬¤Ë¤Ê¤Ã¤Æ¤¤¤ë¤Î¤Ç¡¢¤Á¤ç¤Ã¤ÈÌÌÅݤǤ¹¤¬¡¢¤ä¤Ã¤Æ¤¤¤ë¤³¤È¤Ï
¡¡¡¡¡¦MATCH¡¡¡¦¡¦¡¦¡¡¥Ç¡¼¥¿¤Î¶¦ÄÌÉôʬ¤ò¤Ä¤«¤Ã¤Æ¡¢¥Ç¡¼¥¿¤Î¹Ô¤òÆÃÄꤹ¤ë¤³¤È
¡¡¡¡¡¦INDEX¡¡¡¦¡¦¡¦¡¡MATCH¤Î¹Ô¤ò»È¤Ã¤Æ¡¢»ØÄêÎ󤫤é¥Ç¡¼¥¿¤ò¼è¤Ã¤Æ¤¯¤ë¤³¤È
¤ÈÌò³äʬô¤·¤Æ¤¤¤ë¤À¤±¤Ç¤¹¡£ÁȤ߹ç¤ï¤»¤Î½çÈ֤ϡ¢
¡¡¡¡=INDEX(¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î¥Ç¡¼¥¿¤ÎÎó, MATCH(¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤Î¥»¥ë, ¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎó, 0))
¤È¡¢INDEX¤¬³°Â¦¤Ç¡¢MATCH¤¬Æâ¦¤Ç¤¹¡£
¤³¤ó¤ÊÌÌÅݤ¯¤µ¤¤¤³¤È¤·¤Ê¤¯¤Æ¤â¡¢MATCH¤À¤±¤Ç¤¤¤¤¤¸¤ã¤Ê¤¤¤«¤È»×¤¤¤Þ¤»¤ó¤«¡©
»ä¤â¡¢¤«¤Ä¤Æ¤½¤¦»×¤¤¤Þ¤·¤¿¡£
¤·¤«¤·¡¢¡ÖƱ¤¸¤â¤Î¤òõ¤¹¡×¤È¤¤¤¦¤Î¤Ê¤é¡¢³Î¤«¤Ë¡¢MATCH¤À¤±¤Ç½½Ê¬¤Ç¤¹¡£
¤·¤«¤·¡¢¤½¤ì¤Ç¤Ï´Î¿´¤Î¥Ç¡¼¥¿¤¬¤È¤Ã¤Æ¤³¤ì¤Þ¤»¤ó¡£
º£²ó¤Î¾ì¹ç¤Ê¤é¡¢¡Ö̾Á°¡×¤Ç¾È¹ç¤·¤Æ¡¢¡Ö¥Õ¥ê¥¬¥Ê¡×¤ä¡ÖÅÅÏÃÈÖ¹æ¡×¤ò¤È¤Ã¤ÆÍ褿¤¤¤Î¤Ç¤·¤¿¡£
¤¹¤ë¤È¡¢¤É¤¦¤ä¤Ã¤Æ¡Ö¥Õ¥ê¥¬¥Ê¡×¤ä¡ÖÅÅÏÃÈÖ¹æ¡×¤ò»ØÄꤹ¤ë¤Î¤«¤¬ÂçÌäÂê¤Ê¤Î¤Ç¤¹¡£
¤Ç¤¹¤«¤é¡¢MATCH¤Ï¾È¹ç¤¹¤ë¤À¤±¡¢INDEX¤Ï¼è¤Ã¤ÆÍ褿¤¤Éôʬ¤Î»ØÄê¤Ç¤¹¡£
¤µ¤Æ¡¢¶ñÂÎŪ¤Ë¼°¤Ï¤É¤¦¤Ê¤ë¤Ç¤·¤ç¤¦¤«¡£
¡ÖËÒÌîÊÆ»Ò¡×¤µ¤ó¤Î¡Ö¥Õ¥ê¥¬¥Ê¡×¤ò¤È¤Ã¤Æ¤¯¤ë¤Ë¤Ï¡¢
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î¥Õ¥ê¥¬¥Ê¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎCÎó
¡¡¡¡¡¦¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤Î¥»¥ë¡¡¡¦¡¦¡¦¡¡¡Ö¥Ñ¡¼¥Æ¥£¡×¤ÎB3
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎBÎó
¤Ç¤¹¤«¤é¡¢¼°¤Ï¤³¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£
¡¡¡¡=INDEX(½»½êÏ¿!C:C,MATCH(¥Ñ¡¼¥Æ¥£!B3,½»½êÏ¿!B:B,0))
¼ÂºÝ¤Ë¤Ï¡¢¼°¤ÏľÀܽñ¤«¤º¡¢
¡¡¡¡=INDEX(
¤Þ¤ÇÆþÎϤ·¤Æ¡¢¡Ö½»½êÏ¿¡×¥·¡¼¥È¤ÎCÎó¤òÁªÂò¤¹¤ë¤È¡¢¾¡¼ê¤Ë¡¢
¡¡¡¡=INDEX(½»½êÏ¿!C:C
¤Ë¤Ê¤ê¤Þ¤¹¡£¤½¤³¤Ç¡¢¡Ö,MATCH(¡×¤ÈÆþÎϤ·¤Æ¡¢¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤ÎB3¤òÁªÂò¤¹¤ë¤È¡¢
¡¡¡¡=INDEX(½»½êÏ¿!C:C,MATCH(¥Ñ¡¼¥Æ¥£!B3
¤Ë¤Ê¤ê¤Þ¤¹¡£¤½¤³¤Ç¡¢¡Ö,¡×¤ÈÆþÎϤ·¤Æ¡¢¡Ö½»½êÏ¿¡×¥·¡¼¥È¤ÎBÎó¤òÁªÂò¡¢
¡¡¡¡=INDEX(½»½êÏ¿!C:C,MATCH(¥Ñ¡¼¥Æ¥£!B3,½»½êÏ¿!B:B
¤Ë¤Ê¤ê¤Þ¤¹¡£¤½¤³¤Ç¡¢ºÇ¸å¤Ë¡Ö,0))¡×¤ÈÆþÎϤ·¤Æ¡ÖEnter¡×¥¡¼¤ò²¡¤¹¤È¡¢
¡¡¡¡=INDEX(½»½êÏ¿!C:C,MATCH(¥Ñ¡¼¥Æ¥£!B3,½»½êÏ¿!B:B,0))
¤Ë¤Ê¤ê¡¢¥»¥ë¤Ë¤Ï¡Ö¥Þ¥¥Î¥è¥Í¥³¡×¤Èɽ¼¨¤µ¤ì¤Æ¤¤¤ë¤Ï¤º¤Ç¤¹¡£
¼¡¤Î¡ÖÀ޳ޡפµ¤ó¤Ë¤Ï¡¢¤³¤Î¼°¤ò¡¢¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤ÎC4¤Ë¥³¥Ô¡¼¤·¤Æ¤ä¤ì¤Ð¤¤¤¤¡£
ƱÍͤˡ¢C5¤äC6¤Ë¤â¡¢¥³¥Ô¡¼¤·¤Æ¤ä¤ì¤ÐÂç¾æÉפǤ¹¡£
¡ÖÅÅÏÃÈÖ¹æ¡×¤Ç¤â¡¢Æ±ÍͤǤ¹¡£
¡ÖËÒÌî¡×¤µ¤ó¤Î¾ì¹ç¡¢
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤ÎÅÅÏÃÈÖ¹æ¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎEÎó
¡¡¡¡¡¦¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤Î¥»¥ë¡¡¡¦¡¦¡¦¡¡¡Ö¥Ñ¡¼¥Æ¥£¡×¤ÎB3
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎBÎó
¤Ç¤¹¤Í¡£ÊѤï¤Ã¤¿¤Î¤Ï¡¢²¼ÀþÉôʬ¤À¤±¤Ç¤¹¡£
¤¹¤ë¤È¡¢¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤ÎD3¤Ë¡¢¼¡¤Î¼°¤ò
¡¡¡¡=INDEX(½»½êÏ¿!E:E,MATCH(¥Ñ¡¼¥Æ¥£!B3,½»½êÏ¿!B:B,0))
¤Ç¤¹¡£¤³¤ì¤â°ì¤Äºî¤ì¤Ð¡¢D4¤äD5¤Ë¤â¡¢¥³¥Ô¡¼¤·¤Æ¤ä¤ì¤ÐÂç¾æÉפǤ¹¡£
Email¤Ê¤é¤É¤¦¤Ê¤ë¤«¡¢¤ï¤«¤ê¤Þ¤¹¤«¡©
Âбþ¤¹¤ë¹Ô¤äÎó¤Ï
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤ÎEmail¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎFÎó
¡¡¡¡¡¦¡Ö¥Ñ¡¼¥Æ¥£¡×¥·¡¼¥È¤Î̾Á°¤Î¥»¥ë¡¡¡¦¡¦¡¦¡¡¡Ö¥Ñ¡¼¥Æ¥£¡×¤ÎB3
¡¡¡¡¡¦¡Ö½»½êÏ¿¡×¥·¡¼¥È¤Î̾Á°¤ÎÎó¡¡¡¦¡¦¡¦¡¡¡Ö½»½êÏ¿¡×¤ÎBÎó
¤Ç¡¢E£³¤ËÆþ¤ì¤ë¼°¤Ï¡¢
¡¡¡¡=INDEX(½»½êÏ¿!F:F,MATCH(¥Ñ¡¼¥Æ¥£!B3,½»½êÏ¿!B:B,0))
¤Ç¤¹¡£¤³¤ì¤â°ì¤Äºî¤ì¤Ð¡¢D4¤äD5¤Ë¤â¡¢¥³¥Ô¡¼¤·¤Æ¤ä¤ì¤ÐÂç¾æÉפǤ¹¡£
¤³¤¦¤¤¤¦É÷¤Ë¤ä¤ë¤È¡¢¼¡¤Îɽ¤¬ºî¤ì¤Þ¤¹¤Í¡£
¡ü¡ÖÁêÂл²¾È¡×¤È¡ÖÀäÂл²¾È¡×¤¬Ê¬¤«¤ë¾ì¹ç¡ÖÁêÂл²¾È¡×¤È¡ÖÀäÂл²¾È¡×¤¬Ê¬¤«¤ëÊý¤Ç¤·¤¿¤é¡¢°Ê¾å¤Îºî¶È¤Ï¤â¤¦¤Á¤ç¤Ã¤È¡¢´Êñ¤Ë¤Ê¤ê¤Þ¤¹¡£
¸æÍ÷¤Î¤è¤¦¤Ë¡¢ºî¤Ã¤¿¼°¤Î¸åȾÉôʬ¤Ï°ì½ï¤Ç¤¹¤«¤é¡¢
¤½¤³¤Ï½é¤á¤«¤éÀäÂл²¾È¤Ë¤·¤Æ¤ª¤±¤Ð¤¤¤¤¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£
ºÇ½é¤Î¡Ö¥Õ¥ê¥¬¥Ê¡×¤ò¤È¤Ã¤Æ¤¯¤ë¼°¤ò
¡¡¡¡=INDEX(½»½êÏ¿!C:C,MATCH(¥Ñ¡¼¥Æ¥£!$B3,½»½êÏ¿!$B:$B,0))
¤È¡¢ÀäÂл²¾È¤Ë¤·¤Æ¤ª¤¯¤È¡¢¸å¤Ç¼°¤ò½¤Àµ¤¹¤ë¤Ë¤·¤Æ¤â±þÍѤ¬¸ú¤¤Þ¤¹¡£
»ä¤Ê¤é¡¢¤³¤Î¼°¤ò¤Þ¤ººî¤Ã¤Æ¤ª¤¤¤Æ¡¢¤³¤Î¼°¤ò¡¢
¡¡¡¡D3¤Ë¤Ï¤ë
¤¹¤ë¤È¼«Æ°Åª¤Ë¼°¤Ï
¡¡¡¡=INDEX(½»½êÏ¿!D:D,MATCH(¥Ñ¡¼¥Æ¥£!$B3,½»½êÏ¿!$B:$B,0))
¤ËÊѲ½¤·¤Æ¤¤¤Þ¤¹¡£¤³¤Î¤Þ¤Þ¤Ç¤Ï¡¢¡Ö½»½ê¡×¤ò¤È¤Ã¤Æ¤¤Æ¤·¤Þ¤¦¤Î¤Ç¡¢
¤³¤Î¼°¤Î¡¢¡Ö½»½êÏ¿!D:D¡×¤òȿž¤µ¤»¤Æ¡¢
¡Ö½»½êÏ¿¡×¥·¡¼¥È¤ÎEÎó¤òÁªÂò¤¹¤ë¤È¡¢¾¡¼ê¤Ë¡¢
¡¡¡¡=INDEX(½»½êÏ¿!E:E,MATCH(¥Ñ¡¼¥Æ¥£!$B3,½»½êÏ¿!$B:$B,0))
¤Ë¤Ê¤ë¤Î¤Ç¡ÖEnter¡×¤ò²¡¤¹¡£¤³¤ì¤Ç¡¢¡ÖÅÅÏÃÈÖ¹æ¡×¤¬É½¼¨¤µ¤ì¤Þ¤·¤¿¡£
¼¡¤Ï¡¢¤³¤Î¼°¤ò¡¢
¡¡¡¡E£³¤Ë¤Ï¤ë
¤¹¤ë¤È
¤¹¤ë¤È¼«Æ°Åª¤Ë¼°¤Ï
¡¡¡¡=INDEX(½»½êÏ¿!F:F,MATCH(¥Ñ¡¼¥Æ¥£!$B3,½»½êÏ¿!$B:$B,0))
¤ËÊѲ½¤·¤Æ¤¤¤Þ¤¹¡£¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬É½¼¨¤µ¤ì¤¿¤Ï¤º¤Ç¤¹¡£
¤¢¤È¤Ï¡¢C3¤«¤éE3¤òÁªÂò¤·¤Æ¡¢¥³¥Ô¡¼¤·¡¢
C4¤«¤éC5,C6¡¦¡¦¡¦¤ÈɬÍפʤȤ³¤í¤Þ¤Ç¡¢ÁªÂò¤·¤Æ¡¢¥Ú¡¼¥¹¥È¤¹¤ë¤À¤±¤Ç¤¹¡£
¤µ¤Æ¡¢¡Ö¿À¡×Excel¤È¤Î½Ð²ñ¤¤¤Î¤Î¤Á¡¢
¤ï¤¿¤·¤Ï¡¢¼þ¤ê¤ËExcel¶µ¤òÉÛ¶µ¤¹¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤·¤¿¡£
¤Á¤ç¤¦¤É¤¤¤¤¤³¤È¤Ë¡¢Windows 3.1¤¬Åо줷¡¢
ÆüËܤǤ⡢WindowsÈǤÎExcel¤¬È¯Ç䤵¤ì¤Þ¤·¤¿¡£
¸¦µæ¼¼¤ÎÀèÀ¸¤ËÍê¤ó¤Ç¡¢Çã¤Ã¤Æ¤â¤é¤Ã¤¿WindowsÈǤÎExcel¤Ï®¤«¤Ã¤¿¤Ê¤¡¡£
·ã®¤Ç¤·¤¿¡£
´Ø¿ô¤ò¶Ë¤á¡¢¥Þ¥¯¥í¤ò½¤¤á¡¢
¾®Æ»¶ñ¤ò¤Ä¤¯¤Ã¤¿¤ê¡¢¥Û¡¼¥à¥Ú¡¼¥¸¤ÎÉôÉʤò¤Ä¤¯¤Ã¤¿¤ê¡¢
³Ø°ÌÏÀʸ¤ò½ñ¤¤¤¿¤È¤¤Ï¡¢¥·¥¹¥Æ¥à¤òExcel¾å¤ÇÁȤó¤Ç¤·¤Þ¤¤¤Þ¤·¤¿¡£
¤½¤Î¸å¤â¡¢ExcelÍÍ¤Ë¤ÏÆ¬¤¬¾å¤¬¤ê¤Þ¤»¤ó¡£
¡Ö¤è¤ß¤¬¤¨¤ëÆüËܸì¡×¤Îʬ»ìɽ¤â¡¢
¥ò¥·¥Æ¤Î¥Ç¥¸¥¿¥ë¥Æ¥¥¹¥È¤â¤¹¤Ù¤ÆExcel¾å¤Ç¤¹¡£
¤Ç¤â¤Í¡¢Excel 2007 ¤Ï·ù¤¤¤À¤Í¡£
¤Þ¤À¤Þ¤À¡¢Excel XP(2002) ¤ò»È¤Ã¤Æ¤¤¤ë»ä¤Ê¤Î¤Ç¤·¤¿¡£
|
¥Ñ¥½¥³¥ó¤ªÌòΩ¤Á
[ ¥ê¥¹¥È ]




¤ï¤¿¤·¤Ï¡¢»Å»öÊÁMAC¤òºÇ½é¤«¤é»È¤Ã¤Æ¤Þ¤¹¤¬
Excel¤¬MAC¤·¤«Ìµ¤«¤Ã¤¿»ö¤ÏÃΤê¤Þ¤»¤ó¤Ç¤·¤¿¡£
¤â¤¦MAC¤È¤Î½Ð²ñ¤¤¤Ï20ǯ¶á¤¯¤Ê¤ê¤Þ¤¹
¥Ó¥¸¥å¥¢¥ë·Ï¤Ç¤¹¤«¤é¤Í¡£
2010/6/1(²Ð) ¸á¸å 8:10 [ FUNE ]
¤Á¤ç¤Ã¤È¡¢¸ØÄ¥¤·¤Æ½ñ¤¤¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£
°ìÈֺǽé¤Ë¿¨¤Ã¤¿»þ¤Ï¡¢ËÜÅö¤ËMac¤·¤«¤Ê¤«¤Ã¤¿»þ¤Ç¤·¤¿¡£
¼Ç±º¹©Âç¤Ë¿Ê³Ø¤·¤¿Í§Ã£¤Î²È¤Ç¡¢»È¤ï¤»¤Æ¤â¤é¤¤¤Þ¤·¤¿¡£
¤½¤Î¤È¤¤Ï¡¢Ver.1.0¤Î»þÂå¤Ç¤¹¡£
¤½¤Î¸å¡¢»Å»ö¤Ç¤¤¤¸¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿»þ¤Ï¡¢
Ver.2.2
http://www.d4.dion.ne.jp/~motohiko/microsoft%20excel.html
Windows 3.1¤¬½Ð¤¿¤Î¤¬93ǯ¤Ç¡¢¤½¤Î»þ¤Ë¡¢
Excel 4.0¤¬½Ð¤¿¤Ï¤º¤Ç¤¹¡£
¤½¤Î¸å¡¢Windows 95¤¬½Ð¤¿¤¢¤¿¤ê¤«¤é¡¢WindowsÈǤÎ
Excel¤Î¤Û¤¦¤¬¡¢Â®¤¯¤Æ»È¤¤¤ä¤¹¤¯¤Ê¤Ã¤Æ¤·¤Þ¤·¤Þ¤¹¡£
2010/6/1(²Ð) ¸á¸å 9:23
¤¤¤º¤ì¤Ë¤·¤Æ¤â
Ìܤ¬Èô¤Ó½Ð¤ë¤¯¤é¤¤¹â²Á¤Ç¤·¤¿¤Í¡¢
Ⱦǯ¤â¤·¤Ê¤¤¤¦¤Á¡¢¤Þ¤¿£±ÂæMACÇ㤤¤Þ¤·¤¿¤«¤é
£±Âæ¤Ç¤Ï¡¢»Å»ö¤Ê¤É½ÐÍè¤ëÌõ¤â¤Ê¤¯¤Ç¤·¤¿¤«¤é¡£
¤ª±¢¤ÇÃù¶â¤Ê¤·¤Ç¤¹¡Ê¾Ð¡Ë
2010/6/2(¿å) ¸á¸å 6:55 [ FUNE ]
LaserWriter¤â¹â¤«¤Ã¤¿¤Ç¤¹¡£
»ä¸Ä¿Í¤âMac¤Ï²¿Â椫Ç㤤¤Þ¤·¤¿¡£
PB140, PMac7200, IIsi, PMacG3
¤³¤Î¸å¤Ï¥á¥¤¥ó¥Þ¥·¥ó¤Ç¤Ï¤Ê¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£
iBook G3¤¬ºÇ¸å¤Ç¤¹¡£
º£¤Ï¡¢iPhone¤Ç¤¹¤Í¡£Apple¤â¤Î¤Ï¡£
Iisi¤ÏÃæ¸Å¤Ç¤â¤é¤Ã¤Æ¥ë¡¼¥¿¡¼¤Ë¤·¤Æ¤Þ¤·¤¿¡£(^^;
2010/6/2(¿å) ¸á¸å 8:56