hai 发表于 2008-4-20 20:48

统计字符的个数!

<p><table cellspacing="0" cellpadding="0" width="279" border="0" xstr="" style="WIDTH: 209pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="135" style="WIDTH: 101pt; mso-width-source: userset; mso-width-alt: 4320;"></col><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" width="135" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 101pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><shapetype id="_x0000_t201" path="m,l,21600r21600,l21600,xe" ospt="201" coordsize="21600,21600"><stroke joinstyle="miter"></stroke><path fillok="f" strokeok="f" shadowok="f"></path><lock shapetype="t" vext="edit"></lock></shapetype><shape id="_x0000_s1025" oinsetmode="auto" stroked="f" type="#_x0000_t201" style="MARGIN-TOP: 0px; Z-INDEX: 1; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 54pt; POSITION: absolute; HEIGHT: 16.5pt;"><lock vext="edit" text="t"></lock></shape><shape id="_x0000_s1026" oinsetmode="auto" stroked="f" type="#_x0000_t201" style="MARGIN-TOP: 0px; Z-INDEX: 2; VISIBILITY: hidden; MARGIN-LEFT: 0px; WIDTH: 54pt; POSITION: absolute; HEIGHT: 16.5pt;"><lock vext="edit" text="t"></lock></shape><font face="新細明體">数据</font></td><td class="xl24" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">结果1</font></td><td class="xl24" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">结果2</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ABDDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ADBGDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">AFGDDA</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">0</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ADDDDASDDDDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">5</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">5</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">BDDAADDSDDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ABDDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">3</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ADBGDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">AFGDDA</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">0</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">ADDASDDDD</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">4</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">4</font></td></tr><tr height="22" style="HEIGHT: 16.5pt;"><td class="xl24" height="22" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent;"><font face="新細明體">BDDAADDS</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">0</font></td><td class="xl24" xnum="" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="新細明體">2</font></td></tr></tbody></table>1.统计右边以"D"开头连续为"D"字符的个数!</p><p>2.统计D连续出现最多的次数!</p>

波塞冬2008 发表于 2008-4-20 21:02

**** Hidden Message *****<br/><br/>

[此贴子已经被作者于2008-4-20 21:57:21编辑过]

穆 发表于 2008-4-20 21:03

高，等着学习

songlin 发表于 2008-4-20 21:08

不会，来学习！

lixianhu 发表于 2008-4-20 21:19

学习来了

hai 发表于 2008-4-20 21:31

**** Hidden Message *****</p><p>我也把答案贴出来先!</p>
[此贴子已经被作者于2008-4-20 21:57:13编辑过]

king_lsy 发表于 2008-4-20 21:45

学习

晓 发表于 2008-4-20 21:45

学习来了

tkgg93 发表于 2008-4-20 22:03

<div class="msgheader">QUOTE:</div><div class="msgborder">学习学习,好像6楼的是数组公式吧?</div>
[此贴子已经被作者于2008-4-20 22:09:11编辑过]

hai 发表于 2008-4-20 22:15

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>tkgg93</i>在2008-4-20 22:03:00的发言：</b><br/><div class="msgheader">QUOTE:</div><div class="msgborder">学习学习,好像6楼的是数组公式吧?</div><br/></div><p></p>&nbsp;&nbsp;&nbsp; 应该都是数组公式!
页: [1] 2 3 4 5 6
查看完整版本: 统计字符的个数!