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 <ha_m...@yahoo.co.id> 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' mr.nm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> 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 ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> 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