统计字符的个数!

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

<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>数据</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;">结果1</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;">结果2</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;">ABDDD</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;">3</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;">3</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;">ADBGDD</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;">2</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;">2</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;">AFGDDA</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;">0</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;">2</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;">ADDDDASDDDDD</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;">5</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;">5</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;">BDDAADDSDDD</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;">3</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;">3</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;">ABDDD</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;">3</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;">3</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;">ADBGDD</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;">2</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;">2</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;">AFGDDA</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;">0</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;">2</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;">ADDASDDDD</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;">4</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;">4</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;">BDDAADDS</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;">0</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;">2</td></tr></tbody></table>1.统计右边以"D"开头连续为"D"字符的个数!2.统计D连续出现最多的次数!

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

游客，如果您要查看本帖隐藏内容请回复

[此贴子已经被作者于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

游客，如果您要查看本帖隐藏内容请回复

我也把答案贴出来先!

[此贴子已经被作者于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">以下是引用tkgg93在2008-4-20 22:03:00的发言： <div class="msgheader">QUOTE:</div><div class="msgborder">学习学习,好像6楼的是数组公式吧?</div> </div>    应该都是数组公式!

		自动登录	找回密码
密码			注册