WPS2016以上支持TEXTJOIN函数版本:C26单元格公式=TEXTJOIN("、",1,IF(MATCH(TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF(C19:C25<>"",C19:C25,"")),"、",REPT(" ",50)),ROW(1:99)*50-49,50)),TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF(C19:C25<>"",C19:C25,"")),"、",REPT(" ",50)),ROW(1:99)*50-49,50)),)=ROW(1:99),TRIM(MID(SUBSTITUTE(TEXTJOIN("、",1,IF(C19:C25<>"",C19:C25,"")),"、",REPT(" ",50)),ROW(1:99)*50-49,50)),""))
数组公式, Ctrl+Shift+回车,公式两端出现大括号{}后才能正确运算。
本回答被提问者采纳