数组兴趣小组练习题-018期

lnjyzxp

<p>10楼的思路与前边几位都不一样，定义名称后公式显得比较有条理，给10楼补充一下吧！</p><p><table cellspacing="0" cellpadding="0" width="381" border="0" xstr="" style="WIDTH: 286pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="381" style="WIDTH: 286pt; mso-width-source: userset; mso-width-alt: 12192;"></col><col></col></colgroup><tbody><tr height="34" style="HEIGHT: 25.5pt;"><td width="381" height="34" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 286pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">x=ROW('数组兴趣小组练习题-018期'!$1:$10)-1</td></tr><tr height="34" style="HEIGHT: 25.5pt;"><td height="34" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">y=COUNT(FIND(x,'数组兴趣小组练习题-018期'!A2))</td></tr><tr height="34" style="HEIGHT: 25.5pt;"><td height="34" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;"><p>z=ROW(INDIRECT("1:"&amp;y))</p><p>B2=SUM(MID(A2,SMALL(FIND(x,A2&amp;"0123456789"),z),1)*10^(y-z))</p></td></tr></tbody></table></p>

[此贴子已经被作者于2007-10-12 8:34:37编辑过]

V20

<p>做一个先</p><p>=SUM(MID(A2,SMALL(FIND(ROW($1:$10)-1,A2&amp;"0123456789"),ROW(INDIRECT("1:"&amp;COUNT(FIND(ROW($1:$10)-1,A2))))),1)*10^(COUNT(FIND(ROW($1:$10)-1,A2))-ROW(INDIRECT("1:"&amp;COUNT(FIND(ROW($1:$10)-1,A2))))))</p><p>不会定义名称[em04]</p>

lnjyzxp

<p>我也来一个，定义名称如上，</p><p>B2=SUM(MID(A2,SMALL(IF(ISERR(FIND(x,A2)),9E+307,FIND(x,A2)),z),1)*10^(y-z))</p>

[此贴子已经被作者于2007-10-13 16:11:33编辑过]

lnjyzxp

<p>这个公式还可以有以下两种写法：</p><p>名称定义同上。</p><p>B2=SUM(MID(A2,SMALL(IF(ISNUMBER(FIND(x,A2)),FIND(x,A2)),z),1)*10^(y-z))</p><p>或B2=SUM(MID(A2,LARGE(IF(ISNUMBER(FIND(x,A2)),FIND(x,A2)),z),1)*10^(z-1))</p><p>都可以的，不过两个也差不多，请批评指正。</p>

laoyebin

<p>我的和10楼的思路差不多</p><p>=MID(SUM(MID(A2&amp;1234567890,SMALL(FIND(ROW($1:$10)-1,A2&amp;1234567890),ROW($1:$10)),1)*10^(10-ROW($1:$10))),1,COUNT(FIND(ROW($1:$10)-1,A2)))</p>

adai_lush

<p>新来的，看看先</p>

hai

<p>定义名称AAA=(MATCH(MID($A2,ROW(INDIRECT("1:"&amp;LEN($A2))),1),MID($A2,ROW(INDIRECT("1:"&amp;LEN($A2))),1),)=ROW(INDIRECT("1:"&amp;LEN($A2))))*ROW(INDIRECT("1:"&amp;LEN($A2)))</p><p>=SUM(MID(A2,LARGE(AAA,ROW(INDIRECT("1:"&amp;SUM(N(AAA&gt;0))))),1)*(10^(ROW(INDIRECT("1:"&amp;SUM(N(AAA&gt;0))))-1)))</p>

zhj1978

<img alt="" src="http://www.excelpx.com/Skins/Default/emot/em06.gif" style="MARGIN: 6px; CURSOR: pointer;"/>

小笨蛋

=LEFT(SUM((0&amp;MID(A2,LARGE(FIND(ROW($1:$10)-1,A2&amp;5^19),ROW($1:$10)),1))*10^ROW($1:$10)),COUNT(FIND(ROW($1:$10)-1,A2)))

wsmnjj

看看