多需要不重复计数，又1个Excel困难，看我3分钟搞定，WPS同样适用
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在Excel<span style="color: black;">怎样</span>实现多<span style="color: black;">要求</span>不重复计数，这个问题真的难倒了<span style="color: black;">非常多</span>人，今天跟<span style="color: black;">大众</span>分享2种<span style="color: black;">处理</span><span style="color: black;">办法</span>。分别针对Excel与WPS的<span style="color: black;">区别</span>用户，操作<span style="color: black;">亦</span>非常的简单</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>Excel用户</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">针对</span>Excel用户，<span style="color: black;">举荐</span><span style="color: black;">运用</span>power povit来<span style="color: black;">处理</span>，操作非常的简单，只需拖动字段，点点鼠标<span style="color: black;">就可</span>搞定</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1. 将表格加载到数据模型（power povit）</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">点击数据源，<span style="color: black;">而后</span>点击【<span style="color: black;">插进</span>】找到【数据透视表】就会跳出一个新的窗。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在当前的窗口中设置透视表的位置，<span style="color: black;">而后</span>在下方勾选【添加到数据模型】这一步非常重要，最后点击确定<span style="color: black;">就可</span>。<span style="color: black;">这般</span>就会创建透视表</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/684dc2b4f2e040da86e86b3cf71f92e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=ILByQxVnRLJWzny1NGfauuwPRDE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2. 非重复计数</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如</span><span style="color: black;">此刻</span>，<span style="color: black;">咱们</span>想要统计<span style="color: black;">每一个</span>人的客户数，它<span style="color: black;">便是</span>一个典型的非重复计数。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选取</span>【姓名】放在透视表的【行区域】</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选取</span>【<span style="color: black;">机构</span>名<span style="color: black;">叫作</span>】放在透视表的【值区域】</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后在透视表中点击数字，<span style="color: black;">而后</span>点击鼠标右键找到【非重复计数】，至此就能得到结果</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在<span style="color: black;">实质</span>的工作中有几个<span style="color: black;">要求</span>就直接放在【行区域】<span style="color: black;">而后</span>将重复的数据放在【值区域】<span style="color: black;">就可</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/423d22649e07410f8a6fd1b389bcd231~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=HCtCD73ryR3S7aSNfzRQ3r7%2Bu08%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>WPS用户</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">WPS用户<span style="color: black;">没法</span><span style="color: black;">运用</span>透视表快速计算，就只能借助函数来做计算了，并且都是新函数版本较低的Excel<span style="color: black;">亦</span>是<span style="color: black;">没法</span><span style="color: black;">运用</span>的，<span style="color: black;">倘若</span>你是Excel用户版本<span style="color: black;">小于</span>2021用上面的<span style="color: black;">办法</span>，2021<span style="color: black;">或</span>以上这两个<span style="color: black;">办法</span>都<span style="color: black;">能够</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1. FILTER做筛选</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式：=FILTER($C$2:$C$17,$B$2:$B$17=E3)</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">想要</span>做不重复计数，<span style="color: black;">首要</span>就需要找到这个名字对应的所有【<span style="color: black;">机构</span>名<span style="color: black;">叫作</span>】，<span style="color: black;">能够</span><span style="color: black;">思虑</span><span style="color: black;">运用</span>FILTER来做数据筛选，就能找到【狄仁杰】对应的所有的<span style="color: black;">机构</span>名<span style="color: black;">叫作</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>的<span style="color: black;">要求</span>有多个，<span style="color: black;">根据</span>下面的格式来设置公式，<span style="color: black;">要求</span>有几个就几个相乘</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=FILTER(结果列,（<span style="color: black;">要求</span>列1=<span style="color: black;">要求</span>1)*(<span style="color: black;">要求</span>列2=<span style="color: black;">要求</span>2)）</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0c41a5c5dc2b414e8442d002b6116385~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=w6fOoRlEMkFSic9pa3ildkbLgmk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2. UNIQUE去重复</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式：=UNIQUE(FILTER($C$2:$C$17,$B$2:$B$17=E3))</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">UNIQUE函数的<span style="color: black;">功效</span>是去除重复值，将它嵌套在FILTER的外侧，就能得到【狄仁杰】对应的所有<span style="color: black;">机构</span>的名<span style="color: black;">叫作</span>了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c4fdb861f3534ad59a7352949cbd913f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=qzMsZjYuZpLfVmMjDDhP%2BlUYpO8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3. 不重复计数</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式：=COUNTA(UNIQUE(FILTER($C$2:$C$17,$B$2:$B$17=E3)))</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">得到不重复的<span style="color: black;">机构</span>名<span style="color: black;">叫作</span>后，直接<span style="color: black;">运用</span>COUNTA函数来统计<span style="color: black;">机构</span>的个数<span style="color: black;">就可</span>，COUNTA函数的<span style="color: black;">功效</span>是非空计数，至此公式设置完毕</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/578bdfc8c951465390587e92fbcce1a9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=46V7br1Ok4Q6BhaKVImbfdg3UOE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上<span style="color: black;">便是</span>今天分享的<span style="color: black;">所有</span>内容，你更<span style="color: black;">爱好</span>那种方式呢，<span style="color: black;">能够</span>留言讨论下~</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">倘若</span>你想要<span style="color: black;">加强</span>工作效率，不想再求同事帮你<span style="color: black;">处理</span><span style="color: black;">各样</span>Excel问题，<span style="color: black;">能够</span><span style="color: black;">认识</span>下我的专栏，WPS用户<span style="color: black;">亦</span>能<span style="color: black;">运用</span>，讲解了函数、图表、透视表、数据看板等常用功能，带你快速<span style="color: black;">作为</span>Excel<span style="color: black;">能手</span></strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a56e98cf2bc643069dfb7dc237b71c57~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727955874&x-signature=7eczW5r%2F0TY6Nt%2FNOEdA4bjCi%2B8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3.toutiaoimg.com/large/tos-cn-i-qvj2lq49k0/dc416dc28b6348a6b709954ab6330d69" style="width: 50%; margin-bottom: 20px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">Excel从入门到精通</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel从零到一</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">59币</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">2,618人已购</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
</div>
</div>
</div>
</div>
你的话语如春风拂面，让我感到无比温暖。 回顾历史，我们感慨万千；放眼未来，我们信心百倍。
页:
[1]