关于数值筛选的问题

zhengshuang

<p>请问:我一列数,数据量有一万多个数值,里面有些可以正负数抵消,那么我想把这种可以正负抵消的单独找出来有没有什么办法呀?谢谢</p><p></p>

wayy

发个格式看一下。

zhengshuang

<table cellspacing="0" cellpadding="0" width="72" border="0" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" width="72" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">-300</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">300</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">-100</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">45</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">100</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">12</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">12</font></td></tr><tr height="18" style="HEIGHT: 13.5pt;"><td class="xl63" align="right" height="18" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent;"><font face="宋体">-12</font></td></tr></tbody></table>打个比喻就是这种,我想把正负可以抵消的项目找出来,当然正式的数据有一万多个.

yaoxuejian

<p>我也想知道答案·</p>[em01]

hrl88

<img src="http://www.excelpx.com/skins/Default/sigline.gif" alt=""/><br/><font color="#008000"><font size="3">一生同过雨过天睛，今生相遇天涯海角</font></font>