EXCEL怎么用textjoin函数筛选每个单元格对应的生产计划时间答:应邀回答:B2=TEXTJOIN(" ",,IFERROR(IF(OFFSET(Sheet2!C$2:AD$2,MATCH(A2,Sheet2!A$3:A$6,),),TEXT(Sheet2!C$2:AD$2,"m/d"),""),""),IFERROR(IF(OFFSET(Sheet3!C$2:AD$2,MATCH(A2,Sheet3!A$3:A$6,),),TEXT(Sheet3!C$2:AD$2,"m/d"),""),""))同时按Ctrl+...