[belajar-excel] Digest Number 4888

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4888

1a

Re: Mencari Nilai dengan Kriteria Khusus [1 Attachment] by "Kamirin Faqoth" kamirin_2

2

Rumus Mengambil Nilai dengan mengabaikan kriteria tertentu by "Kamirin Faqoth" kamirin_2

Messages

1a

Re: Mencari Nilai dengan Kriteria Khusus [1 Attachment]

Sat Oct 26, 2019 5:10 am (PDT) . Posted by:

"Kamirin Faqoth" kamirin_2

Dear Pa Iqbal,

Maaf, bisa dijelaskan tentang apa itu Power Query &  step by stepnya dari kasus saya bagaimana yaa pengerjaannya?
Maaf, Saya masih awam tentang power query?

Terima Kasih

Pada Rabu, 23 Oktober 2019 04.06.57 WIB, iq_bal76id@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Hi Kamirin,

Bisa di gunakan power query

 

 

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

 

 

 

From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
Sent: Tuesday, October 22, 2019 3:50 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mencari Nilai dengan Kriteria Khusus [1 Attachment]

 

 

Dear All Member,

 

Mohon bantuannya, saya agak kesulitan mencari nilai dengan kriteria khusus pada tabel data yang sifatnya statis, dengan acuan tabel yang saya tandain warna kuning dan

dengan mengabaikan tabel yang tandain warna merah, Berikut Contoh Potongan File terlampir, terdiri dari 20 baris, file aslinya lebih dari 1000 baris.

 

Terim Kasih,

Kamirin

#yiv9040544485 #yiv9040544485 -- #yiv9040544485ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9040544485 #yiv9040544485ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9040544485 #yiv9040544485ygrp-mkp #yiv9040544485hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9040544485 #yiv9040544485ygrp-mkp #yiv9040544485ads {margin-bottom:10px;}#yiv9040544485 #yiv9040544485ygrp-mkp .yiv9040544485ad {padding:0 0;}#yiv9040544485 #yiv9040544485ygrp-mkp .yiv9040544485ad p {margin:0;}#yiv9040544485 #yiv9040544485ygrp-mkp .yiv9040544485ad a {color:#0000ff;text-decoration:none;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ygrp-lc {font-family:Arial;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ygrp-lc #yiv9040544485hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ygrp-lc .yiv9040544485ad {margin-bottom:10px;padding:0 0;}#yiv9040544485 #yiv9040544485actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9040544485 #yiv9040544485activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9040544485 #yiv9040544485activity span {font-weight:700;}#yiv9040544485 #yiv9040544485activity span:first-child {text-transform:uppercase;}#yiv9040544485 #yiv9040544485activity span a {color:#5085b6;text-decoration:none;}#yiv9040544485 #yiv9040544485activity span span {color:#ff7900;}#yiv9040544485 #yiv9040544485activity span .yiv9040544485underline {text-decoration:underline;}#yiv9040544485 ..yiv9040544485attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9040544485 .yiv9040544485attach div a {text-decoration:none;}#yiv9040544485 .yiv9040544485attach img {border:none;padding-right:5px;}#yiv9040544485 .yiv9040544485attach label {display:block;margin-bottom:5px;}#yiv9040544485 .yiv9040544485attach label a {text-decoration:none;}#yiv9040544485 blockquote {margin:0 0 0 4px;}#yiv9040544485 .yiv9040544485bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9040544485 .yiv9040544485bold a {text-decoration:none;}#yiv9040544485 dd.yiv9040544485last p a {font-family:Verdana;font-weight:700;}#yiv9040544485 dd.yiv9040544485last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9040544485 dd.yiv9040544485last p span.yiv9040544485yshortcuts {margin-right:0;}#yiv9040544485 div.yiv9040544485attach-table div div a {text-decoration:none;}#yiv9040544485 div.yiv9040544485attach-table {width:400px;}#yiv9040544485 div.yiv9040544485file-title a, #yiv9040544485 div.yiv9040544485file-title a:active, #yiv9040544485 div.yiv9040544485file-title a:hover, #yiv9040544485 div.yiv9040544485file-title a:visited {text-decoration:none;}#yiv9040544485 div.yiv9040544485photo-title a, #yiv9040544485 div.yiv9040544485photo-title a:active, #yiv9040544485 div.yiv9040544485photo-title a:hover, #yiv9040544485 div.yiv9040544485photo-title a:visited {text-decoration:none;}#yiv9040544485 div#yiv9040544485ygrp-mlmsg #yiv9040544485ygrp-msg p a span.yiv9040544485yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9040544485 .yiv9040544485green {color:#628c2a;}#yiv9040544485 .yiv9040544485MsoNormal {margin:0 0 0 0;}#yiv9040544485 o {font-size:0;}#yiv9040544485 #yiv9040544485photos div {float:left;width:72px;}#yiv9040544485 #yiv9040544485photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9040544485 #yiv9040544485photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9040544485 #yiv9040544485reco-category {font-size:77%;}#yiv9040544485 #yiv9040544485reco-desc {font-size:77%;}#yiv9040544485 .yiv9040544485replbq {margin:4px;}#yiv9040544485 #yiv9040544485ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9040544485 #yiv9040544485ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9040544485 #yiv9040544485ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9040544485 #yiv9040544485ygrp-mlmsg select, #yiv9040544485 input, #yiv9040544485 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9040544485 #yiv9040544485ygrp-mlmsg pre, #yiv9040544485 code {font:115% monospace;}#yiv9040544485 #yiv9040544485ygrp-mlmsg * {line-height:1.22em;}#yiv9040544485 #yiv9040544485ygrp-mlmsg #yiv9040544485logo {padding-bottom:10px;}#yiv9040544485 #yiv9040544485ygrp-msg p a {font-family:Verdana;}#yiv9040544485 #yiv9040544485ygrp-msg p#yiv9040544485attach-count span {color:#1E66AE;font-weight:700;}#yiv9040544485 #yiv9040544485ygrp-reco #yiv9040544485reco-head {color:#ff7900;font-weight:700;}#yiv9040544485 #yiv9040544485ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ov li a {font-size:130%;text-decoration:none;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9040544485 #yiv9040544485ygrp-sponsor #yiv9040544485ov ul {margin:0;padding:0 0 0 8px;}#yiv9040544485 #yiv9040544485ygrp-text {font-family:Georgia;}#yiv9040544485 #yiv9040544485ygrp-text p {margin:0 0 1em 0;}#yiv9040544485 #yiv9040544485ygrp-text tt {font-size:120%;}#yiv9040544485 #yiv9040544485ygrp-vital ul li:last-child {border-right:none !important;}#yiv9040544485

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

2

Rumus Mengambil Nilai dengan mengabaikan kriteria tertentu

Sat Oct 26, 2019 5:38 am (PDT) . Posted by:

"Kamirin Faqoth" kamirin_2

Dear All Member Be-Exceller
Mohon bantuannya, saya ingin mengambil suatu nilai dari tabel tertentu, tapi dengan mengabaikan baris yang saya tandai warna biru & merah.Berikut saya kirimkan Contoh Filenya

Terima KasihKamirin

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . 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