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_bal7...@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   
  • [belajar-excel] M... Kamirin Faqoth kamiri...@yahoo.co.id [belajar-excel]
    • Re: [belajar... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
      • Fw: [bel... hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]
        • Re: ... Kamirin Faqoth kamiri...@yahoo.co.id [belajar-excel]
    • Re: [belajar... Kamirin Faqoth kamiri...@yahoo.co.id [belajar-excel]
      • Re: [bel... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
        • Re: ... Kamirin Faqoth kamiri...@yahoo.co.id [belajar-excel]

Kirim email ke