- ©«¤l
- 154
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 200
- ÂI¦W
- 26
- §@·~¨t²Î
- windwos 7
- ³nÅ骩¥»
- 64bit
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-5-29
- ³Ì«áµn¿ý
- 2024-9-24
|
¥»©«³Ì«á¥Ñ 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/
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) |
|