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

[µo°Ý]¦p¦ó±N²Å¦X±ø¥óªº¸ê®Æ¦b¤@¦C¤¤¦C¨Ó(¦h­Ó±ø¥ó)

[µo°Ý]¦p¦ó±N²Å¦X±ø¥óªº¸ê®Æ¦b¤@¦C¤¤¦C¨Ó(¦h­Ó±ø¥ó)

½Ð±Ð¦U¦ì°ª¤â

¦p¦ó±N²Å¦X±ø¥óªº¸ê®Æ¦b¤@¦C¤¤¦C¨Ó(¦³¦h­Ó±ø¥ó)

½Ð°Ñ¦Òªþ¥ó¤º»¡©ú

§Ú·Q¥i¯à·|¥Î¨ì INDEX MATCH SMALL ¤§Ãþªº¨ç¼Æ¡A¦ý´N¬O¤£ª¾¦p¦ó²Õ¦X°_¨Ó¹B¥Î
½Ð°ª¤â»¡©ú±Ð¾Ç¤@¤U ÁÂÁ±z

TEST.rar (6.65 KB)

http://blog.xuite.net/hcm19522/twblog/436848338

TOP

¦^´_ 2# hcm19522

±z¦n ·PÁ±zªº¦^ÂÐ
¶i¤@¨B½Ð±Ð
§ä´Mªº°ê§O¥i¥H¬OÅܼƶÜ
¤]´N¬O­n§äªº°ê§O©ñ¦b¤@­Ó½d³ò¤º ¦p $B1:$B4
§Ú¸Õ¤F¤@¤Uµo²{ find  ¤£¯à³o¼Ë¼g
±z¦³¦nªº«Øij¶Ü ÁÂÁÂ

TOP

¦^´_ 3# yurckr

D2:D13{=INDEX(A:A,SMALL(IF(MMULT(IF(ISERR(FIND(TRANSPOSE(B$1:B$4),A$3:A$21))+(TRANSPOSE(B$1:B$4)=""),,1),{1;1;1;1}),ROW(A$3:A$21),4^8),ROW(A1)))&""
B$1:B$4 ¿é¤J 1~4 °ê¦W

TOP

D2

{=INDEX(A:A,SMALL(IF(ISNUMBER(FIND({"¥xÆW","¼w°ê","¤¤°ê"},$A$3A$21)),ROW($321),4^8),ROW(A1)))&"}
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD