¥¨¥¯¥»¥ë¡ÊExcel¡Ë&¥ï¡¼¥É¡ÊWord¡Ë¼ÁÌä·Ç¼¨ÈÄ

¤è¤ê¸«¤ä¤¹¤¯»È¤¤¤ä¤¹¤¤¥¨¥¯¥»¥ë·Ç¼¨ÈĤòÌܻؤ·¡¢¿·¤¿¤Ë¥¨¥¯¥»¥ë¤Î¼ÁÌä·Ç¼¨ÈĤò³«Àߤ¤¤¿¤·¤Þ¤·¤¿¡£ ¤³¤ì¤Ëȼ¤¤¡¢Åö¥µ¥¤¥È¤Ç¤Ïº£¸å¡¢¿·µ¬Åê¹Æ¤Ï¤Ç¤­¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£¡Ê±ÜÍ÷¤ÏÅöÌ̲Äǽ¤Ç¤¹¡£¡Ë
º£¸å¤Ï¿··Ç¼¨ÈĤò¤´ÍøÍѤ¤¤¿¤À¤­¤Þ¤¹¤è¤¦µ¹¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£º£¸å¤È¤â¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¡û¿··Ç¼¨ÈÄ
¡¦¥¨¥¯¥»¥ë¡ÊExcel¡Ë²ò·è·Ç¼¨ÈÄ

¥¨¥¯¥»¥ë¡¦¥ï¡¼¥É¤Î´ðËÜÁàºî¤Ë´Ø¤¹¤ë¼ÁÌä¤ä´Ø¿ô¤ä¥Þ¥¯¥í¤Î»È¤¤Êý¤Ê¤É¥¨¥¯¥»¥ë¤È¥ï¡¼¥É¤Ë´Ø¤¹¤ë¼ÁÌä·Ç¼¨ÈÄ¡£
Welcome Guest 
¥á¥¤¥ó¥á¥Ë¥å¡¼
¥í¥°¥¤¥ó
¥æ¡¼¥¶¡¼Ì¾:

¥Ñ¥¹¥ï¡¼¥É:


¥Ñ¥¹¥ï¡¼¥Éʶ¼º

Re: ľ¶á¤ÎÆü¤òµá¤á¤ë

¤³¤Î¥È¥Ô¥Ã¥¯¤ÎÅê¹Æ°ìÍ÷¤Ø

¤Ê¤· Re: ľ¶á¤ÎÆü¤òµá¤á¤ë

msg# 1.1
depth:
1
Á°¤ÎÅê¹Æ - ¼¡¤ÎÅê¹Æ | ¿ÆÅê¹Æ - »ÒÅê¹Æ¤Ê¤· | Åê¹ÆÆü»þ 2012-1-27 21:20
gesuto 
¡Ê²ò·èºÑ¤È»×¤¤¤Þ¤¹¤¬¡£¡£¡Ë

Excel´Ø¿ô¤Ç¼Â¸½¤¹¤ë¤Ë¤Ï¡¢¾¯¤·É½¤Î¥ì¥¤¥¢¥¦¥È¤òÊѹ¹¤·¤Ê¤¤¤ÈÆñ¤·¤½¤¦¤Ç¤¹¡£

°Ê²¼¤Î°Æ¤Ï¤É¤¦¤Ç¤·¤ç¤¦¤«¡£

¡Ú³µÍסÛ
­¡ ifʸ¤Ç¡Ö¡ü¡×¤ÎÈÎÇäÆü¤Î¤ßÃê½Ð¡ÊE¡ÁGÎó¡Ë
­¢ maxʸ¤Ç¡Ö¡ü¡×¤ÎÈÎÇäÆü¤ÎºÇÂç¡ÊºÇ¿·¡Ë¤òÃê½Ð

¡ÚExcel¥¤¥á¡¼¥¸¡Û
AÎó BÎó CÎó DÎó EÎó FÎó GÎó
¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½¡½
ÆüÉÕ AŹ BŹ CŹ ¢­=IF(B2="¡ü",$A2,"") ¢­=IF(C2="¡ü",$A2,"") ¢­=IF(D2="¡ü",$A2,"")
1·î1Æü ¤ß¤«¤ó ¤ê¤ó¤´ ¤ß¤«¤ó
1·î2Æü ¤ê¤ó¤´ ¤Ð¤Ê¤Ê ¤ß¤«¤ó
1·î3Æü ¡ü ¤ê¤ó¤´ ¤Ð¤Ê¤Ê 1·î3Æü
1·î4Æü ¤ê¤ó¤´ ¤Ð¤Ê¤Ê ¤ê¤ó¤´
1·î5Æü ¤ß¤«¤ó ¤ß¤«¤ó ¤ê¤ó¤´
1·î6Æü ¤Ð¤Ê¤Ê ¤ß¤«¤ó ¤Ð¤Ê¤Ê
1·î7Æü ¤Ð¤Ê¤Ê ¤Ð¤Ê¤Ê ¤ß¤«¤ó
1·î8Æü ¤ß¤«¤ó ¤Ð¤Ê¤Ê ¡ü 1·î8Æü
1·î9Æü ¤Ð¤Ê¤Ê ¤ß¤«¤ó ¤ê¤ó¤´
1·î10Æü ¤ê¤ó¤´ ¡ü ¤Ð¤Ê¤Ê 1·î10Æü
1·î11Æü ¤ß¤«¤ó ¡ü ¤ß¤«¤ó 1·î11Æü
1·î12Æü ¤ê¤ó¤´ ¤ê¤ó¤´ ¤Ð¤Ê¤Ê
1·î13Æü ¤ê¤ó¤´ ¤ß¤«¤ó ¤ê¤ó¤´
1·î14Æü ¤ß¤«¤ó ¤Ð¤Ê¤Ê ¡ü 1·î14Æü
1·î15Æü ¡ü ¤ê¤ó¤´ ¤ß¤«¤ó 1·î15Æü

1·î15Æü 1·î11Æü 1·î14Æü
¢¬=MAX(G2:G16)
¢¬=MAX(F2:F16)
¢¬=MAX(E2:E16)
Åêɼ¿ô:44 Ê¿¶ÑÅÀ:3.18
ÊÖ¿®¤¹¤ë

¤³¤ÎÅê¹Æ¤ËÊÖ¿®¤¹¤ë

Âê̾
¥²¥¹¥È̾   :
Åê¹ÆËÜʸ

Åê¹Æ¥Ä¥ê¡¼

  ¾ò·ï¸¡º÷¤Ø


¥¹¥Ý¥ó¥µ¡¼¥ê¥ó¥¯
¥¹¥Ý¥ó¥µ¡¼¥ê¥ó¥¯
¥¨¥¯¥»¥ë¡¦¥ï¡¼¥É¼ÁÌä/²óÅú½¸ - ¥¯¥¤¥º¡¦ÌäÂêQUUS¡ª - ̵ÎÁ±Ñ¸ì³Ø½¬ - Åê»ñ²È¡¦¥È¥ì¡¼¥À¡¼·Ç¼¨ÈÇ
°ÙÂØ(FX)¥Æ¥¯¥Ë¥«¥ëʬÀÏÆþÌç - ¥¨¥¯¥»¥ë(EXCEL)³Ø½¬¡¦ÆþÌç - Word(¥ï¡¼¥É)¤Î»È¤¤Êý/³èÍÑ¡¦ÆþÌç
Copy right(c) 2006-2010 ¥¨¥¯¥»¥ë¡õ¥ï¡¼¥É¼ÁÌä·Ç¼¨ÈÄ all right reserved