函数提取不重复值（要求非三键）[答案公布]

领风飞翔

<p>将A1：A14中的数据提取不重复值到B列，要求非三键下拉公式。</p><p>结果在B列<font color="#0000ff">连续排列</font>（<font color="#0000ff">顺序不限</font>）：</p><p><table cellspacing="0" cellpadding="0" width="64" border="0" style="WIDTH: 48pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="64" style="WIDTH: 48pt;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td width="64" height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">34</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">B</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">wer</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">A</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">E</font></td></tr></tbody></table></p><p></p><p>&nbsp;</p><p><br/>&nbsp;</p><p>已有三种解法：</p><p>

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

[此贴子已经被作者于2010-4-23 17:19:40编辑过]

fjmxwrs

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

[此贴子已经被作者于2010-4-11 0:47:50编辑过]

领风飞翔

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

pixyhoney

[em01][em01]

军悟居士

没个效果啊，不明白不重复是指重复的只取一个还是指没有重复的。

领风飞翔

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>军悟居士</i>在2010-4-11 1:09:00的发言：</b><br/>没个效果啊，不明白不重复是指重复的只取一个还是指没有重复的。</div><p></p>刚刚改了，见一楼

军悟居士

<p>试试这个行不行</p><p>

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

</p>

领风飞翔

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

军悟居士

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

领风飞翔

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