Dear Franriku, Coba buat new pivot table dengan Table Range yang sama dan
jangan lupa diclick "Add this data to The Data Model"Kemudian gunakan Formula
pada Value Field Setting "Distinct Count" TerimaKasih.
Pada Selasa, 28 April 2015 10:29, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Dear Bexcel
Mohon bantuannya, bagaimana menghitung jumlah nama tapi tidak menjumlah nama
yang sama.
contoh ada kolom jabatan dan kolom nama
dikolom nama terdapat nama yang sama, untuk nama yang sama, tidak dihitung
double.
file terlampir... mohon bantuannya
terima kasih
Franriku
#yiv1583065247 #yiv1583065247 -- #yiv1583065247ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1583065247
#yiv1583065247ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1583065247
#yiv1583065247ygrp-mkp #yiv1583065247hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1583065247 #yiv1583065247ygrp-mkp #yiv1583065247ads
{margin-bottom:10px;}#yiv1583065247 #yiv1583065247ygrp-mkp .yiv1583065247ad
{padding:0 0;}#yiv1583065247 #yiv1583065247ygrp-mkp .yiv1583065247ad p
{margin:0;}#yiv1583065247 #yiv1583065247ygrp-mkp .yiv1583065247ad a
{color:#0000ff;text-decoration:none;}#yiv1583065247 #yiv1583065247ygrp-sponsor
#yiv1583065247ygrp-lc {font-family:Arial;}#yiv1583065247
#yiv1583065247ygrp-sponsor #yiv1583065247ygrp-lc #yiv1583065247hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1583065247
#yiv1583065247ygrp-sponsor #yiv1583065247ygrp-lc .yiv1583065247ad
{margin-bottom:10px;padding:0 0;}#yiv1583065247 #yiv1583065247actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1583065247
#yiv1583065247activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1583065247
#yiv1583065247activity span {font-weight:700;}#yiv1583065247
#yiv1583065247activity span:first-child
{text-transform:uppercase;}#yiv1583065247 #yiv1583065247activity span a
{color:#5085b6;text-decoration:none;}#yiv1583065247 #yiv1583065247activity span
span {color:#ff7900;}#yiv1583065247 #yiv1583065247activity span
.yiv1583065247underline {text-decoration:underline;}#yiv1583065247
.yiv1583065247attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1583065247 .yiv1583065247attach div a
{text-decoration:none;}#yiv1583065247 .yiv1583065247attach img
{border:none;padding-right:5px;}#yiv1583065247 .yiv1583065247attach label
{display:block;margin-bottom:5px;}#yiv1583065247 .yiv1583065247attach label a
{text-decoration:none;}#yiv1583065247 blockquote {margin:0 0 0
4px;}#yiv1583065247 .yiv1583065247bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1583065247
.yiv1583065247bold a {text-decoration:none;}#yiv1583065247 dd.yiv1583065247last
p a {font-family:Verdana;font-weight:700;}#yiv1583065247 dd.yiv1583065247last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1583065247
dd.yiv1583065247last p span.yiv1583065247yshortcuts
{margin-right:0;}#yiv1583065247 div.yiv1583065247attach-table div div a
{text-decoration:none;}#yiv1583065247 div.yiv1583065247attach-table
{width:400px;}#yiv1583065247 div.yiv1583065247file-title a, #yiv1583065247
div.yiv1583065247file-title a:active, #yiv1583065247
div.yiv1583065247file-title a:hover, #yiv1583065247 div.yiv1583065247file-title
a:visited {text-decoration:none;}#yiv1583065247 div.yiv1583065247photo-title a,
#yiv1583065247 div.yiv1583065247photo-title a:active, #yiv1583065247
div.yiv1583065247photo-title a:hover, #yiv1583065247
div.yiv1583065247photo-title a:visited {text-decoration:none;}#yiv1583065247
div#yiv1583065247ygrp-mlmsg #yiv1583065247ygrp-msg p a
span.yiv1583065247yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1583065247
.yiv1583065247green {color:#628c2a;}#yiv1583065247 .yiv1583065247MsoNormal
{margin:0 0 0 0;}#yiv1583065247 o {font-size:0;}#yiv1583065247
#yiv1583065247photos div {float:left;width:72px;}#yiv1583065247
#yiv1583065247photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1583065247
#yiv1583065247photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1583065247
#yiv1583065247reco-category {font-size:77%;}#yiv1583065247
#yiv1583065247reco-desc {font-size:77%;}#yiv1583065247 .yiv1583065247replbq
{margin:4px;}#yiv1583065247 #yiv1583065247ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1583065247 #yiv1583065247ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1583065247
#yiv1583065247ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1583065247
#yiv1583065247ygrp-mlmsg select, #yiv1583065247 input, #yiv1583065247 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1583065247
#yiv1583065247ygrp-mlmsg pre, #yiv1583065247 code {font:115%
monospace;}#yiv1583065247 #yiv1583065247ygrp-mlmsg *
{line-height:1.22em;}#yiv1583065247 #yiv1583065247ygrp-mlmsg #yiv1583065247logo
{padding-bottom:10px;}#yiv1583065247 #yiv1583065247ygrp-msg p a
{font-family:Verdana;}#yiv1583065247 #yiv1583065247ygrp-msg
p#yiv1583065247attach-count span {color:#1E66AE;font-weight:700;}#yiv1583065247
#yiv1583065247ygrp-reco #yiv1583065247reco-head
{color:#ff7900;font-weight:700;}#yiv1583065247 #yiv1583065247ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1583065247 #yiv1583065247ygrp-sponsor
#yiv1583065247ov li a {font-size:130%;text-decoration:none;}#yiv1583065247
#yiv1583065247ygrp-sponsor #yiv1583065247ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1583065247
#yiv1583065247ygrp-sponsor #yiv1583065247ov ul {margin:0;padding:0 0 0
8px;}#yiv1583065247 #yiv1583065247ygrp-text
{font-family:Georgia;}#yiv1583065247 #yiv1583065247ygrp-text p {margin:0 0 1em
0;}#yiv1583065247 #yiv1583065247ygrp-text tt {font-size:120%;}#yiv1583065247
#yiv1583065247ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1583065247
