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

¾Ç¥Í¨Ì¯Z¯Å¦Û°Ê¿z¿ï¸ê®Æ¥X¨Ó

°}¦C¡D¾A¢ÏÄæ¬Ò¬°¤å¦r¡D¤£¨¾¢ÐÄæªÅ®æ¡G
=INDEX(Student!A:A,SMALL(IF(ISERR(FIND(Student!$B$2:$B$20,$D$2)),4^8,ROW($A$2:$A$20)),ROW(A1)))&""

°}¦C¡D±Æ°£FIND¹ïªÅ®æªº»~§P¡G
=INDEX(Student!A:A,SMALL(IF(ISERR(FIND(TEXT(Student!$B$2:$B$20,"ùÜ"),$D$2)),4^8,ROW($A$2:$A$20)),ROW(A1)))&""

¥þ°ì°}¦C¡G±N¤½¦¡¶K¤J¢Ï¢³¡A¦A¥þ¿ï¢Ï¢³¡G¢Ð¢±¢¯¡A¶i¢Ï¢³¦¨½s¿èª¬ºA¡ACtrl + Shift ¡÷ Enter ¤TÁä»ô«ö
=INDEX(Student!A:B,SMALL(IF(ISERR(FIND(Student!B2:B20,D2)),4^8,ROW(2:20)),ROW(1:20)),{1,2})&""

«DEXCEL¥¿¬ì¡A¥u¬O¾ß§O¤H¤½¦¡­×­×§ï§ï¡A¶È¨Ñ°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD