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

[µo°Ý] ¸ê®Æ·j´M

[µo°Ý] ¸ê®Æ·j´M

¦U¦ì¤j¤j:
   ½Ð±Ð¦U¦ì¤j¤j,¥Î¤@ ¦r¦ê(¦bsheet 1)·j´Msheet2¸ê®Æ,
sheet2Àɤº·|¦³¬Û¦P¦hµ§¸ê®Æ,§ä¨ì«á«h§â{©m¦W¦~¦¸²¦·~¾Ç®Õ¦í§}}ªº¸ê®ÆÀx¦s¦b¥t¤@sheet3¦pªþÀÉ
½Ð±Ð­n¦p¦ó¼g?
ÁÂÁÂ

Test.rar (3.8 KB)

TUTA

¦^´_ 1# tuta


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

TOP

sheet3!a3=INDEX(Sheet2!B:B,SMALL(IF(Sheet2!$D$2:$D$11=Sheet1!$A$3,ROW($D$2:$D$11),99),ROW(A1)))&""    °}¦C¤½¦¡

TOP

·PÁ¤G¦ì¤j¤j¦^ÂÐ~~
TUTA

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD