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

[µo°Ý] À³¦¬±b´ÚºÞ²zªí

[µo°Ý] À³¦¬±b´ÚºÞ²zªí

¤£¦n·N«ä~¤µ±ß¤W¶ÇªºÀɮצn¹³¶Ç¤£¤W¨Ó¡A³Q§R¤å¡A©Ò¥H¦A­«µo¤@¦¸¬Ý¬Ý

·Q½Ð±Ðªþ¥ó¤¤ªºÀɮתº"«ö·~°È¬d¸ß"¬°¦ó·|¦³ªºÅã¥Ü¥X¨Ó¦ý¦³ªºÅã¥Ü¤£¥X©O?

[attach]19480[/attach]

[attach]19481[/attach]

¥»©«³Ì«á¥Ñ cubela ©ó 2014-11-5 01:32 ½s¿è
¤£¦n·N«ä~¤µ±ß¤W¶ÇªºÀɮצn¹³¶Ç¤£¤W¨Ó¡A³Q§R¤å¡A©Ò¥H¦A­«µo¤@¦¸¬Ý¬Ý

·Q½Ð±Ðªþ¥ó¤¤ªºÀɮתº"«ö·~°È¬d¸ß"¬° ...
cubela µoªí©ó 2014-11-5 01:26



©Ç©Ç¥G?

§Ú¤@ª½µLªk¥¿±`¤W¶Çªþ¥ó?
[attach]19480[/attach]
¨t²Î·|§iª¾:"¥H¤U¬O±z¤W¦¸¤W¶Ç¦ý¨S¦³¨Ï¥Îªºªþ¥ó:À³¦¬±b´Ú.png

¦Ó¥B½s¿è©«¤l­n¤W¶Ç~µe­±´NªÅ¥Õ¤F?
¤£ª¾¹D¬O¹q¸£°ÝÃD¡AÁÙ¬Oºô¯¸°ÝÃD¡AÁٽЪ©¥D¨ó§U¡AÁÂÁÂ

Àɮפj¤p:200k¥H¤º (¥t¥~¤@­ÓÀÉ®×RARÀɤ]¤~´XK)

TOP

¦^´_ 2# cubela


    ±H¨ì§Ú«H½c,§ÚÀ°§A¤W¶Ç¬Ý¬Ý
[email protected]
§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¯T¤j
§Ú¦³MAIL¤F~¦A½Ð±z¸Õ¸Õ~ÁÂÁÂ

TOP

§Ú³£·Q¬Ý¬Ý.. ¦³¤°»ò¥i¥HÀ°¦£~
jomeow µoªí©ó 2014-11-5 11:39



    ÁÂÁ§A¡A¦ý§ÚÀɮ׶Ǥ£¤W¨Ó
¤£ª¾¹D¬O§Úªº¹q¸£°ÝÃDÁÙ¬O½×¾Âªº°ÝÃD?

TOP

¦^´_ 6# cubela


    ¥ýÀ°§A¤W¶Ç¡A¦³ªÅ§Ú¦AÀ°¦£~

À³¦¬±b´ÚºÞ²z.rar (9 KB)

§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¦^´_ 1# cubela


    ´£¥Ü¡G§Aªº¤½¦¡§PÂ_¬O¨Ì¾ÚA1Äæ¦ìªº¦WºÙ

°ÝÃD.JPG (194.46 KB)

°ÝÃD.JPG

§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¥»©«³Ì«á¥Ñ cubela ©ó 2014-11-6 22:34 ½s¿è
¦^´_  cubela


    ´£¥Ü¡G§Aªº¤½¦¡§PÂ_¬O¨Ì¾ÚA1Äæ¦ìªº¦WºÙ
»k¥ú°j¯T µoªí©ó 2014-11-6 20:56



¯T¤j~§Ú§ï¦n¤F~¥i¥H¥Î¤F

¦ý§Ú¤]¤£ª¾¹D«ç§ï¦nªº:dizzy:

§Ú¬O±N­ì¥»ªºA4Àx¦s®æ
=IF(ROW(À³¦¬±b´ÚºÞ²zªí!2:2)>COUNTIF(À³¦¬±b´ÚºÞ²zªí!$A:$A,$A$1),"",INDEX(À³¦¬±b´ÚºÞ²zªí!A:A,SMALL(IF(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960=$A$1,ROW(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960)),ROW(À³¦¬±b´ÚºÞ²zªí!2:2))))
§ï¦¨
=IF(ROW(À³¦¬±b´ÚºÞ²zªí!1:1)>COUNTIF(À³¦¬±b´ÚºÞ²zªí!$A:$A,$A$1),"",INDEX(À³¦¬±b´ÚºÞ²zªí!A:A,SMALL(IF(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960=$A$1,ROW(À³¦¬±b´ÚºÞ²zªí!$A$3:$A$960)),ROW(À³¦¬±b´ÚºÞ²zªí!1:1))))

µM«á¦V¤U½Æ»s±Æ¦C¡A¦ý³Ì«á¤@­ÓÁÙ¬OÅã¥Ü¤£¥X¨Ó¡A§Ú¦A¨Ï¥ÎCTRL+SHIFT+ENTER(°}¦C)
´N¥i¥H¤F
¤£ª¾¹D³o¼Ë¬O§_¥¿½T?

PS:§Ú¤j¦h³£¨Ï¥ÎOpenOffice Calc,¸Ì­±¦¡¤l¼Æ¦r¦³®É³£·|¤£¤@¼Ë~¤£ª¾¹D¬O§_·|¼vÅT¨ì)

(½Æ¥»)À³¦¬±b´ÚºÞ²zªí.rar (30.82 KB)

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD