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

½Ð±Ð¦p¦ó­×§ï¤½¦¡

½Ð±Ð¦p¦ó­×§ï¤½¦¡

½Ð±Ð¦p¦ó­×§ï¤½¦¡
¨Ì¤é´Á°Ï¶¡¤Î¹ô§O§ä¥X¶×²v.
§Úªº¤½¦¡±a¥X¨Óªº³£¬O¬Û¦Pªº¶×²v,¨S¦³§ì¨ì¬Û¹ïÀ³ªº¤é´Á°Ï¶¡ªº¥¿½T¶×²v.
½Ð敎¤½¦¡­n¦p¦ó­×¥¿?
·PÁÂ!!

¶×²v¬d¸ß.zip (43.55 KB)

fangac

¦^´_ 1# fangsc


    =LOOKUP(D2,'1'!A:A,'1'!C:C)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


  ÁÂÁª©¥Dªº¦^ÂÐ.
¦ý¹ê°µ«á¬Ý°_¨Ó, §ìªº¶×²v¥u¦Ò¼{¨ì¤é´Á´Á¶¡, ¨S¦³¦Ò¼{¨ì¦³¤£¦Pªº¹ô§O.
¬O§_À°¦£¦A¬Ý¬Ý. ·PÁÂ.

¶×²v¬d¸ß.zip (42 KB)

fangac

TOP

¦^´_ 3# fangsc

¿ï¾Ü²Ä¤G¦C®É´¡¤J©w¸q¦WºÙ
rate
=SMALL(IF('1'!$B$2:$B$2156=TWN004!$N2,'1'!$C$2:$C$2156,""),ROW(INDIRECT("A1:A"&COUNTIF('1'!$B$2:$B$2156,TWN004!$N2))))
¤é´Á
=SMALL(IF('1'!$B$2:$B$2156=TWN004!$N2,'1'!$A$2:$A$2156,""),ROW(INDIRECT("A1:A"&COUNTIF('1'!$B$2:$B$2156,TWN004!$N2))))   
Q2¤½¦¡
=LOOKUP(D2,¤é´Á,Rate)
¶×²v¬d¸ß.rar (38.09 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦A¦¸ÁÂÁ§Aªº¦^ÂÐ.
¤£¹L, ®Ö¹ï¤F´Xµ§¸ê®Æ, §ì¥X¨Óªº¸ê®Æ,À³¸Ó¬O¤£¥¿½Tªº.
¤£ª¾­þ¸Ì¦³»~ ?
¦]¬°¸ê®Æµ§¼Æ·|¦³¤W¸Uµ§, ¥Î¨ç¼Æ¦n¹³·|ÅýÀÉ®×¾Þ§@Åܱo¸ûºC.
¬O§_¥i¥H¥ÎVBAµ{¦¡¨Ó°µ?
·PÁÂ!!

¶×²v¬d¸ß.zip (44.78 KB)

fangac

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD