论坛站务软件水平考试华为认证计算机等级PMP认证思科认证Photoshop3DMAX编程语言移动开发系统运维产品运营淘宝营销办公软件Ps修图云计算大数据摄影就业

<p>有两列姓名，用什么方法能最快的对比出来，今天用电子表格2007版本测试，结果如何呢？<br style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;"/>【例】如下图所示，要求对比H列和F列，找出两列相同和不同的姓名。</p><p><img alt="1433668098734148.jpg" src="/Public/forum/ueditor/image/20150607/1433668098734148.jpg"/></p><p><span style="margin: 0px; padding: 0px; color: rgb(0, 32, 96); word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;"><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">方法1</strong>：<strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">条件格式法</strong></span></p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">步骤</strong>：按ctrl键选取F列和H列的姓名，开始 - 条件格式 - &nbsp;突出显示单元格显示规则 - <span style="margin: 0px; padding: 0px; color: rgb(0, 112, 192); word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">重复值</span></p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">用时</strong>: <span style="margin: 0px; padding: 0px; color: rgb(192, 0, 0); word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">12</span>秒</p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">演示</strong>：</p><p><img alt="1433668126769022.gif" src="/Public/forum/ueditor/image/20150607/1433668126769022.gif"/></p><p><span style="margin: 0px; padding: 0px; color: rgb(0, 32, 96); word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;"><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">方法2：高级筛选法</strong></span></p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">步骤</strong>：互相作为对方列的条件区域，执行高级筛选，对筛选结果填充颜色。</p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">用时</strong>：<span style="margin: 0px; padding: 0px; color: rgb(192, 0, 0); word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;"><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">41</strong></span>秒</p><p><strong style="margin: 0px; padding: 0px; word-wrap: break-word !important; max-width: 100%; box-sizing: border-box !important;">演示</strong>：</p><p><img alt="1433668159784636.gif" src="/Public/forum/ueditor/image/20150607/1433668159784636.gif"/></p>

论坛站务软件水平考试华为认证计算机等级PMP认证思科认证Photoshop3DMAX编程语言移动开发系统运维产品运营淘宝营销办公软件Ps修图云计算大数据摄影就业