Maaf Pak Selain menggunakan Pivot Table apa ada rumus yang bisa dipakai misalkan SUMIF Terimakasih Pada Senin, 19 Agustus 2019 09.40.28 WIB, HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Salam Mr.Kid Maaf, selain menggunakan pivot table, apakah bisa dengan menggunakan Rumus misalnya menggunakan Sumif... Terimakasih Dikirim dari Yahoo Mail di Android Pada Sen, 19 Agt 2019 pada 0:41, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis: Kalau begitu, mulailah belajar Excel Pivot Table.Sekalian dengan Power Query.Bila perlu dengan Power Pivot. Regards,Kid On Mon, Aug 19, 2019 at 12:39 AM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Salam Mr.Kid Terimakasih Banyak Solusi untuk penggunaan Pivot table sangat baik, terus terang saya belum paham dalam penggunaan pivot table dan sebenarnya dalam table atau masalah table seperti yang saya buat sangat cocok jika menggunakan pivot table. dan selama ini saya selalu menggunakan rumus, Assalamualaikum Wr. Wb.Hairul Alam Pada Senin, 19 Agustus 2019 00.16.43 WIB, 'Mr. Kid' mr.nm...@gmail..com [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Pakai Pivot Table hasil transformasi.Pivot atas berdasar data yang adaPivot bawah berdasar kombinasi item dari dimensi penyusun output Regards,Kid On Sat, Aug 17, 2019 at 10:58 AM HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Selamat Pagi Para Master yang Baik Semoga semua dalam Keadaan baik dan sehat selalu tentunya Saya mempunyai masalah mengenai Rumus Excel dari 2 sheet ; INPUT dan hasilnya di OUTPUT seperti apa rumusnya jika code yang digunakan dari code 1 sampai 100 Kolom Code Range T(R/H) ungu / V(F) biru muda / W(C) kuning = Kolom Nilainya Range R/H ( X s/d AB) ungu / F ( AC s/d AE) biru muda / C ( AF s/d AG ) kuning Sheet ("INPUT") Row U5 : code 21/30 dan V5 : code 50 hasilnya terbagi sesuai kolom Y sampai AH dimana : code 21 = 30 code 30 = 10 code 50 = 15 Sheet ("INPUT") Row W6 : code : 34 dan hasilnya terbagi sesuai kolom Y sampai AH dimana : 34 = 25 Hasilnya pada sheets ("OUTPUT") range B sampai CW seperti Data Terlampir Terimakasih Banyak Assalamualaikum Wr. Wb. Hairul Alam #yiv7070494320 #yiv7070494320 -- #yiv7070494320ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7070494320 #yiv7070494320ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7070494320 #yiv7070494320ygrp-mkp #yiv7070494320hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7070494320 #yiv7070494320ygrp-mkp #yiv7070494320ads {margin-bottom:10px;}#yiv7070494320 #yiv7070494320ygrp-mkp .yiv7070494320ad {padding:0 0;}#yiv7070494320 #yiv7070494320ygrp-mkp .yiv7070494320ad p {margin:0;}#yiv7070494320 #yiv7070494320ygrp-mkp .yiv7070494320ad a {color:#0000ff;text-decoration:none;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ygrp-lc {font-family:Arial;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ygrp-lc #yiv7070494320hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ygrp-lc .yiv7070494320ad {margin-bottom:10px;padding:0 0;}#yiv7070494320 #yiv7070494320actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7070494320 #yiv7070494320activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7070494320 #yiv7070494320activity span {font-weight:700;}#yiv7070494320 #yiv7070494320activity span:first-child {text-transform:uppercase;}#yiv7070494320 #yiv7070494320activity span a {color:#5085b6;text-decoration:none;}#yiv7070494320 #yiv7070494320activity span span {color:#ff7900;}#yiv7070494320 #yiv7070494320activity span .yiv7070494320underline {text-decoration:underline;}#yiv7070494320 .yiv7070494320attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7070494320 .yiv7070494320attach div a {text-decoration:none;}#yiv7070494320 .yiv7070494320attach img {border:none;padding-right:5px;}#yiv7070494320 .yiv7070494320attach label {display:block;margin-bottom:5px;}#yiv7070494320 .yiv7070494320attach label a {text-decoration:none;}#yiv7070494320 blockquote {margin:0 0 0 4px;}#yiv7070494320 .yiv7070494320bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7070494320 .yiv7070494320bold a {text-decoration:none;}#yiv7070494320 dd.yiv7070494320last p a {font-family:Verdana;font-weight:700;}#yiv7070494320 dd.yiv7070494320last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7070494320 dd.yiv7070494320last p span.yiv7070494320yshortcuts {margin-right:0;}#yiv7070494320 div.yiv7070494320attach-table div div a {text-decoration:none;}#yiv7070494320 div.yiv7070494320attach-table {width:400px;}#yiv7070494320 div.yiv7070494320file-title a, #yiv7070494320 div.yiv7070494320file-title a:active, #yiv7070494320 div.yiv7070494320file-title a:hover, #yiv7070494320 div.yiv7070494320file-title a:visited {text-decoration:none;}#yiv7070494320 div.yiv7070494320photo-title a, #yiv7070494320 div.yiv7070494320photo-title a:active, #yiv7070494320 div.yiv7070494320photo-title a:hover, #yiv7070494320 div.yiv7070494320photo-title a:visited {text-decoration:none;}#yiv7070494320 div#yiv7070494320ygrp-mlmsg #yiv7070494320ygrp-msg p a span.yiv7070494320yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7070494320 .yiv7070494320green {color:#628c2a;}#yiv7070494320 .yiv7070494320MsoNormal {margin:0 0 0 0;}#yiv7070494320 o {font-size:0;}#yiv7070494320 #yiv7070494320photos div {float:left;width:72px;}#yiv7070494320 #yiv7070494320photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7070494320 #yiv7070494320photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7070494320 #yiv7070494320reco-category {font-size:77%;}#yiv7070494320 #yiv7070494320reco-desc {font-size:77%;}#yiv7070494320 .yiv7070494320replbq {margin:4px;}#yiv7070494320 #yiv7070494320ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7070494320 #yiv7070494320ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7070494320 #yiv7070494320ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7070494320 #yiv7070494320ygrp-mlmsg select, #yiv7070494320 input, #yiv7070494320 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7070494320 #yiv7070494320ygrp-mlmsg pre, #yiv7070494320 code {font:115% monospace;}#yiv7070494320 #yiv7070494320ygrp-mlmsg * {line-height:1.22em;}#yiv7070494320 #yiv7070494320ygrp-mlmsg #yiv7070494320logo {padding-bottom:10px;}#yiv7070494320 #yiv7070494320ygrp-msg p a {font-family:Verdana;}#yiv7070494320 #yiv7070494320ygrp-msg p#yiv7070494320attach-count span {color:#1E66AE;font-weight:700;}#yiv7070494320 #yiv7070494320ygrp-reco #yiv7070494320reco-head {color:#ff7900;font-weight:700;}#yiv7070494320 #yiv7070494320ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ov li a {font-size:130%;text-decoration:none;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7070494320 #yiv7070494320ygrp-sponsor #yiv7070494320ov ul {margin:0;padding:0 0 0 8px;}#yiv7070494320 #yiv7070494320ygrp-text {font-family:Georgia;}#yiv7070494320 #yiv7070494320ygrp-text p {margin:0 0 1em 0;}#yiv7070494320 #yiv7070494320ygrp-text tt {font-size:120%;}#yiv7070494320 #yiv7070494320ygrp-vital ul li:last-child {border-right:none !important;}#yiv7070494320