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

¤ñ¹ï¨âÄæ¸ê®Æ¡A¦C¥X¬Û¦P¤Î¤£¬Û¦Pªº­È

¦^´_ 2# Hsieh


¦n¥Îªº¨Ò¤l¡C·s¤B¤w¤U¸ü§@¾Ç²ß¤§¥Î¡I

¸g¸Õ¥Î¡A[B¦³AµL]¡B[AB³£¦³]³o¨â¶µ³£µL°ÝÃD¡C
¦ý[A¦³BµL]´N¥X²{°ÝÃD¡A·Ð½Ðª©¥D¦A½ç±Ð¡I

TOP

¦^´_ 21# trainee
§A´ú¸Õ¬O¬Æ»ò°ÝÃD?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 22# Hsieh


§Ú©óA1-A5¶¶§Ç¿é¤J1-5¡A ©óB1-B5¿é¤J3-7¡C
µ²ªG[A¦³BµL]ªÅ¥Õ¡A [B¦³AµL]Åã¥Ü6¤Î7¡A¦Ó[AB³£¦³]Åã¥Ü3¡B4¤Î5¡C
²z½×¤W[A¦³BµL]À³Åã¥Ü1¤Î2¤~¥¿½T¡I¡H
Àµ½Ðª©¥D½ç±Ð¡I

TOP

¦^´_ 23# trainee


    ©w¸q¦WºÙ¥´¿ù¤F
=SMALL(IF(COUNTIF(rng2,rng1)=0,rng1),ROW(A1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 24# Hsieh

    ¦hÁª©¥D½ç±Ð¡I

    ¥i¥H¤F¡A¦p¦¹Â²³æ¡A·s¤B¥ç¤£¹îı¡A¯uªº­n¦h¤U¥\¤Ò¡I

TOP

@@­è¦n¦]¬°³o­Ó°ÝÃDGOOGLE¨ì³o¤@©«
¯S¦a¥[¤J·|­û
ÁöµMÁÙ¤£¯à¤U¸ü¡A¦ý¥ý·PÁª©¥Dªº¦^À³¡C

TOP

¦^´_ 2# Hsieh


±z¦n!

·Q½Ð°Ý, °²¦p, §ÚAÄ檺¸ê®Æ, ¤£¨£±o¬O27­Ó, ¦³¥i¯à¬O10­Ó, ¤]¦³¥i¯à¬O100­Ó, ¨º§Ú¸Ó«ç»ò°µ©O?  ·PÁÂ!
=INDEX(A:A,SMALL(IF(MATCH($A$1:$A$27,$A$1:$A$27,0)=ROW($1:$27),ROW($1:$27),4^8),ROW(1:1)))&""

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

:) thanks !!

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD