Excel教程：透视表统计不重复个数，快准狠
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></a></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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如下图，表格中为雨夜、<span style="color: black;">马铃薯</span>、大鹅分别负责答疑的QQ群，因统计妹子录入时开小差，中间有重复录入的，<span style="color: black;">此刻</span>需要统计各自负责QQ群的不重复个数。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTmt1Ipfia5SPa4zaLoLayYic0x4JMKSdvUcT3roHMhuqsEwZCMNA1AySQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>--数据透视表。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTrPMgnJsOguMIic98dPkHr1IBILAuib3JdfsdD26geWCz0ibxcdRpAeicHQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">透视表存放的位置<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>现有工作表的D1为<span style="color: black;">初始</span>位置,勾选现有工作表，鼠标点击D1单元格，<span style="color: black;">同期</span>勾选【将些数据添加到数据模型】<span style="color: black;">而后</span>点击确定。</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGT5yGsS7GibtiaLbntd5VxtpN3GpImOkDYEcicM70gVtWfA851e63rbqvSw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTvXfCewCqEnsvU3GmnFuJBwCiaChDjvLBEuOJTVmboCDzkcShhcul9kA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTglGtMnfO6lcGM2ymxlT91vUKbqtV0ZMSfCKWa11L4InrJ16WQIQ21Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTRXA490FhlWVWU5dvNsljBKP5iav0uSeLKYzGseDUdicedgIR1K0OvICg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>的是QQ群的不重复个数，咱们<span style="color: black;">这儿</span>不需要，删除它。鼠标选中总计单元格，右键--删除总计。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTg4L4qpOIGl3GqqN7hSwIk2AmgEZOicNaCv8kBibicX6DfnuUU2q4q3icjw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrMCkicAftuGNeAOPM3tkOMGTyuu0sXYKERBj9QRDSsRrvwO5PWYodn0oj3ZASs39QACbMRcWbCskgg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">P</span><span style="color: black;">S</span><span style="color: black;">：2</span><span style="color: black;">013</span><span style="color: black;">及以上版本才有此功能哦，低版本的<span style="color: black;">朋友</span>赶紧升级你的版本吧。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/gC0ymMIMUyFcxicmE8ibcxGaibCx4zKbZaAkecPFqGXvjkgNNibdycJp9rrI57ozZOg6OoC0da9fJTx9YuialSjzVbw/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeZBg49eW4OBN8pSRNvjemjq1h6Hd2HX6yib6iceUm74BWTWnN9oJJgZQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYn0R0X3F7GFRZSm1e7Da4V6DpPvgSUTxia4Sgib65Y345FDI6eXhNCoPQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYjibT1yuxWM3lOibxE6pX1mYdSYZia2iapHXurduQbw4RBB942ThFf8kgSQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/0jZ2JWHnNSlcJ8Y7GkHCPjrDJITwmtI8iaUHOft6Ez8licKpk2YrLrtz89RZHWpebo5E9guekDbJNHibWBY35xfYw/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">倘若</span>还有什么需要咨询的，联系<span style="color: black;">微X</span>客服18074746783</strong></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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1GXRE1YeOr3zQjYyaH5Q9B6Jwq25D1dWAPwSc0RVZFHCq9mX8L5MppkEbDKD3iaShZkudT9FFTC9fw/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrOJKwvDg8o6XkaMLSCqp9nia2x0EmTJavf1ORsQbRr3GDicoCuib6y0gAYhic1glSgDjYmcX1Dz7xkZXA/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">点击阅读原文<span style="color: black;"><strong style="color: blue;"><span style="color: black;">一键登录官网，海量视频vip任意学！(可试看)</span></strong></span></span></strong></span></p>
页:
[1]