如何查找重复

zaq03

<p><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 width="72" height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">A1</font></td><td align="right" width="72" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体">68</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">B2</font></td><td align="right" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体">78</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">C3</font></td><td align="right" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent;"><font face="宋体">78</font></td></tr></tbody></table></p><p>如何用公式查出A2=78&nbsp;&nbsp; C3=78 重复。</p><p>难啊！</p><p></p>

laoyebin

<table cellspacing="0" cellpadding="0" width="144" border="0" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="72" height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 54pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">A1</font></td><td align="right" width="72" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 54pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">68</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">B2</font></td><td align="right" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">78</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">C3</font></td><td align="right" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">78</font></td></tr></tbody></table>哪来的A2呢？

LangQueS

建议楼主上传附件说明问题。

zaq03

<p>谢谢大家,我只是想在excel表里如何查出重复的数字</p><p>表的第一行&nbsp;&nbsp;&nbsp;&nbsp; 表的第二行</p><p><table cellspacing="0" cellpadding="0" width="144" border="0" style="WIDTH: 108pt; BORDER-COLLAPSE: collapse;"><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="72" height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 54pt; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><p><font face="宋体">A1</font></p></td><td align="right" width="72" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; WIDTH: 54pt; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">68</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">B2</font></td><td align="right" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">78</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">C3</font></td><td align="right" style="BORDER-LEFT-COLOR: #d4d0c8; BORDER-BOTTOM-COLOR: #d4d0c8; BORDER-TOP-COLOR: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #d4d0c8;"><font face="宋体">78</font></td></tr></tbody></table></p><p>我想查表的第二行78 重复就行，我的表第二行有1800多条数字记录，不应有重复的数字。谢谢！</p>

abcd321abcd

如果对函数不是太熟，那么对第二行进行排序比对就是了

zaq03

哈哈，谢谢，我就是这样做的。