- ©«¤l
- 169
- ¥DÃD
- 39
- ºëµØ
- 0
- ¿n¤À
- 252
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2011-4-17
- ³Ì«áµn¿ý
- 2020-7-17
|
¦^´_ 3# Hsieh
¯u¬O¶}²´¬É¡AÁÙ¥i³o¼ËÀ³¥Î¡A¨ü±Ð¤F~~
A8=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$B$1:$B$10=Sheet2!$B$1,ROW($A$1:$A$10),4^8),ROW(A1)))&""
B8=INDEX(Sheet1!C:C,SMALL(IF(Sheet1!$B$1:$B$10=Sheet2!$B$1,ROW($A$1:$A$10),4^8),ROW(B1)))&""
¥H¤W¬°"°}¦C¤½¦¡"¡A¸ê®Æ¤Ó¦h®É¡A¤£«Øij¨Ï¥Î! |
|