提取字符讨论题!

hai · 发表于 2008-4-27 05:30

<table cellspacing="0" cellpadding="0" width="128" border="0" xstr="" style="WIDTH: 97pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="78" style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2496;"></col><col width="50" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1600;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" width="78" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: yellow;">字母</td><td class="xl22" width="50" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow;">结果</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">AADSAAA</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">DS</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">ADGSGG</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">ADS</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">DFGHJUD</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">FGHJU</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">DSA</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">DSA</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">ADGSGG</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">ADS</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">DDFGHJUD</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">FGHJU</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">EETYUIE</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">TYUI</td></tr><tr height="17" style="HEIGHT: 12.75pt;"><td class="xl23" height="17" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent;">QSDFAQ</td><td class="xl23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">SDFA</td></tr></tbody></table>这个星期没作业,想道题大家一起讨论下!1,提取出现过一次的字符(以全大写为例,不考虑小写)结果为示例!2,每个单元格重复出现的字母只有一个!3,重复字母出现的位置没规律,一个公式下拉!4,请大家用回复贴方法回贴,谢谢合作!

fengzhizi888 · 发表于 2008-4-27 06:38

先占个位置,马上下班了,回家再研究

hqhl2008 · 发表于 2008-4-27 07:59

[em07]路过看一下

一剑惊心 · 发表于 2008-4-27 11:24

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

我的公式很长[em04]

mnbvcx · 发表于 2008-4-27 13:35

学习

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

hai · 发表于 2008-4-27 14:34

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

pureshadow · 发表于 2008-4-27 16:26

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

[此贴子已经被作者于2008-4-27 16:27:53编辑过]

小鲤鱼 · 发表于 2008-4-27 16:32

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

pureshadow · 发表于 2008-4-27 16:45

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

willin2000 · 发表于 2008-4-27 17:15

来学习一下.

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

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

[通知] 提取字符讨论题!