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

[µo°Ý] ·Q½Ð°Ý¦³Ãö¿ï¾Ü­pºâ¤Î³sµ²ªº°ÝÃD ¥ý·PÁ¤j¤j­Ì

[µo°Ý] ·Q½Ð°Ý¦³Ãö¿ï¾Ü­pºâ¤Î³sµ²ªº°ÝÃD ¥ý·PÁ¤j¤j­Ì

·Q½Ð°Ý¦³Ãö¿ï¾Ü­pºâ¤Î³sµ²ªº°ÝÃD  ¥ý·PÁ¤j¤j­Ì
¦p¹Ï


¸ß°Ý°ÝÃDÀÉ®×.rar (18.33 KB)

·PÁ¦A·PÁÂ
lo

°ÝÃD¤@:
½Ð°Ý·Q³sµ²¤u§@ªí2¤¤ªº¸ê®Æ(¤u§@ªíªº¤ñ¼Æ¤£¤@©w)³sµ²«áAÄæ¦ì¥i¥H±Æ§Ç¤j¤p«á¨Ã¦Û°Ê±a¥X¼Æ¦r«á­±ªº­^¤å¥N¸¹©O?
¥O·Q½Ð°Ý¦æ¼Æ¦pªG¥Î¤£¹D¨º»ò¦h ¥i¥HÂê©w¦h¤Ö¦æ¥H¤W«á¤£¨Ï¥Î(¥H¦¹¸ê®Æ¨®¹L60´N¤£¨Ï¥Î)(´î¤Ö¸ê®Æ¿ù»~²v)


¦^ÂÐ:
A1 =IF(ROW(A1)>60,"",SMALL(¤u§@ªí2!A:A,ROW()))
B1 =VLOOKUP(A1,¤u§@ªí2!A:B,2,)
¤½¦¡¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ÁÂÁÂML089ÁÂÁ¤j¤jªº¦^µª

ÁÂÁÂ
lo

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD