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

vlookup ¬dªí°ÝÃD

¦^´_ 9# ANGELA


    ¦¨¥\¤F! ÁÂÁ±zªº¨ó§U~

·Q¦A½Ð°Ý¤@¤U, ­Y§Ú­n¸óªí¬d¸ß, ´N¬OÁ`ªí¬O¦b¥t­Ó¤u§@ªí, ¨º§Ú¸Ó¦p¦ó§ï©O?

TOP

¦^´_ 11# yc1031

Á`ªí ¤u§@ªí


¬d¸ß ¤u§@ªí

B2=INDEX(Á`ªí!B:B,SMALL(IF(COUNTIF($A$2,Á`ªí!$A$2:$A$10)>=1,ROW($2:$10),65534),ROW(A1)),)&""   °}¦C¤½¦¡

Book1.rar (4.05 KB)

TOP

¦^´_ 10# ANGELA

ÁÂÁ¹D¯},¤£µM§Ú·Q¯}ÀY¤]¤£ª¾«ç¸Ñ!¨ü±Ð!!

TOP

¦^´_ 12# register313


    ¤Ó·PÁ¤F! :)
¦¨¥\Åo

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD