领风飞翔 发表于 2010-4-11 00:32

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

<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>**** Hidden Message *****
[此贴子已经被作者于2010-4-23 17:19:40编辑过]

fjmxwrs 发表于 2010-4-11 00:47

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

领风飞翔 发表于 2010-4-11 00:55

**** Hidden Message *****

pixyhoney 发表于 2010-4-11 00:56

军悟居士 发表于 2010-4-11 01:09

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

领风飞翔 发表于 2010-4-11 01:13

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

军悟居士 发表于 2010-4-11 01:18

<p>试试这个行不行</p><p>**** Hidden Message *****</p>

领风飞翔 发表于 2010-4-11 01:21

**** Hidden Message *****

军悟居士 发表于 2010-4-11 01:36

**** Hidden Message *****

领风飞翔 发表于 2010-4-11 01:46

**** Hidden Message *****
页: [1] 2 3 4 5 6 7 8 9 10
查看完整版本: 函数提取不重复值（要求非三键）[答案公布]