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

[µo°Ý] ½Ð°Ý¦U¦ì¤j¯«¡A¦³Ãö textjoin ®Ú¾Ú±ø¥ó¦X¨Ö«á¡A¨Ã§R°£­«½Æ­È

¥»©«³Ì«á¥Ñ quickfixer ©ó 2020-6-23 05:15 ½s¿è

§Ú§ä¨ì³o½g±Ð¾Ç,¸ò§A¤@¼Ëªº®æ¦¡,§Ú·ÓµÛ°µok³á
https://dhexcel1.wordpress.com/2017/04/04/multiple-lookup-values-in-a-single-cell-withwithout-duplicates-using-only-excel-formulas-by-david-hager/
Image 28.png
2020-6-23 04:54

Image 29.png
2020-6-23 04:56


arange=¬ö¿ý!$B$2:$B$30
brange=¬ö¿ý!$C$2:$C$30
some_array=SMALL(IF(arange=¬ö¿ý!$F3,ROW(brange)-1,""), ROW(INDIRECT("1:"&COUNT(IF(arange=¬ö¿ý!$F3,ROW(brange),"")))))
carray=INDEX(brange,N(IF(1,some_array)))
countarray=COUNTA(carray)
rowarray=ROW(INDIRECT("1:"&countArray))

g3=TEXTJOIN(";",,IF(MATCH(carray,carray,0)=rowarray,carray,""))
(ctrl+shift+enter)

TOP

¥»©«³Ì«á¥Ñ quickfixer ©ó 2020-6-23 10:10 ½s¿è

¦^´_ 3# edmondsforum

#N/A ´N¥Îifna³B²z´N¦n¤F
=TEXTJOIN(";",,IFNA(IF(MATCH(carray,carray,0)=rowarray,carray,""),""))
(ctrl+shift+enter)

Image 30.png
2020-6-23 10:09

TOP

¦^´_ 5# edmondsforum

Image 31.png
2020-6-23 11:17

   
¥Î«Ø¥ß½Æ¥»,excel©w¸q¦WºÙ·|¦Û°Ê°µ·sªº

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD