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

¦p¦ókeyin¨â­Ó¸ê®Æ«á¦Û°Ê¤À²Õ

¦p¦ókeyin¨â­Ó¸ê®Æ«á¦Û°Ê¤À²Õ

¥»©«³Ì«á¥Ñ ce378078 ©ó 2012-4-10 00:37 ½s¿è

½Ð¦U¦ì¤j¤jÀ°¤p§Ì¬Ý¤@¤U³o­Ó­n¦p¦ó³]©w?
¦bªþ¥ó¤¤¦³¤@­Ó¤À²ÕªíÀÉ®×
°ò¥»¤W¦b¤À²Õªíªº¸ê®Æªí¤¤
¤p§Ì§Æ±æ¦bCÄæ(°Ï)DÄæ(³æ¦ì)E(²Õ§O)¤¤
¥uKEYIN¨ä¤¤¨â¶µ§Y¥i¶]¥X²Ä¤T¶µ¸ê®Æ
¤p§Ì¥Î¹LIF¦ý´N¬OµLªk¦P®ÉKEYIN¨â­Ó¸ê®Æ«á¶]¥X²Ä¤T­Ó(¸Ô°Ñ¦a°Ïªí¤§¸ê®Æªí¤¤)
½Ð¦U¦ì¤j¤jÀ°¦£¤@¤U!!
·P¿E¤£ºÉ!!

¸É¥R¤@¤U
§YKEYIN (°Ï)©M(³æ¦ì)¥i¥H¦Û°Ê¶]¥X¹ïÀ³ªº(²Õ§O)
©Î¬OKEYIN (²Õ§O)¤Î(³æ¦ì)§Y¥i¶]¥X¹ïÀ³¤§(°Ï)
¥u­n³o¨â¶µKEYªk§Y¥i!¤£»Ý²Ä¤TºØ

¤À²Õªí.rar (24.23 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-4-10 09:54 ½s¿è

¦^´_ 1# ce378078
©w¸q¦WºÙx
=OFFSET(¦a°Ïªí!$B$1,MATCH(¤À²Õªí!$C2,¦a°Ïªí!$B:$B,0)-1,1,COUNTA(¦a°Ïªí!$C:$C),)
E2=LOOKUP("ùÕ",OFFSET(INDEX(x,1,1),,-2,MATCH(D2,x,0),))
   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD