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

jkczfpb

<p>思考题:</p><p>偶在工作中有实际需求,但不会弄,希望拿出来一起学习</p><p>主要是怎么将两表的代码合并排序的问题</p><p></p><p></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">问题</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">:</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">1</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">、设置镇的合计公式</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">,</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">可复制到各项目</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;"> ，就是可以向后面的列拖—粘贴</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">2</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">、设置村、组的公式，可一次性复制到各村、组，各项目。</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;"> </span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">注意：</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;"> </span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">々々々是我更换的名称，</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: Calibri; language: en-US; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">1</span><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">也是我更换的数据，不用管，公式中绝对不允许出现々々々</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">提示:</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">表头第一、二行是各项目，第一列是镇、村、组、农户，々々々是不同的名称</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;">中间的1是被替换了的需要计算的基础数据。</span></p><p style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt; MARGIN-LEFT: 0in; TEXT-INDENT: 0in; language: zh-CN;"><span style="FONT-SIZE: 11pt; COLOR: black; FONT-FAMILY: 宋体; language: zh-CN; mso-ascii-font-family: Calibri; mso-fareast-font-family: 宋体; mso-bidi-font-family: +mn-cs; mso-color-index: 13;"></span>解法越多越好,欢迎大家踊跃回复<br/></p><br/>

[此贴子已经被作者于2007-6-1 14:21:52编辑过]

xhsdham

<p>楼主的 练习题 是 .xlsx文件 去掉最后一个x后 打开是乱码</p>

时间

<p>没有文件呀.</p>

xhsdham

<p>难 [em06][em06]&nbsp; 倒腾了2个小时 第一个都没弄出来 我用下面的公式把数据都引用过来了 可是不知为什么无法对其去重复 总是出现错误值</p><p>=INDIRECT(IF((ROW()-4)&gt;COUNTA('2006年'!$A$4:$A$262),"2007","2006")&amp;"年!a"&amp;IF((ROW()-4)&lt;=COUNTA('2006年'!$A$4:$A$262),ROW()-1,ROW()-1-COUNTA('2006年'!$A$4:$A$262)))</p>

七栋五零二

[em04][em04] 留下人气。

紫映竹

<p>不要再出这么难的题了好不？？？</p>

xhsdham

<br/>

jkczfpb

<p>好像不符合要求哟,</p><p>我希望达到的效果是前面的"本级主代码"按顺序排列,该列数据包含2006年的与2007年的综合,你做的是先排2006年的排完了再排的2007年的,主要是这点其他的都无所谓</p>

jkczfpb

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>xhsdham</i>在2007-6-1 13:39:19的发言：</b><br/><p>楼主的 练习题 是 .xlsx文件 去掉最后一个x后 打开是乱码</p></div><p>不好意思,我用的EXCEL2007,格式没改过来,现在好了 </p><p></p>