¾Ç¥Í¨Ì¯Z¯Å¦Û°Ê¿z¿ï¸ê®Æ¥X¨Ó
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2025-2-15
|
°}¦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 |
|
|
|
|
|
|