[belajar-excel] Digest Number 4823

Milis Belajar Microsoft Excel Group

1 Message

Digest #4823

1a

Bls: Re: [belajar-excel] Hasil dari beberapa kriteria dan jumlah by "HAIRUL ALAM"

Message

1a

Bls: Re: [belajar-excel] Hasil dari beberapa kriteria dan jumlah

Sun Aug 18, 2019 7:39 pm (PDT) . Posted by:

"HAIRUL ALAM"

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.nmkid@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_mj76@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.nmkid@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_mj76@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

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use