如图,涂色区域显示的效果,怎么做
高版本A3=TEXTJOIN(",",TRUE,IF(B3:F3>0,$B$2:$F$2,""))
低版本H3=LEFT(CONCAT(IF(B3:F3>0,$B$2:$F$2&",","")),LEN(CONCAT(IF(B3:F3>0,$B$2:$F$2&",","")))-1)
//此为数组公式,低版本EXCEL录入后,要按组合键Ctrl+Shift+Enter完成输入