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

¢ÐÄæ­n¨ú¥X²Å¦X¢ÒÄæ¤ºªºÃöÁä¦r

¦pªGexcelª©¥»¨S¦³TEXTJOIN¨ç¼Æ, ¥Îvba¼g­ÓÃþ¦üªº¦Û­q¨ç¼Æ:
Xl0000808.rar (11.15 KB)

¤½¦¡//°}¦C
=TEXTJOIN("¡B",1,IF(1-ISERR(0/(FIND(D$2:D$16,"_"&A2)>1)),D$2:D$16,""))

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD