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

[µo°Ý] ½Ð±Ð¦³Ãö°ÊºA½d³ò+¤U©Ô¦¡²M³æ°ÝÃD

[µo°Ý] ½Ð±Ð¦³Ãö°ÊºA½d³ò+¤U©Ô¦¡²M³æ°ÝÃD

½Ð±Ð¥ý¶i,

¦bªþ¥ó¤¤,¦³¨â­Ó°ÝÃD­n½Ð±Ð (¦b¥¼¨Ï¥ÎVBA «e´£¤U)

1.¦b[³¡ªù] ¤U©Ô¦¡²M³æ¤¤,¦p¦ó"¤£­«½ÆÅã¥Ü" ?
2.¨Ì·Ó[³¡ªù] ¤À§O±a¥X³¡ªù©ÒÄݤH­û¤§²M³æ®É,¦p¦ó³]©w?

·PÁÂ!!

PS ¦³°Ñ¦Ò¥ý«e¦³Ãö ¶mÂí ¤§½d¨Ò ... ¹B¥Î offset  match ¨ç¼Æ

¤U©Ô¦¡²M³æ-°ÊºA½d³ò.zip (1.72 KB)

¦^´_ 1# mistery


    ¤U©Ô¦¡²M³æ-°ÊºA½d³ò.zip (2.05 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

   ½Ð±Ðª©¤j

  ±zªº½d¨Ò¤¤¦³Ãö x  ªº©w¸q --> SUM(1/COUNTIF(Sheet1!$A$2:$A$7,Sheet1!$A$2:$A$7))
   ¨ä¤¤ SUM () ¨ç¼Æ¤º   " 1/ Countif() "  ªº»yªk ¯à§_½ÐªO¤j¸Ñ»¡

TOP

¦^´_ 3# mistery
­pºâ¤£­«½Æ¶µ¥Ø¼Æ
¨C­Ó¶µ¥Ø¼Æ¶qªº­Ë¼Æ¥[Á`
¦pA¦³2­Ó¡AB¦³1­Ó¡AC¦³3­Ó
1/COUNTIF(A2:A7,A2:A7)
·|¶Ç¦^°}¦C
0.5,0.5,1,1/3,1/3,1/3
±N°}¦C¥[Á`´N·|µ¥©ó3
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


    ÁÂÁª©¤j³o»ò¸Ô²Óªº»¡©ú¡C
¡@ ¨C·í¹J¨ì²~ÀVªº®É­Ô¡A¦^¨ì³o¸ÌÁ`¬O¯à«Ü§Ö±o¨ì¼ö±¡ªº¦^À³¡C

¡@ PS ¬Ý¤Fª©¤j´£¨Ñªº¤H­û²M³æ¤½¦¡¡A¸ò¦Û¤vµo°Ý«e¸Õ¼gªºÀ³¸Ó®t¤£¦h¡A¦ý´N¬O¥u·|±a¥X²Ä¤@¦ì....¯u¬O©Ç :P

TOP

¦^´_ 4# Hsieh



     ª©¤j   ¦A¸ò±z½Ð±Ð  ¤U­±³o¦¡¤l
   
     LOOKUP(2,1/((Sheet2!$A$2:$A$4=A2)*(Sheet2!$B$2:$B$4=B2)),Sheet2!$C$2:$C$4)
   
     ³o¬O§Ú¦b§O³B¬Ý¨ì¬Y¤@½d¨Ò¦³Ãþ¦üªº¥Îªk
     ¬O»¡­n¥Î¦P®É²Å¦XAÄæ¸òBÄ檺±ø¥ó  ¥h±a¥XCÄ檺­È
   
     ¦³¨â­Ó¤£¸Ñ¤§³B:
     1.  sheet2!$A$2:$A$4=A2  ©Î Sheet2!$B$2:$B$4=B2 ©Î Sheet2!$C$2:$C$4
          ¦p§ï¼g¬°   sheet2!$A:$A=A2  ©Î Sheet2!$B:$B=B2 ©Î Sheet2!$C:$C  ´N·|µLªkÅã¥Ü, why ??

    2.  ¦b¦¹¦¡ Lookup( )¨ç¼Æ¤¤ªº¥Îªk ¸ò±z³o¦¸¼gªº¦ü¥G¦³ÂI¬Û¦ü,¦ý¤]¦P¼Ë·P¨ì§x´b¤F
         ¤S·Q½Ð±z¸Ñ»¡¤@µf
   
   ·PÁÂ!!!

TOP

°}¦C¤½¦¡¤£¥i¨Ï¥Î¾ãÄæ©Î¾ã¦Cªº°Ñ·Ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# mistery

°ÝÃD2¥i°Ñ¦Ò§Ú¤§«e°Ý¹Lªº¤@½g¡G
http://forum.twbts.com/viewthread.php?tid=9099&page=1

TOP

¤U©Ô¦¡²M³æ-°ÊºA½d³ò Sonny.rar (265.33 KB) ¦^´_ 1# mistery
ss

TOP

¾Ç²ß¾Ç²ß;¯à°÷¼Wªø¥\¤O

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD