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

¤À²Õ±Æ§Ç

¤À²Õ±Æ§Ç

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-9-10 21:51 ½s¿è

³o­Ó¤½¦¡ÀYµh¤F¦n¤[¡A²{§â¸ê®Æ²¤Æ¤@¤U¡AÀµ½Ð°ª¤H«ü¾É¡C Book1.rar (2.42 KB)

¦^´_ 1# chin15

­Y¦³¸s²Õ±Æ¦C¸Õ¸Õ¬Ý

    ¤À²Õ­«½Æ±Æ¦W.rar (4.76 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦hÁ¶Wª©¦^ÂÐ
¥i¯à§Ú»¡±o¤£°÷²M·¡¡A¤£¬O©w¸q¦WºÙ¤À²Õ
§Ú·Q¥Î°}¦C¤½¦¡ªí²{¡A¦Ó¥B¤£¤U©Ô
¦P®É¿ï¨úd2:d18¡A¿é¤J¤½¦¡«á«öctrl+shift+enter
³o¼Ë±o¨ìªº°}¦C¥i§@¨ä¥L¥Î³~
³o­Ó¤½¦¡¹ï§ÚÃø«×»á°ª¡A¥Ø«e¯Z§OÄæ¬O°²¦X¨Ö¡A¦pªG¬O¯u¦X¨Ö¤½¦¡¤S¸Ó¦p¦óªí²{¡H
¦hÁ­@¤ß«ü¾É¡C

TOP

¦^´_ 1# chin15

¥»¥H¬°±Æ¦W¦¸À³¸Ó¬O«Ü²³æ¡A¥J²Ó¬ã¨s§Aªº±Æ¦W¤è¦¡ÁÙº¡¤£¦P¡AÁÙ¨S¦³¬ã¨s¥X¨Ó¡C

¨ä¤¤¦X¨ÖÀx¦s®æ¸Ì¨C®æ³£¦³­È¡A­ËÅý§Ú«Ü¦³¿³½ì¡A¥H«e§ä¹Lºô¸ô¨S§ä¨ì¦p¦ó³]©w¡A§Æ±æ§A¯àÀ°§Ú¦^µª¦¹°ÝÃD¡A
ÃD¥Øµo°Ý¦p¤U
http://forum.twbts.com/viewthread.php?tid=7748&extra=
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# chin15
­nª½±µ¨ú¥X¤À²Õ¤º¤£­«½Æ¤À¼Æ±Æ¦W¤w¸gÅý¤H¶Ë³z¸£µ¬¡A­Y¦A¥[¤W¦X¨ÖÀx¦s®æ°ÝÃD¡A¬Û«H¤º«Ø¨ç¼Æ¬OµLªk¹F¦¨
¯Âºé¦nª±¼g­Ó¦Û©w¸q¨ç¼Æ¡A¨ú±o±Æ¦W°}¦C
¤À²Õ±Æ§Ç.rar (10.22 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# chin15

­«½Æ¦W¦¸¤£¸õ¸¹(1¡B1¡B2¡B3¡B3¡B4¡B5 ...)ªº±Æ¦W


¯Z§OÄæ¬O°²¦X¨Ö¡A¥i¥H±Ä¥Î MATCH(A2:A18,A2:A18,)*10^5+C2:C18 ´N¥i¥H­«·s¤ÀÃþ½s¸¹
±N­«½Æ¤À¼ÆÂo°£¡A¥i¥H±Ä¥Î FREQUENCY(¤ÀÃþ½s¸¹,¤ÀÃþ½s¸¹)>0 Âo°£­«½Æ¤À¼Æ»P¶Q¦¡¦X¨Ö¨Ï¥Î
¶Q¦¡«Øij­×§ï¬°¡AMMULT((...)*(...)*TRANSPOSE(INDEX(Âo°£­«½Æ¤À¼Æ,ROW(1:17))), ...)

¥þ¿ï¦¡°}¦C¿é¤J¡A¦P®É¿ï¨úd2:d18¡A¿é¤J¤½¦¡«á«öctrl+shift+enter


¯Z§OÄæ¬O¯u¦X¨Ö®É¡A­«·s¤ÀÃþ½s¸¹§Ú¥¿¦b¬ã¨s¤U¦¡
LOOKUP("ùÜ",INDIRECT("A2:A"&ROW(2:18)),ROW(2:18))*10^5+C2:C18
³æ¿W´ú¸Õ®ÉOK¡A¤@²Õ¦X«á´N²£¥Í¿ù»~¡A«áÄòÁÙ­n¬ã¨s...¡A¥ýPO¥X¨Ó¤]Åý©p·Q¤@·Q¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# chin15

¨âºØ¸Ñªk´£¨Ñ°Ñ¦Ò
¸Ñ1 : ª©¤j­ì¦¡ + FREQUENCY Âo°£­«½Æ¤À¼Æ
¸Ñ2 : ±Ä¥Î MATCH + SMALL ¤£­«½Æ¤À¼Æ±Æ§Ç ¸Ñªk
EXCEL ¤À²Õ§Ç¸¹±Æ¦W KK 2ºØ¸Ñªk.rar (4.75 KB)
1

µû¤À¤H¼Æ

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¯u¬O­n±o¡I¤F¤£°_¡I¨¯­W¤F¡A¦¬¤U¾Ç²ß¡CÁÂÁ¡I
¥ý¶i­Y¦³®É¶¡¤]½Ð¤@¨Ö«ü¾Éa¦C¯u¦X¨Ö®Éªº³B²z¡C

TOP

¦^´_ 8# chin15

¯Z§OÄæ¬O¯u¦X¨Ö®É¡A­«·s¤ÀÃþ½s¸¹¥i¥Î¤U¦¡
MATCH(ROW(2:19),IF(A2:A19<>"",ROW(2:19)))
µ{¦¡ºc¬[¦P«e

½d¦CÀɮצp¤U
EXCEL ¤À²Õ§Ç¸¹±Æ¦W KK 2ºØ¸Ñªk.rar (5.55 KB)

PS: ¾A¥Î©ó ¯Z§OÄæ¬O¯u¦X¨Ö®É
1

µû¤À¤H¼Æ

    • Hsieh: ©ç©ç¤â!ª÷¿ú + 4
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ chin15 ©ó 2012-9-10 20:06 ½s¿è

·PÁ·PÁ¡A¨¯­W¤F¡A¤½¦¡¦n½ÆÂø¡A§Ú±o¤À¸Ñ¶}¨ÓºCºC²z¸Ñ¾Ç²ß¡C
¯uªº¤£¬O´¶³qªº¼F®`¡A¨Ø¨Ø¤§¦Ü¡C

¥t¥~·Q½Ð±Ðª©¥D¡A§Ú§ä¤£¨ì¥i¥Hµû¤Àªº¦a¤è¡A¬O¤£¬O¥u¦³ª©¥D¥i¥Hµû¤À¡H

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD