Dear Mr Kid,
Terima kasih atas atas petunjuknya, tapi sepertinya saya belum bisa 
mengaplikasikan power query dikarenakan PC yang saya gunakan adalah PC Client, 
jadi kalau install Add Ins harus dari servernya, makanya saya lebih nyaman 
menggunakan mega formula aja untuk saat ini
Salam,Kamirin

    Pada Senin, 28 Oktober 2019 20.20.44 WIB, 'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  

Coba unduh materi kopdar 3, bisa disini 
:https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
atau disini 
:https://drive.google.com/file/d/1oXf4cE8CzZhqvEJE-_dvvbMUtTFYrctT/view?usp=sharing
atau di folder files milis di gdrive berikut 
:https://drive.google.com/drive/folders/1JoNf0qm5xgXDsRDaI3I85r_YZOAsiEoO?usp=sharing
ke folder materi kopdar, unduh file kopdar_03




On Sat, Oct 26, 2019 at 7:10 PM Kamirin Faqoth kamiri...@yahoo.co.id 
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  

 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




   
  #yiv5552883195 #yiv5552883195 -- #yiv5552883195ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5552883195 
#yiv5552883195ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5552883195 
#yiv5552883195ygrp-mkp #yiv5552883195hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5552883195 #yiv5552883195ygrp-mkp #yiv5552883195ads 
{margin-bottom:10px;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad 
{padding:0 0;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad p 
{margin:0;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad a 
{color:#0000ff;text-decoration:none;}#yiv5552883195 #yiv5552883195ygrp-sponsor 
#yiv5552883195ygrp-lc {font-family:Arial;}#yiv5552883195 
#yiv5552883195ygrp-sponsor #yiv5552883195ygrp-lc #yiv5552883195hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5552883195 
#yiv5552883195ygrp-sponsor #yiv5552883195ygrp-lc .yiv5552883195ad 
{margin-bottom:10px;padding:0 0;}#yiv5552883195 #yiv5552883195actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5552883195 
#yiv5552883195activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5552883195
 #yiv5552883195activity span {font-weight:700;}#yiv5552883195 
#yiv5552883195activity span:first-child 
{text-transform:uppercase;}#yiv5552883195 #yiv5552883195activity span a 
{color:#5085b6;text-decoration:none;}#yiv5552883195 #yiv5552883195activity span 
span {color:#ff7900;}#yiv5552883195 #yiv5552883195activity span 
.yiv5552883195underline {text-decoration:underline;}#yiv5552883195 
.yiv5552883195attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5552883195 .yiv5552883195attach div a 
{text-decoration:none;}#yiv5552883195 .yiv5552883195attach img 
{border:none;padding-right:5px;}#yiv5552883195 .yiv5552883195attach label 
{display:block;margin-bottom:5px;}#yiv5552883195 .yiv5552883195attach label a 
{text-decoration:none;}#yiv5552883195 blockquote {margin:0 0 0 
4px;}#yiv5552883195 .yiv5552883195bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5552883195 
.yiv5552883195bold a {text-decoration:none;}#yiv5552883195 dd.yiv5552883195last 
p a {font-family:Verdana;font-weight:700;}#yiv5552883195 dd.yiv5552883195last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5552883195 
dd.yiv5552883195last p span.yiv5552883195yshortcuts 
{margin-right:0;}#yiv5552883195 div.yiv5552883195attach-table div div a 
{text-decoration:none;}#yiv5552883195 div.yiv5552883195attach-table 
{width:400px;}#yiv5552883195 div.yiv5552883195file-title a, #yiv5552883195 
div.yiv5552883195file-title a:active, #yiv5552883195 
div.yiv5552883195file-title a:hover, #yiv5552883195 div.yiv5552883195file-title 
a:visited {text-decoration:none;}#yiv5552883195 div.yiv5552883195photo-title a, 
#yiv5552883195 div.yiv5552883195photo-title a:active, #yiv5552883195 
div.yiv5552883195photo-title a:hover, #yiv5552883195 
div.yiv5552883195photo-title a:visited {text-decoration:none;}#yiv5552883195 
div#yiv5552883195ygrp-mlmsg #yiv5552883195ygrp-msg p a 
span.yiv5552883195yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5552883195 
.yiv5552883195green {color:#628c2a;}#yiv5552883195 .yiv5552883195MsoNormal 
{margin:0 0 0 0;}#yiv5552883195 o {font-size:0;}#yiv5552883195 
#yiv5552883195photos div {float:left;width:72px;}#yiv5552883195 
#yiv5552883195photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5552883195 
#yiv5552883195photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5552883195
 #yiv5552883195reco-category {font-size:77%;}#yiv5552883195 
#yiv5552883195reco-desc {font-size:77%;}#yiv5552883195 .yiv5552883195replbq 
{margin:4px;}#yiv5552883195 #yiv5552883195ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv5552883195 #yiv5552883195ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5552883195 
#yiv5552883195ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5552883195 
#yiv5552883195ygrp-mlmsg select, #yiv5552883195 input, #yiv5552883195 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5552883195 
#yiv5552883195ygrp-mlmsg pre, #yiv5552883195 code {font:115% 
monospace;}#yiv5552883195 #yiv5552883195ygrp-mlmsg * 
{line-height:1.22em;}#yiv5552883195 #yiv5552883195ygrp-mlmsg #yiv5552883195logo 
{padding-bottom:10px;}#yiv5552883195 #yiv5552883195ygrp-msg p a 
{font-family:Verdana;}#yiv5552883195 #yiv5552883195ygrp-msg 
p#yiv5552883195attach-count span {color:#1E66AE;font-weight:700;}#yiv5552883195 
#yiv5552883195ygrp-reco #yiv5552883195reco-head 
{color:#ff7900;font-weight:700;}#yiv5552883195 #yiv5552883195ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv5552883195 #yiv5552883195ygrp-sponsor 
#yiv5552883195ov li a {font-size:130%;text-decoration:none;}#yiv5552883195 
#yiv5552883195ygrp-sponsor #yiv5552883195ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5552883195 
#yiv5552883195ygrp-sponsor #yiv5552883195ov ul {margin:0;padding:0 0 0 
8px;}#yiv5552883195 #yiv5552883195ygrp-text 
{font-family:Georgia;}#yiv5552883195 #yiv5552883195ygrp-text p {margin:0 0 1em 
0;}#yiv5552883195 #yiv5552883195ygrp-text tt {font-size:120%;}#yiv5552883195 
#yiv5552883195ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv5552883195   
  • [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