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

excel ¨Ï¥Î¨ç¼Æ¨ú¥X¼Æ­È«e20¥X²{­«½Æªº°ÝÃD?¦p¦ó¸Ñ

excel ¨Ï¥Î¨ç¼Æ¨ú¥X¼Æ­È«e20¥X²{­«½Æªº°ÝÃD?¦p¦ó¸Ñ

¥»©«³Ì«á¥Ñ abba9817 ©ó 2014-8-21 12:51 ½s¿è

¹Ï1
¹Ï2
§Q¥Î¤u§@ªí(¤ÀÂI®w)-¹Ï2¤ºªº¸ê®Æ¨ú¥X«e20³Ì¤j¤Î³Ì¤pªº¼Æ­È¸ê®Æ¦s©ñ¦b¤u§@ªí(Á`ªí)-¹Ï1
¦ýµ²ªG¥X²{­«½Æ¸ê®Æ½Ð°Ý¸Ó¦p¦ó­×¥¿¨ç¼Æ©O?(¨£¹Ïªí1¬õ¦â®Ø®Ø)
¥H¤U¨ú¨Ò¬°¦Û¤v¼gªº¿ï¥X¼Æ­È³Ì¤p«e20 ¨ç¼Æ¨B±¹:

1.¿ï¨ú¹Ï2¤¤G7:G1179½d³ò¼Æ­È¿ï¥X¼Æ­È³Ì¤p«e20 ±Nµ²ªG¦s¦b¹Ï1¤§I9~I28¤¤
¤½¦¡I9=SMALL(¤ÀÂI®w!G7:G1179,F9)

2.¦A¨Ì¹Ï1¤¤I½d³ò¼Æ­È¿ï¥X¹Ï2¹ïÀ³ªº¦WºÙ¦s©óH9~H28
¤½¦¡H9=INDEX(¤ÀÂI®w!$A$7:$G$1179,MATCH($I9,¤ÀÂI®w!$G$7:$G$1179,0),2)
3.¦A¨Ì¹Ï1¤¤I½d³ò¼Æ­È¿ï¥X¹Ï2¹ïÀ³ªº¥N¸¹¦s©óG9~G28
G9=INDEX(¤ÀÂI®w!$A$7:$A$1179,MATCH($I9,¤ÀÂI®w!$G$7:$G$1179,0))
½Ð°Ý¸Ó¦p¦ó­×¥¿¨ç¼Æ©O?ÁÂÁÂ

©êºp.¤w¦Û¦æ§ä¨ì¤èªk¤F..ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD