Selamat malam Mr.Kid
untuk kasus saya, terus terang bolak balik saya mencoba untuk power pivod yang
mr.kid berikan kemarin lusa, bolehkan, diberikan sedikit langkahnya seperti
yang mr.kid lampirkan, harus mulai darimana agar jadi seperti itu.
saya kelik i sheet Output ada pivot max of nilai dan muncul field : J
NO/DATE/RT DATE/RESULT/LOKASI/KeyJNOlokasi/RHFC/detil/idxLOKASI/NILAI,
berulang saya cari tapi tidak ketemu
Maaf Beribu Maaf Mr.Kid, saya mau belajar
Terimakasih Banyak
Assalamualaikum wr. wb. Pada Minggu, 25 Agustus 2019 15.19.09 WIB, HAIRUL
ALAM <[email protected]> menulis:
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
#yiv8914257605 -- #yiv8914257605ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8914257605
#yiv8914257605ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8914257605
#yiv8914257605ygrp-mkp #yiv8914257605hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8914257605 #yiv8914257605ygrp-mkp #yiv8914257605ads
{margin-bottom:10px;}#yiv8914257605 #yiv8914257605ygrp-mkp .yiv8914257605ad
{padding:0 0;}#yiv8914257605 #yiv8914257605ygrp-mkp .yiv8914257605ad p
{margin:0;}#yiv8914257605 #yiv8914257605ygrp-mkp .yiv8914257605ad a
{color:#0000ff;text-decoration:none;}#yiv8914257605 #yiv8914257605ygrp-sponsor
#yiv8914257605ygrp-lc {font-family:Arial;}#yiv8914257605
#yiv8914257605ygrp-sponsor #yiv8914257605ygrp-lc #yiv8914257605hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8914257605
#yiv8914257605ygrp-sponsor #yiv8914257605ygrp-lc .yiv8914257605ad
{margin-bottom:10px;padding:0 0;}#yiv8914257605 #yiv8914257605actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8914257605
#yiv8914257605activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8914257605
#yiv8914257605activity span {font-weight:700;}#yiv8914257605
#yiv8914257605activity span:first-child
{text-transform:uppercase;}#yiv8914257605 #yiv8914257605activity span a
{color:#5085b6;text-decoration:none;}#yiv8914257605 #yiv8914257605activity span
span {color:#ff7900;}#yiv8914257605 #yiv8914257605activity span
.yiv8914257605underline {text-decoration:underline;}#yiv8914257605
.yiv8914257605attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8914257605 .yiv8914257605attach div a
{text-decoration:none;}#yiv8914257605 .yiv8914257605attach img
{border:none;padding-right:5px;}#yiv8914257605 .yiv8914257605attach label
{display:block;margin-bottom:5px;}#yiv8914257605 .yiv8914257605attach label a
{text-decoration:none;}#yiv8914257605 blockquote {margin:0 0 0
4px;}#yiv8914257605 .yiv8914257605bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8914257605
.yiv8914257605bold a {text-decoration:none;}#yiv8914257605 dd.yiv8914257605last
p a {font-family:Verdana;font-weight:700;}#yiv8914257605 dd...yiv8914257605last
p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8914257605
dd.yiv8914257605last p span.yiv8914257605yshortcuts
{margin-right:0;}#yiv8914257605 div.yiv8914257605attach-table div div a
{text-decoration:none;}#yiv8914257605 div.yiv8914257605attach-table
{width:400px;}#yiv8914257605 div.yiv8914257605file-title a, #yiv8914257605
div.yiv8914257605file-title a:active, #yiv8914257605
div.yiv8914257605file-title a:hover, #yiv8914257605 div.yiv8914257605file-title
a:visited {text-decoration:none;}#yiv8914257605 div.yiv8914257605photo-title a,
#yiv8914257605 div.yiv8914257605photo-title a:active, #yiv8914257605
div.yiv8914257605photo-title a:hover, #yiv8914257605
div.yiv8914257605photo-title a:visited {text-decoration:none;}#yiv8914257605
div#yiv8914257605ygrp-mlmsg #yiv8914257605ygrp-msg p a
span.yiv8914257605yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8914257605
.yiv8914257605green {color:#628c2a;}#yiv8914257605 .yiv8914257605MsoNormal
{margin:0 0 0 0;}#yiv8914257605 o {font-size:0;}#yiv8914257605
#yiv8914257605photos div {float:left;width:72px;}#yiv8914257605
#yiv8914257605photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8914257605
#yiv8914257605photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8914257605
#yiv8914257605reco-category {font-size:77%;}#yiv8914257605
#yiv8914257605reco-desc {font-size:77%;}#yiv8914257605 .yiv8914257605replbq
{margin:4px;}#yiv8914257605 #yiv8914257605ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8914257605 #yiv8914257605ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8914257605
#yiv8914257605ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8914257605
#yiv8914257605ygrp-mlmsg select, #yiv8914257605 input, #yiv8914257605 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8914257605
#yiv8914257605ygrp-mlmsg pre, #yiv8914257605 code {font:115%
monospace;}#yiv8914257605 #yiv8914257605ygrp-mlmsg *
{line-height:1.22em;}#yiv8914257605 #yiv8914257605ygrp-mlmsg #yiv8914257605logo
{padding-bottom:10px;}#yiv8914257605 #yiv8914257605ygrp-msg p a
{font-family:Verdana;}#yiv8914257605 #yiv8914257605ygrp-msg
p#yiv8914257605attach-count span {color:#1E66AE;font-weight:700;}#yiv8914257605
#yiv8914257605ygrp-reco #yiv8914257605reco-head
{color:#ff7900;font-weight:700;}#yiv8914257605 #yiv8914257605ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8914257605 #yiv8914257605ygrp-sponsor
#yiv8914257605ov li a {font-size:130%;text-decoration:none;}#yiv8914257605
#yiv8914257605ygrp-sponsor #yiv8914257605ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8914257605
#yiv8914257605ygrp-sponsor #yiv8914257605ov ul {margin:0;padding:0 0 0
8px;}#yiv8914257605 #yiv8914257605ygrp-text
{font-family:Georgia;}#yiv8914257605 #yiv8914257605ygrp-text p {margin:0 0 1em
0;}#yiv8914257605 #yiv8914257605ygrp-text tt {font-size:120%;}#yiv8914257605
#yiv8914257605ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8914257605
