SalamMr.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
#yiv4231528535 #yiv4231528535 -- #yiv4231528535ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4231528535
#yiv4231528535ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4231528535
#yiv4231528535ygrp-mkp #yiv4231528535hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4231528535 #yiv4231528535ygrp-mkp #yiv4231528535ads
{margin-bottom:10px;}#yiv4231528535 #yiv4231528535ygrp-mkp .yiv4231528535ad
{padding:0 0;}#yiv4231528535 #yiv4231528535ygrp-mkp .yiv4231528535ad p
{margin:0;}#yiv4231528535 #yiv4231528535ygrp-mkp .yiv4231528535ad a
{color:#0000ff;text-decoration:none;}#yiv4231528535 #yiv4231528535ygrp-sponsor
#yiv4231528535ygrp-lc {font-family:Arial;}#yiv4231528535
#yiv4231528535ygrp-sponsor #yiv4231528535ygrp-lc #yiv4231528535hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4231528535
#yiv4231528535ygrp-sponsor #yiv4231528535ygrp-lc .yiv4231528535ad
{margin-bottom:10px;padding:0 0;}#yiv4231528535 #yiv4231528535actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4231528535
#yiv4231528535activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4231528535
#yiv4231528535activity span {font-weight:700;}#yiv4231528535
#yiv4231528535activity span:first-child
{text-transform:uppercase;}#yiv4231528535 #yiv4231528535activity span a
{color:#5085b6;text-decoration:none;}#yiv4231528535 #yiv4231528535activity span
span {color:#ff7900;}#yiv4231528535 #yiv4231528535activity span
.yiv4231528535underline {text-decoration:underline;}#yiv4231528535
.yiv4231528535attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4231528535 .yiv4231528535attach div a
{text-decoration:none;}#yiv4231528535 .yiv4231528535attach img
{border:none;padding-right:5px;}#yiv4231528535 .yiv4231528535attach label
{display:block;margin-bottom:5px;}#yiv4231528535 .yiv4231528535attach label a
{text-decoration:none;}#yiv4231528535 blockquote {margin:0 0 0
4px;}#yiv4231528535 .yiv4231528535bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4231528535
.yiv4231528535bold a {text-decoration:none;}#yiv4231528535 dd.yiv4231528535last
p a {font-family:Verdana;font-weight:700;}#yiv4231528535 dd...yiv4231528535last
p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4231528535
dd.yiv4231528535last p span.yiv4231528535yshortcuts
{margin-right:0;}#yiv4231528535 div.yiv4231528535attach-table div div a
{text-decoration:none;}#yiv4231528535 div.yiv4231528535attach-table
{width:400px;}#yiv4231528535 div.yiv4231528535file-title a, #yiv4231528535
div.yiv4231528535file-title a:active, #yiv4231528535
div.yiv4231528535file-title a:hover, #yiv4231528535 div.yiv4231528535file-title
a:visited {text-decoration:none;}#yiv4231528535 div.yiv4231528535photo-title a,
#yiv4231528535 div.yiv4231528535photo-title a:active, #yiv4231528535
div.yiv4231528535photo-title a:hover, #yiv4231528535
div.yiv4231528535photo-title a:visited {text-decoration:none;}#yiv4231528535
div#yiv4231528535ygrp-mlmsg #yiv4231528535ygrp-msg p a
span.yiv4231528535yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4231528535
.yiv4231528535green {color:#628c2a;}#yiv4231528535 .yiv4231528535MsoNormal
{margin:0 0 0 0;}#yiv4231528535 o {font-size:0;}#yiv4231528535
#yiv4231528535photos div {float:left;width:72px;}#yiv4231528535
#yiv4231528535photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4231528535
#yiv4231528535photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4231528535
#yiv4231528535reco-category {font-size:77%;}#yiv4231528535
#yiv4231528535reco-desc {font-size:77%;}#yiv4231528535 .yiv4231528535replbq
{margin:4px;}#yiv4231528535 #yiv4231528535ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4231528535 #yiv4231528535ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4231528535
#yiv4231528535ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4231528535
#yiv4231528535ygrp-mlmsg select, #yiv4231528535 input, #yiv4231528535 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4231528535
#yiv4231528535ygrp-mlmsg pre, #yiv4231528535 code {font:115%
monospace;}#yiv4231528535 #yiv4231528535ygrp-mlmsg *
{line-height:1.22em;}#yiv4231528535 #yiv4231528535ygrp-mlmsg #yiv4231528535logo
{padding-bottom:10px;}#yiv4231528535 #yiv4231528535ygrp-msg p a
{font-family:Verdana;}#yiv4231528535 #yiv4231528535ygrp-msg
p#yiv4231528535attach-count span {color:#1E66AE;font-weight:700;}#yiv4231528535
#yiv4231528535ygrp-reco #yiv4231528535reco-head
{color:#ff7900;font-weight:700;}#yiv4231528535 #yiv4231528535ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4231528535 #yiv4231528535ygrp-sponsor
#yiv4231528535ov li a {font-size:130%;text-decoration:none;}#yiv4231528535
#yiv4231528535ygrp-sponsor #yiv4231528535ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4231528535
#yiv4231528535ygrp-sponsor #yiv4231528535ov ul {margin:0;padding:0 0 0
8px;}#yiv4231528535 #yiv4231528535ygrp-text
{font-family:Georgia;}#yiv4231528535 #yiv4231528535ygrp-text p {margin:0 0 1em
0;}#yiv4231528535 #yiv4231528535ygrp-text tt {font-size:120%;}#yiv4231528535
#yiv4231528535ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4231528535
