EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A
来源:学生作业帮 编辑:大师作文网作业帮 分类:综合作业 时间:2024/11/13 13:34:20
EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1
MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-1)+MID(C162,FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))+1,FIND("//",C162,FIND("=",C162,FIND(A5,C162,1)))-FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))-1)
有没有高手知道这个是什么意思,我猜应该是找F和Y的总数,不知道对不对,我要再想加上W应该怎么输
MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))+1,FIND("/",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-FIND("F",$C$162,FIND("=",$C$162,FIND(A5,$C$162,1)))-1)+MID(C162,FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))+1,FIND("//",C162,FIND("=",C162,FIND(A5,C162,1)))-FIND("Y",C162,FIND("=",C162,FIND(A5,C162,1)))-1)
有没有高手知道这个是什么意思,我猜应该是找F和Y的总数,不知道对不对,我要再想加上W应该怎么输
MID(单元格,X,Y)表示在单元格中,取从第X个字符开始的一共Y个字符
所以这个函数是要摘取C162单元格中部分内容
后面的就太长了,要一个一个解释吗?
再问: 905693451 能加一下QQ教一下吗
再答: 已经加你
所以这个函数是要摘取C162单元格中部分内容
后面的就太长了,要一个一个解释吗?
再问: 905693451 能加一下QQ教一下吗
再答: 已经加你
EXCEL 函数问题:MID($C$162,FIND("F",$C$162,FIND("=",$C$162,FIND(A
excel中find函数 和Mid函数的问题.MID(A3,FIND(" ",A3,1)+1,3)
MATLAB find函数 [r,c] = find(R == max(R(:))); thetap = theta(c
1.I have ( )some information .A.find B.finding C.to find D.f
excel 函数问题:=-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},
please help the police( ) the man A find to B to find C find
A.am looking for;look for B.find;find C.am looking for;find
函数公式为:=SUMPRODUCT(--MID(A1,1,FIND("*",A1)-1),--MID(A1,FIND("
excel中=MID(C2,2,FIND("x",C2,
EXCEL公式的意思=MID($A1,FIND("市",$A1)+1,IF(ISERROR(FIND("区",$A1))
VLOOKUP(B6,INDIRECT(--MID(B6,FIND("-",B6)+1,2)&"!b:c"),2,0)谁
He came to Taipei to( )a job last year.A.find B.see C.look f