Maaf sekali Master
Bukan saya tidak/belum mau pakai pivot table, terus terang saya masih buta
untuk tool tersebut, untuk itu rencana kan akan diadakan kelas penalaman pivot
table info dari mas hendrik, saya berminat sekali Master,
Mohon Maaf atas hal tersebut, Terimakasih banyakHairul Alam
Pada Minggu, 25 Agustus 2019 14.58.55 WIB, 'Mr. Kid' [email protected]
[belajar-excel] <[email protected]> menulis:
Kalau tidak/belum mau pakai pivot table, ubah susunan inputnya supaya jadi
lebih waras untuk diolah.
On Sun, Aug 25, 2019 at 2:43 PM HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]> wrote:
SalamRekan rekan Excel
Maaf saya belum mendapatkan solusi dengan masalah saya seperti terlampir, mohon
solusi dari rekan-rekan kalau bisa dengan menggunakan Rumus excel, karena saya
tidak/belum paham dalam penggunaan Pivot Table
Maaf dan Terimakasih banyak
AssalamualaikumHairul Alam
#yiv9768695925 #yiv9768695925 -- #yiv9768695925ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9768695925
#yiv9768695925ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9768695925
#yiv9768695925ygrp-mkp #yiv9768695925hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9768695925 #yiv9768695925ygrp-mkp #yiv9768695925ads
{margin-bottom:10px;}#yiv9768695925 #yiv9768695925ygrp-mkp .yiv9768695925ad
{padding:0 0;}#yiv9768695925 #yiv9768695925ygrp-mkp .yiv9768695925ad p
{margin:0;}#yiv9768695925 #yiv9768695925ygrp-mkp .yiv9768695925ad a
{color:#0000ff;text-decoration:none;}#yiv9768695925 #yiv9768695925ygrp-sponsor
#yiv9768695925ygrp-lc {font-family:Arial;}#yiv9768695925
#yiv9768695925ygrp-sponsor #yiv9768695925ygrp-lc #yiv9768695925hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9768695925
#yiv9768695925ygrp-sponsor #yiv9768695925ygrp-lc .yiv9768695925ad
{margin-bottom:10px;padding:0 0;}#yiv9768695925 #yiv9768695925actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9768695925
#yiv9768695925activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9768695925
#yiv9768695925activity span {font-weight:700;}#yiv9768695925
#yiv9768695925activity span:first-child
{text-transform:uppercase;}#yiv9768695925 #yiv9768695925activity span a
{color:#5085b6;text-decoration:none;}#yiv9768695925 #yiv9768695925activity span
span {color:#ff7900;}#yiv9768695925 #yiv9768695925activity span
.yiv9768695925underline {text-decoration:underline;}#yiv9768695925
.yiv9768695925attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9768695925 .yiv9768695925attach div a
{text-decoration:none;}#yiv9768695925 .yiv9768695925attach img
{border:none;padding-right:5px;}#yiv9768695925 .yiv9768695925attach label
{display:block;margin-bottom:5px;}#yiv9768695925 .yiv9768695925attach label a
{text-decoration:none;}#yiv9768695925 blockquote {margin:0 0 0
4px;}#yiv9768695925 .yiv9768695925bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9768695925
.yiv9768695925bold a {text-decoration:none;}#yiv9768695925 dd.yiv9768695925last
p a {font-family:Verdana;font-weight:700;}#yiv9768695925 dd.yiv9768695925last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9768695925
dd.yiv9768695925last p span.yiv9768695925yshortcuts
{margin-right:0;}#yiv9768695925 div.yiv9768695925attach-table div div a
{text-decoration:none;}#yiv9768695925 div.yiv9768695925attach-table
{width:400px;}#yiv9768695925 div.yiv9768695925file-title a, #yiv9768695925
div.yiv9768695925file-title a:active, #yiv9768695925
div.yiv9768695925file-title a:hover, #yiv9768695925 div.yiv9768695925file-title
a:visited {text-decoration:none;}#yiv9768695925 div.yiv9768695925photo-title a,
#yiv9768695925 div.yiv9768695925photo-title a:active, #yiv9768695925
div.yiv9768695925photo-title a:hover, #yiv9768695925
div.yiv9768695925photo-title a:visited {text-decoration:none;}#yiv9768695925
div#yiv9768695925ygrp-mlmsg #yiv9768695925ygrp-msg p a
span.yiv9768695925yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9768695925
.yiv9768695925green {color:#628c2a;}#yiv9768695925 .yiv9768695925MsoNormal
{margin:0 0 0 0;}#yiv9768695925 o {font-size:0;}#yiv9768695925
#yiv9768695925photos div {float:left;width:72px;}#yiv9768695925
#yiv9768695925photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9768695925
#yiv9768695925photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9768695925
#yiv9768695925reco-category {font-size:77%;}#yiv9768695925
#yiv9768695925reco-desc {font-size:77%;}#yiv9768695925 .yiv9768695925replbq
{margin:4px;}#yiv9768695925 #yiv9768695925ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9768695925 #yiv9768695925ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9768695925
#yiv9768695925ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9768695925
#yiv9768695925ygrp-mlmsg select, #yiv9768695925 input, #yiv9768695925 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9768695925
#yiv9768695925ygrp-mlmsg pre, #yiv9768695925 code {font:115%
monospace;}#yiv9768695925 #yiv9768695925ygrp-mlmsg *
{line-height:1.22em;}#yiv9768695925 #yiv9768695925ygrp-mlmsg #yiv9768695925logo
{padding-bottom:10px;}#yiv9768695925 #yiv9768695925ygrp-msg p a
{font-family:Verdana;}#yiv9768695925 #yiv9768695925ygrp-msg
p#yiv9768695925attach-count span {color:#1E66AE;font-weight:700;}#yiv9768695925
#yiv9768695925ygrp-reco #yiv9768695925reco-head
{color:#ff7900;font-weight:700;}#yiv9768695925 #yiv9768695925ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9768695925 #yiv9768695925ygrp-sponsor
#yiv9768695925ov li a {font-size:130%;text-decoration:none;}#yiv9768695925
#yiv9768695925ygrp-sponsor #yiv9768695925ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9768695925
#yiv9768695925ygrp-sponsor #yiv9768695925ov ul {margin:0;padding:0 0 0
8px;}#yiv9768695925 #yiv9768695925ygrp-text
{font-family:Georgia;}#yiv9768695925 #yiv9768695925ygrp-text p {margin:0 0 1em
0;}#yiv9768695925 #yiv9768695925ygrp-text tt {font-size:120%;}#yiv9768695925
#yiv9768695925ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9768695925
