Excel 如何用公式提取另一单元格数值中没有包含给定数值中数值?答:为方便设计公式,结果数据分别放到不同的列,如图:C1用公式:=IFERROR(INDEX(TRIM(MID(SUBSTITUTE($B1,",",REPT(" ",200)),(ROW($1:$100)-1)*200+1,200)),SMALL(IF(MMULT(N(TRIM(MID(SUBSTITUTE($B1,",",REPT(" ",200)),(ROW($1:$100)-1)*200+1,200))=TRIM(MID(SUBSTITUTE...