Excel一个单元格中有多个数字,需要筛选,不知如何办答:列B为判断计数=IF(ISERROR(FIND("06",A2)),0,1)+IF(ISERROR(FIND("13",A2)),0,1)+IF(ISERROR(FIND("16",A2)),0,1)+IF(ISERROR(FIND("20",A2)),0,1)+IF(ISERROR(FIND("22",A2)),0,1)+IF(ISERROR(FIND("24",A2)),0,1)然后筛选B列>2的单元格,即可挑出含02、13、16...
如何快速将EXCEL中各列中的具体内容有筛选的放在一个单元格中?答:单选题比较简单,在第一行空白列公式:=offset($B1,0,code(G1)-64)多选题大概只能用多个substitute函数:=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H1,"A",C1),"B",D1),"C",E1),"D",F1),"E",G1)
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+...