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

[µo°Ý] ¦p¦ó±q¤£¦P¤u§@ªí§ì¨ú©Ò»ÝÄæ¦ì?

[µo°Ý] ¦p¦ó±q¤£¦P¤u§@ªí§ì¨ú©Ò»ÝÄæ¦ì?

¦pªþÀÉ¡AÁÂÁÂ! Book3.rar (2.02 KB)

¥»©«³Ì«á¥Ñ ANGELA ©ó 2010-11-5 12:21 ½s¿è

¦^´_ 1# winston219


  C2  °}¦C¤½¦¡
{=INDEX(sheet1!B:B,SMALL(IF(sheet1!B:B="¸g²z",ROW($A$1:$A$100),100),ROW(A1)))&""}

TOP

ANGELA¤j¤j¡A½Ð°Ý¬O¦bC2Äæ¿é¤J°}¦C¤½¦¡¶Ü? ¦ý³o¼Ë¥u¥X²{¨ç¼Æ½X¡A½Ð°Ý­n¦b­þùØ¿é¤J°}¦C¤½¦¡?

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-5 15:46 ½s¿è

¦^´_ 3# winston219


    http://forum.twbts.com/thread-1277-1-1.html
¥Î¶i¶¥¿z¿ï
Book3.zip (14.56 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Hsieh¤j¤j¡AÁÂÁ±z­@¤ßªº»¡©ú¡A§Ú¤w¸g¤ñ¸û¤F¸Ñ¶i¶¥¿z¿ïªº¥Îªk¤F¡A·PÁ±z~

TOP

·Æ¹«©Ô©Ô¡A®ÄªG¤]¤£¿ù¡I
a.gif

TOP

¦^´_ 6# oobird


    ¤ì¤uª©¥D
±z³o¦¸ªºGIFÀɪ½±µ¦bª©­±¤W¬Ý¦n¼Ò½k..­n¤U¸ü¤~¬Ýªº²M·¡




¥t¥~¼Ï¯Ã³o¥÷¸ê®Æ¨Ó·½...¦pªG¥u¿ï¾Ü¼Ó¥Dªº¾ï¦â°Ï¶ô§@"¸g²z"¿z¿ï
­Y­n·s¼W¸ê®Æ«h"!"¤£·|§ó·s...



³Ì«á±zªºGIFÀɪº"¦Û°Ê®æ¦¡³]©w"¿ï¶µ
¥i¥H¸Ñ¨M¨º½g"¦C¦L®É³Ì«áªº¦r³Q¤Á±¼"
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

1.¦bºô­¶¤WÅã¥Ü¥»´N«Ü¼Ò½k«Ü¤£¬yºZªº¡A¥²¶·¤U¸üÆ[¬Ý¡C
2.¹w´Á­n§ó·s¸ê®Æ½d³ò¶·§â½d³ò©w¸q°ÊºA¦WºÙ¡A¥H³o­Ó¦WºÙ§@¬°¼Ï¯Ãªº¨Ó·½¡C
3.¦Û°Ê®æ¦¡³]©w·|§ïÅܦr«¬¤j¤p¡A³q±`¦r«¬¤j¤p¦b10¥H¤W¦C¦L´N¤£·|³Q¤Á±¼¡C

TOP

ÁÂÁÂoobird¡A­ì¨Ó¼Ï¯Ã¤ÀªRªí¤]¥i¥H³o¼Ëª±¡A·PÁÂ!

TOP

¦^´_ 6# oobird


    ¤Ñ­þ!!³o¬Ý°_¨Ó«Ü´Î!«Ü·Q¾Ç...
    §Ú¦n·Q¤U¸ü°Ú~~~
·s¤â¾Çexcel

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD