- ©«¤l
- 618
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 663
- ÂI¦W
- 1
- §@·~¨t²Î
- WINDOWS 7
- ³nÅ骩¥»
- OFFICE 2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Pingtung
- µù¥U®É¶¡
- 2011-9-2
- ³Ì«áµn¿ý
- 2024-7-5
![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2013³D¦~¥þ¶Ô¼ú³¹ 2013³D¦~¥þ¶Ô¼ú³¹](images/common/she.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif)
|
¥»©«³Ì«á¥Ñ p212 ©ó 2015-1-2 15:25 ½s¿è
¦^´_ 1# tufe8887
©w¸q¦WºÙ¡uÃþ§O¡v¤§「°Ñ·Ó¨ì¡v쬰=Sheet1!$B$1:$B$26¡A½Ðק令=Sheet1!$B$2:$B$26
Àx¦s®æH2°}¦C¤½¦¡
=IFERROR(INDEX(½s¸¹,MATCH(SMALL(IF((Ãþ§O=$G$2)*(ª¬ºA=$G$4),¶µ¥Ø,FALSE),ROW(1:1)),¶µ¥Ø,0)),"")
Àx¦s®æI2°}¦C¤½¦¡
=IFERROR(INDEX(¼Æ¶q,MATCH(SMALL(IF((Ãþ§O=$G$2)*(ª¬ºA=$G$4),¶µ¥Ø,FALSE),ROW(1:1)),¶µ¥Ø,0)),"")
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I |
|