excel表中求对于某一固定范围,单元格未包含的数据(具体看举例)_百度...答:C1输入下面公式下拉 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,MID(B1,1,2),""),MID(B1,3,2),""),MID(B1,5,2),""),MID(B1,7,2),"")
excel表格中相同单元格数据对应另外一列的数据组合,用于页码范围?答:C1里输入数组公式,按ctrl+shift+enter,再下拉 =MIN(IF((A:A=A1),(1*(MID(OFFSET($B$1,0,0,COUNTA(B:B),1),1,IFERROR(FIND("-",OFFSET($B$1,0,0,COUNTA(B:B),1))-1,LEN(OFFSET($B$1,0,0,COUNTA(B:B),1)))&"-"&MAX(IF((A:A=A1),(A:...