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

[µo°Ý] ½Ð°Ý¸Ó¦p¦ó¤U¤½¦¡

°Ñ¦Ò¬Ý¬Ý

¦p¦ó¤U¤½¦¡.rar (9.45 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ yangjie ©ó 2010-11-15 17:19 ½s¿è

¦^´_ 9# Hsieh


     ÁÂÁÂHsieh¤j¤j«ü¾É
   §¹¥þ¤F¸Ñ
            =LOOKUP(2,1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8)),²Ä¤G­¶!C$1:C$27)
   «Ü´ÎªºÅÞ¿è·Qªk  ¨ü±Ð¤F
  2  ¤]¥i¥H¥Î 1 ¨ú¥NÅo  
   ¦]¬°1>=1/1   
    ¨º»ò ¥Î2 ¥Î1 ¦bÅÞ¿è¤W¦³¦ó®t²§(¦]¬° 1/((²Ä¤G­¶!$A$1:$A$27=ªí®æ!$C8)*(²Ä¤G­¶!$B$1:$B$27=ªí®æ!$D8)=1 ©Î0©ÎDIV/O)
    ¬O§_¦p¦¹

TOP

¦^´_ 12# yangjie

¦¹¨Ò·íµM¥i¥H±N2¨ú¥N¦¨1
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD