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

[µo°Ý] ¨D±Ð

[µo°Ý] ¨D±Ð

·Q°Ý°Ý, ¤@­Óªí¦³¦hµ§­«Âиê®Æ(©m¦W), ¦p¦ó´£¨ú­Ó¤Hªº³Ì°ª¾Ç¾ú? ·PÁÂ,,,,

2.png (10.96 KB)

2.png

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-11 08:25 ½s¿è

¦^´_ 1# takya
¡u¾Ç¾ú¡v¬O¤å¦r¡AµLªk¤À§O¤j¤p¶i¦æ±Æ§Ç¡A«Øij¹ï¡u¾Ç¾ú¡v¶µ¥Ø½á¤©¹ïÀ³ªº½s½X(¨Ò¦p¡G¤j¾Ç½s¡u1¡v¡B±M¬ì½s¡u2¡v¡B°ª¤¤Â¾½s¡u3¡v...)¡A¥H§QÂ^¨ú­Ó¤Hªº³Ì°ª¾Ç¾ú¡C
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 1# takya

´£¨ú­Ó¤Hªº³Ì°ª¾Ç¾ú, F2 ¿é¤J¤½¦¡«á¤U©Ô :

=LOOKUP(2,1/(A$1:A$100=E2),B$1:B$100)

TOP

¦^´_ 3# JBY
±N1#ªºdata¶¶§Ç½Õ¾ã«á(¦pªþ¹Ï)
¦A¨Ì3#¤§¤½¦¡¹Bºâ¡A¨ä©Ò±oµ²ªG»P1#­ì¦³µ²ªG¤£²Å¡C
½Ð°ÝÀ³¦p¦ó­×§ï¡H
ÁÂÁ¡I

fig.jpg (15.62 KB)

fig.jpg

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD