高级筛选: 筛选出数学大于80或语文大于90的列表(已解答)

Excel教程

<p>要求设置高级筛选的条件区域</p><p>数字大于90或语文大于80 </p>

[此贴子已经被作者于2008-2-27 16:26:36编辑过]

晓

<p>数学&nbsp;&nbsp; 语文</p><p>&gt;90</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;80</p>

Excel教程

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>晓</i>在2008-2-27 16:23:00的发言：</b><br/><p>数学&nbsp;&nbsp; 语文</p><p>&gt;90</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &gt;80</p></div><p></p><font color="#f70909" size="5">非常正确</font>

Soniy789

筛选条件：<table cellspacing="0" cellpadding="0" width="144" border="0" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td align="left" width="72" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><a name="RANGE!E3:F5">数学</a></td><td align="left" width="72" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 54pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;">语文</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td align="left" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">&gt;<font class="font5">80</font></td><td align="left" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;">&gt;<font class="font5">80</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td align="left" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">&lt;90</td><td align="left" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;">&lt;90</td></tr></tbody></table>

201228

愁，高级筛选两个题不会。

liziyuliziyu7

顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶