[belajar-excel] Digest Number 4848

Milis Belajar Microsoft Excel Group

12 Messages

Digest #4848

1a

Mencari Nilai dengan 3 Kriteria by "Kamirin Faqoth" kamirin_2

1b

Re: Mencari Nilai dengan 3 Kriteria [1 Attachment] by "Agus"

2a

Lookup2 by "HAIRUL ALAM"

2b

Re: Lookup2 by "hendrik karnadi" hendrikkarnadi

2c

Re: Lookup2 by "ghozi alkatiri" ghozialkatiri

2d

Re: Lookup2 [1 Attachment] by "HAIRUL ALAM"

2e

Re: Lookup2 by "HAIRUL ALAM"

3a

data tampil pada list box by "HAIRUL ALAM"

3b

Re: data tampil pada list box [1 Attachment] by "Agus"

3c

Re: data tampil pada list box by "HAIRUL ALAM"

4a

Re: Rencana kopdar by iq_bal76id

5

[belajar excel] Mencari data pada table by "jackie yunianto" tanfidzularus

Messages

1a

Mencari Nilai dengan 3 Kriteria

Sat Sep 14, 2019 10:46 pm (PDT) . Posted by:

"Kamirin Faqoth" kamirin_2

Dear Member Be-Excel,
Mohon solusinya, saya sedang mencari suatu nilai dengan 3 kriteria dan memakai fungsi Index-Match, tapi kenapa ya, pada sheet rekap, ketika sy menggunakan salah satu kriteria dengan angka 201, hasilnya berjalan sesuai harapan, tapi ketika angkanya diganti dengan 202, 203 dst koq hasilnya blank yaa.

Terima kasih sebelumnya atas support para suhu & member B-Excel.

Salam,kamirin

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

1b

Re: Mencari Nilai dengan 3 Kriteria [1 Attachment]

Sun Sep 15, 2019 2:44 am (PDT) . Posted by:

"Agus"

Dear Kamarin,
Coba baca kembali Helepnya Index.

*INDEX*(*array*,row_num,column_num)

*INDEX*(*reference*,row_num,column_num,area_num)

Formula anda dapat diperbaiki dengan dua cara sesuai sintaknya index:
1. Cara pertama menggunakan sintak pertama. (membutuhkan baris bantuan)
-> pada sheet Detail di cell C4 ketik formula =c5&c6
      kopi formulanya ke kanan sampai DL4. Baris ini digunakan untuk
membuat judul semua kolom berbeda.
-> pada sheet Rekap cell C4 masukkan formula:
=IFERROR(INDEX(Detail!$C$8:$DL$36,MATCH($A4,Detail!$A$8:$A$36,0),MATCH(C$2&C$3,Detail!$C$4:$DL$4,0)),"")

2. Cara kedua menggunakan sintak yang kedua.
->  sintak secara lengkap adalah:
=Index((ref1,ref2,ref3,ref4,...dst...),nomor baris, nomor kolom, nomor
referensi)
-> contoh untuk kasus anda formula untuk nomor 201 sampai 203:
=IFERROR(INDEX((Detail!$C$8:$J$36,Detail!$K$8:$R$36,Detail!$S$8:$Z$36),MATCH($A4,Detail!$A$8:$A$36,0),MATCH(C$3,Detail!$C$6:$DL$6,0),MATCH(C$2,{*201,202,203*},0)),"")
->  ingat formula tersebut hanya untuk nomor 201, 202 dan 203. referensi
201 berwarna merah, referensi no 202 berwarna hijau dan referensi 203
berwarna biru.
-> agar formula tersebut berfungsi sampai nomor 216 berarti referensinya
perlu ditambah sampai 216 dan nomor referensinya (pada formula saya buat
Bold) perlu ditambah semuanya sampai 216.

Pilih yang mana? kalau saya pilih no 1 karena pekerjaannya lebih ringan.
silahkan mencoba.

Regard
Agus

On 9/14/2019 14:14, Kamirin Faqoth kamirin_2@yahoo.co.id [belajar-excel]
wrote:
> Dear Member Be-Excel,
>
> Mohon solusinya, saya sedang mencari suatu nilai dengan 3 kriteria dan
> memakai fungsi Index-Match, tapi kenapa ya, pada sheet rekap, ketika
> sy menggunakan salah satu kriteria dengan angka 201, hasilnya berjalan
> sesuai harapan, tapi ketika angkanya diganti dengan 202, 203 dst koq
> hasilnya blank yaa.
>
>
> Terima kasih sebelumnya atas support para suhu & member B-Excel.
>
>
> Salam,
> kamirin
>

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

2a

Lookup2

Sat Sep 14, 2019 11:06 pm (PDT) . Posted by:

"HAIRUL ALAM"

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam

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

2b

Re: Lookup2

Sun Sep 15, 2019 12:17 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba cari fungsi Small If (array formula) mbak Siti di database milis.
Salam,HK

Sent from Yahoo Mail on Android

On Sun, Sep 15, 2019 at 13:07, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam #yiv4261607264 #yiv4261607264 -- #yiv4261607264ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4261607264 #yiv4261607264ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4261607264 #yiv4261607264ygrp-mkp #yiv4261607264hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4261607264 #yiv4261607264ygrp-mkp #yiv4261607264ads {margin-bottom:10px;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad {padding:0 0;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad p {margin:0;}#yiv4261607264 #yiv4261607264ygrp-mkp .yiv4261607264ad a {color:#0000ff;text-decoration:none;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc {font-family:Arial;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc #yiv4261607264hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ygrp-lc .yiv4261607264ad {margin-bottom:10px;padding:0 0;}#yiv4261607264 #yiv4261607264actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4261607264 #yiv4261607264activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4261607264 #yiv4261607264activity span {font-weight:700;}#yiv4261607264 #yiv4261607264activity span:first-child {text-transform:uppercase;}#yiv4261607264 #yiv4261607264activity span a {color:#5085b6;text-decoration:none;}#yiv4261607264 #yiv4261607264activity span span {color:#ff7900;}#yiv4261607264 #yiv4261607264activity span ..yiv4261607264underline {text-decoration:underline;}#yiv4261607264 .yiv4261607264attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4261607264 .yiv4261607264attach div a {text-decoration:none;}#yiv4261607264 .yiv4261607264attach img {border:none;padding-right:5px;}#yiv4261607264 .yiv4261607264attach label {display:block;margin-bottom:5px;}#yiv4261607264 .yiv4261607264attach label a {text-decoration:none;}#yiv4261607264 blockquote {margin:0 0 0 4px;}#yiv4261607264 .yiv4261607264bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4261607264 .yiv4261607264bold a {text-decoration:none;}#yiv4261607264 dd.yiv4261607264last p a {font-family:Verdana;font-weight:700;}#yiv4261607264 dd.yiv4261607264last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4261607264 dd.yiv4261607264last p span.yiv4261607264yshortcuts {margin-right:0;}#yiv4261607264 div.yiv4261607264attach-table div div a {text-decoration:none;}#yiv4261607264 div.yiv4261607264attach-table {width:400px;}#yiv4261607264 div.yiv4261607264file-title a, #yiv4261607264 div.yiv4261607264file-title a:active, #yiv4261607264 div.yiv4261607264file-title a:hover, #yiv4261607264 div.yiv4261607264file-title a:visited {text-decoration:none;}#yiv4261607264 div.yiv4261607264photo-title a, #yiv4261607264 div.yiv4261607264photo-title a:active, #yiv4261607264 div.yiv4261607264photo-title a:hover, #yiv4261607264 div.yiv4261607264photo-title a:visited {text-decoration:none;}#yiv4261607264 div#yiv4261607264ygrp-mlmsg #yiv4261607264ygrp-msg p a span.yiv4261607264yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4261607264 .yiv4261607264green {color:#628c2a;}#yiv4261607264 .yiv4261607264MsoNormal {margin:0 0 0 0;}#yiv4261607264 o {font-size:0;}#yiv4261607264 #yiv4261607264photos div {float:left;width:72px;}#yiv4261607264 #yiv4261607264photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4261607264 #yiv4261607264photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4261607264 #yiv4261607264reco-category {font-size:77%;}#yiv4261607264 #yiv4261607264reco-desc {font-size:77%;}#yiv4261607264 .yiv4261607264replbq {margin:4px;}#yiv4261607264 #yiv4261607264ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4261607264 #yiv4261607264ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4261607264 #yiv4261607264ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4261607264 #yiv4261607264ygrp-mlmsg select, #yiv4261607264 input, #yiv4261607264 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4261607264 #yiv4261607264ygrp-mlmsg pre, #yiv4261607264 code {font:115% monospace;}#yiv4261607264 #yiv4261607264ygrp-mlmsg * {line-height:1.22em;}#yiv4261607264 #yiv4261607264ygrp-mlmsg #yiv4261607264logo {padding-bottom:10px;}#yiv4261607264 #yiv4261607264ygrp-msg p a {font-family:Verdana;}#yiv4261607264 #yiv4261607264ygrp-msg p#yiv4261607264attach-count span {color:#1E66AE;font-weight:700;}#yiv4261607264 #yiv4261607264ygrp-reco #yiv4261607264reco-head {color:#ff7900;font-weight:700;}#yiv4261607264 #yiv4261607264ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov li a {font-size:130%;text-decoration:none;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4261607264 #yiv4261607264ygrp-sponsor #yiv4261607264ov ul {margin:0;padding:0 0 0 8px;}#yiv4261607264 #yiv4261607264ygrp-text {font-family:Georgia;}#yiv4261607264 #yiv4261607264ygrp-text p {margin:0 0 1em 0;}#yiv4261607264 #yiv4261607264ygrp-text tt {font-size:120%;}#yiv4261607264 #yiv4261607264ygrp-vital ul li:last-child {border-right:none !important;}#yiv4261607264

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

2c

Re: Lookup2

Sun Sep 15, 2019 2:22 am (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

salah satu solusi yang bisa dicoba
formula array (CSE)  di C2
=IFERROR(INDIRECT("M"&SMALL(IF($L$2:$L$14=B$2,ROW($M$2:$M$14)),ROW(1:1))),"")

copy ke bawah 
wassalam
Ghozi Alkatiri

Pada Minggu, 15 September 2019 13.07.32 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam #yiv0609693258 #yiv0609693258 -- #yiv0609693258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0609693258 #yiv0609693258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0609693258 #yiv0609693258ygrp-mkp #yiv0609693258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0609693258 #yiv0609693258ygrp-mkp #yiv0609693258ads {margin-bottom:10px;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad {padding:0 0;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad p {margin:0;}#yiv0609693258 #yiv0609693258ygrp-mkp .yiv0609693258ad a {color:#0000ff;text-decoration:none;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc {font-family:Arial;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc #yiv0609693258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ygrp-lc .yiv0609693258ad {margin-bottom:10px;padding:0 0;}#yiv0609693258 #yiv0609693258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0609693258 #yiv0609693258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0609693258 #yiv0609693258activity span {font-weight:700;}#yiv0609693258 #yiv0609693258activity span:first-child {text-transform:uppercase;}#yiv0609693258 #yiv0609693258activity span a {color:#5085b6;text-decoration:none;}#yiv0609693258 #yiv0609693258activity span span {color:#ff7900;}#yiv0609693258 #yiv0609693258activity span ..yiv0609693258underline {text-decoration:underline;}#yiv0609693258 .yiv0609693258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0609693258 .yiv0609693258attach div a {text-decoration:none;}#yiv0609693258 .yiv0609693258attach img {border:none;padding-right:5px;}#yiv0609693258 .yiv0609693258attach label {display:block;margin-bottom:5px;}#yiv0609693258 .yiv0609693258attach label a {text-decoration:none;}#yiv0609693258 blockquote {margin:0 0 0 4px;}#yiv0609693258 .yiv0609693258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0609693258 .yiv0609693258bold a {text-decoration:none;}#yiv0609693258 dd.yiv0609693258last p a {font-family:Verdana;font-weight:700;}#yiv0609693258 dd.yiv0609693258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0609693258 dd.yiv0609693258last p span.yiv0609693258yshortcuts {margin-right:0;}#yiv0609693258 div.yiv0609693258attach-table div div a {text-decoration:none;}#yiv0609693258 div.yiv0609693258attach-table {width:400px;}#yiv0609693258 div.yiv0609693258file-title a, #yiv0609693258 div.yiv0609693258file-title a:active, #yiv0609693258 div.yiv0609693258file-title a:hover, #yiv0609693258 div.yiv0609693258file-title a:visited {text-decoration:none;}#yiv0609693258 div.yiv0609693258photo-title a, #yiv0609693258 div.yiv0609693258photo-title a:active, #yiv0609693258 div.yiv0609693258photo-title a:hover, #yiv0609693258 div.yiv0609693258photo-title a:visited {text-decoration:none;}#yiv0609693258 div#yiv0609693258ygrp-mlmsg #yiv0609693258ygrp-msg p a span.yiv0609693258yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0609693258 .yiv0609693258green {color:#628c2a;}#yiv0609693258 .yiv0609693258MsoNormal {margin:0 0 0 0;}#yiv0609693258 o {font-size:0;}#yiv0609693258 #yiv0609693258photos div {float:left;width:72px;}#yiv0609693258 #yiv0609693258photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0609693258 #yiv0609693258photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0609693258 #yiv0609693258reco-category {font-size:77%;}#yiv0609693258 #yiv0609693258reco-desc {font-size:77%;}#yiv0609693258 .yiv0609693258replbq {margin:4px;}#yiv0609693258 #yiv0609693258ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0609693258 #yiv0609693258ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0609693258 #yiv0609693258ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0609693258 #yiv0609693258ygrp-mlmsg select, #yiv0609693258 input, #yiv0609693258 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0609693258 #yiv0609693258ygrp-mlmsg pre, #yiv0609693258 code {font:115% monospace;}#yiv0609693258 #yiv0609693258ygrp-mlmsg * {line-height:1.22em;}#yiv0609693258 #yiv0609693258ygrp-mlmsg #yiv0609693258logo {padding-bottom:10px;}#yiv0609693258 #yiv0609693258ygrp-msg p a {font-family:Verdana;}#yiv0609693258 #yiv0609693258ygrp-msg p#yiv0609693258attach-count span {color:#1E66AE;font-weight:700;}#yiv0609693258 #yiv0609693258ygrp-reco #yiv0609693258reco-head {color:#ff7900;font-weight:700;}#yiv0609693258 #yiv0609693258ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov li a {font-size:130%;text-decoration:none;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0609693258 #yiv0609693258ygrp-sponsor #yiv0609693258ov ul {margin:0;padding:0 0 0 8px;}#yiv0609693258 #yiv0609693258ygrp-text {font-family:Georgia;}#yiv0609693258 #yiv0609693258ygrp-text p {margin:0 0 1em 0;}#yiv0609693258 #yiv0609693258ygrp-text tt {font-size:120%;}#yiv0609693258 #yiv0609693258ygrp-vital ul li:last-child {border-right:none !important;}#yiv0609693258

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

2d

Re: Lookup2 [1 Attachment]

Sun Sep 15, 2019 6:41 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasi Mas Ghozi
AssalamualaikumHairul Alam
Pada Minggu, 15 September 2019 16.22.50 GMT+7, ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

salah satu solusi yang bisa dicoba
formula array (CSE)  di C2
=IFERROR(INDIRECT("M"&SMALL(IF($L$2:$L$14=B$2,ROW($M$2:$M$14)),ROW(1:1))),"")

copy ke bawah 
wassalam
Ghozi Alkatiri

Pada Minggu, 15 September 2019 13.07..32 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam #yiv3626058003 #yiv3626058003 -- #yiv3626058003ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3626058003 #yiv3626058003ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3626058003 #yiv3626058003ygrp-mkp #yiv3626058003hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3626058003 #yiv3626058003ygrp-mkp #yiv3626058003ads {margin-bottom:10px;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad {padding:0 0;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad p {margin:0;}#yiv3626058003 #yiv3626058003ygrp-mkp .yiv3626058003ad a {color:#0000ff;text-decoration:none;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc {font-family:Arial;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc #yiv3626058003hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ygrp-lc .yiv3626058003ad {margin-bottom:10px;padding:0 0;}#yiv3626058003 #yiv3626058003actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3626058003 #yiv3626058003activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3626058003 #yiv3626058003activity span {font-weight:700;}#yiv3626058003 #yiv3626058003activity span:first-child {text-transform:uppercase;}#yiv3626058003 #yiv3626058003activity span a {color:#5085b6;text-decoration:none;}#yiv3626058003 #yiv3626058003activity span span {color:#ff7900;}#yiv3626058003 #yiv3626058003activity span .yiv3626058003underline {text-decoration:underline;}#yiv3626058003 .yiv3626058003attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3626058003 .yiv3626058003attach div a {text-decoration:none;}#yiv3626058003 .yiv3626058003attach img {border:none;padding-right:5px;}#yiv3626058003 .yiv3626058003attach label {display:block;margin-bottom:5px;}#yiv3626058003 .yiv3626058003attach label a {text-decoration:none;}#yiv3626058003 blockquote {margin:0 0 0 4px;}#yiv3626058003 .yiv3626058003bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3626058003 .yiv3626058003bold a {text-decoration:none;}#yiv3626058003 dd.yiv3626058003last p a {font-family:Verdana;font-weight:700;}#yiv3626058003 dd.yiv3626058003last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3626058003 dd.yiv3626058003last p span.yiv3626058003yshortcuts {margin-right:0;}#yiv3626058003 div.yiv3626058003attach-table div div a {text-decoration:none;}#yiv3626058003 div.yiv3626058003attach-table {width:400px;}#yiv3626058003 div.yiv3626058003file-title a, #yiv3626058003 div.yiv3626058003file-title a:active, #yiv3626058003 div.yiv3626058003file-title a:hover, #yiv3626058003 div.yiv3626058003file-title a:visited {text-decoration:none;}#yiv3626058003 div.yiv3626058003photo-title a, #yiv3626058003 div.yiv3626058003photo-title a:active, #yiv3626058003 div.yiv3626058003photo-title a:hover, #yiv3626058003 div.yiv3626058003photo-title a:visited {text-decoration:none;}#yiv3626058003 div#yiv3626058003ygrp-mlmsg #yiv3626058003ygrp-msg p a span.yiv3626058003yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3626058003 .yiv3626058003green {color:#628c2a;}#yiv3626058003 .yiv3626058003MsoNormal {margin:0 0 0 0;}#yiv3626058003 o {font-size:0;}#yiv3626058003 #yiv3626058003photos div {float:left;width:72px;}#yiv3626058003 #yiv3626058003photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3626058003 #yiv3626058003photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3626058003 #yiv3626058003reco-category {font-size:77%;}#yiv3626058003 #yiv3626058003reco-desc {font-size:77%;}#yiv3626058003 .yiv3626058003replbq {margin:4px;}#yiv3626058003 #yiv3626058003ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3626058003 #yiv3626058003ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3626058003 #yiv3626058003ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3626058003 #yiv3626058003ygrp-mlmsg select, #yiv3626058003 input, #yiv3626058003 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3626058003 #yiv3626058003ygrp-mlmsg pre, #yiv3626058003 code {font:115% monospace;}#yiv3626058003 #yiv3626058003ygrp-mlmsg * {line-height:1.22em;}#yiv3626058003 #yiv3626058003ygrp-mlmsg #yiv3626058003logo {padding-bottom:10px;}#yiv3626058003 #yiv3626058003ygrp-msg p a {font-family:Verdana;}#yiv3626058003 #yiv3626058003ygrp-msg p#yiv3626058003attach-count span {color:#1E66AE;font-weight:700;}#yiv3626058003 #yiv3626058003ygrp-reco #yiv3626058003reco-head {color:#ff7900;font-weight:700;}#yiv3626058003 #yiv3626058003ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov li a {font-size:130%;text-decoration:none;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3626058003 #yiv3626058003ygrp-sponsor #yiv3626058003ov ul {margin:0;padding:0 0 0 8px;}#yiv3626058003 #yiv3626058003ygrp-text {font-family:Georgia;}#yiv3626058003 #yiv3626058003ygrp-text p {margin:0 0 1em 0;}#yiv3626058003 #yiv3626058003ygrp-text tt {font-size:120%;}#yiv3626058003 #yiv3626058003ygrp-vital ul li:last-child {border-right:none !important;}#yiv3626058003

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

2e

Re: Lookup2

Sun Sep 15, 2019 6:41 am (PDT) . Posted by:

"HAIRUL ALAM"

Terimakasih Pak Hendrik
SalamHairul Alam
Pada Minggu, 15 September 2019 14.18.25 GMT+7, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Coba cari fungsi Small If (array formula) mbak Siti di database milis.

Salam,HK

Sent from Yahoo Mail on Android

On Sun, Sep 15, 2019 at 13:07, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Salam Para Master yang baik
Selamat siang semoga di siang ini selalu dalam keadaan baik dan sehat lahir bathin
Sedikit mengenai lookup sederhana yang terus terang saya bingung.
Bagaimana Rumusnya agar hasil lookup di kolom C sesuai data lookup dari kolom L sd M dengan criteria cell B2, seperti contoh data terlampir

Terimakasih Banyak Pencerahannya
AssalamualaikumHairul Alam
#yiv6313499790 #yiv6313499790 -- #yiv6313499790ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6313499790 #yiv6313499790ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6313499790 #yiv6313499790ygrp-mkp #yiv6313499790hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6313499790 #yiv6313499790ygrp-mkp #yiv6313499790ads {margin-bottom:10px;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad {padding:0 0;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad p {margin:0;}#yiv6313499790 #yiv6313499790ygrp-mkp .yiv6313499790ad a {color:#0000ff;text-decoration:none;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc {font-family:Arial;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc #yiv6313499790hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ygrp-lc .yiv6313499790ad {margin-bottom:10px;padding:0 0;}#yiv6313499790 #yiv6313499790actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6313499790 #yiv6313499790activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6313499790 #yiv6313499790activity span {font-weight:700;}#yiv6313499790 #yiv6313499790activity span:first-child {text-transform:uppercase;}#yiv6313499790 #yiv6313499790activity span a {color:#5085b6;text-decoration:none;}#yiv6313499790 #yiv6313499790activity span span {color:#ff7900;}#yiv6313499790 #yiv6313499790activity span .yiv6313499790underline {text-decoration:underline;}#yiv6313499790 .yiv6313499790attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6313499790 .yiv6313499790attach div a {text-decoration:none;}#yiv6313499790 .yiv6313499790attach img {border:none;padding-right:5px;}#yiv6313499790 .yiv6313499790attach label {display:block;margin-bottom:5px;}#yiv6313499790 .yiv6313499790attach label a {text-decoration:none;}#yiv6313499790 blockquote {margin:0 0 0 4px;}#yiv6313499790 .yiv6313499790bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6313499790 .yiv6313499790bold a {text-decoration:none;}#yiv6313499790 dd.yiv6313499790last p a {font-family:Verdana;font-weight:700;}#yiv6313499790 dd.yiv6313499790last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6313499790 dd.yiv6313499790last p span.yiv6313499790yshortcuts {margin-right:0;}#yiv6313499790 div.yiv6313499790attach-table div div a {text-decoration:none;}#yiv6313499790 div.yiv6313499790attach-table {width:400px;}#yiv6313499790 div.yiv6313499790file-title a, #yiv6313499790 div.yiv6313499790file-title a:active, #yiv6313499790 div..yiv6313499790file-title a:hover, #yiv6313499790 div.yiv6313499790file-title a:visited {text-decoration:none;}#yiv6313499790 div.yiv6313499790photo-title a, #yiv6313499790 div.yiv6313499790photo-title a:active, #yiv6313499790 div.yiv6313499790photo-title a:hover, #yiv6313499790 div.yiv6313499790photo-title a:visited {text-decoration:none;}#yiv6313499790 div#yiv6313499790ygrp-mlmsg #yiv6313499790ygrp-msg p a span.yiv6313499790yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6313499790 .yiv6313499790green {color:#628c2a;}#yiv6313499790 .yiv6313499790MsoNormal {margin:0 0 0 0;}#yiv6313499790 o {font-size:0;}#yiv6313499790 #yiv6313499790photos div {float:left;width:72px;}#yiv6313499790 #yiv6313499790photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6313499790 #yiv6313499790photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6313499790 #yiv6313499790reco-category {font-size:77%;}#yiv6313499790 #yiv6313499790reco-desc {font-size:77%;}#yiv6313499790 .yiv6313499790replbq {margin:4px;}#yiv6313499790 #yiv6313499790ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6313499790 #yiv6313499790ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6313499790 #yiv6313499790ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6313499790 #yiv6313499790ygrp-mlmsg select, #yiv6313499790 input, #yiv6313499790 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6313499790 #yiv6313499790ygrp-mlmsg pre, #yiv6313499790 code {font:115% monospace;}#yiv6313499790 #yiv6313499790ygrp-mlmsg * {line-height:1.22em;}#yiv6313499790 #yiv6313499790ygrp-mlmsg #yiv6313499790logo {padding-bottom:10px;}#yiv6313499790 #yiv6313499790ygrp-msg p a {font-family:Verdana;}#yiv6313499790 #yiv6313499790ygrp-msg p#yiv6313499790attach-count span {color:#1E66AE;font-weight:700;}#yiv6313499790 #yiv6313499790ygrp-reco #yiv6313499790reco-head {color:#ff7900;font-weight:700;}#yiv6313499790 #yiv6313499790ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov li a {font-size:130%;text-decoration:none;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6313499790 #yiv6313499790ygrp-sponsor #yiv6313499790ov ul {margin:0;padding:0 0 0 8px;}#yiv6313499790 #yiv6313499790ygrp-text {font-family:Georgia;}#yiv6313499790 #yiv6313499790ygrp-text p {margin:0 0 1em 0;}#yiv6313499790 #yiv6313499790ygrp-text tt {font-size:120%;}#yiv6313499790 #yiv6313499790ygrp-vital ul li:last-child {border-right:none !important;}#yiv6313499790

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

3a

data tampil pada list box

Sun Sep 15, 2019 6:42 am (PDT) . Posted by:

"HAIRUL ALAM"

Salam Para Master yang Baik
Terlampir data yang saya mau tampilkan ke listbox, bagaimana code macronya karena dengan menggunakan code macro ;
Sub Listbox()    Data = "C2:C20"  ListBox1.ColumnCount = 1  ListBox1.RowSource = Data
End Sub
tidak berfungsi, mohon Pencerahannya
Terimakasih Banyak
AssalamualaikumHairul Alam

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

3b

Re: data tampil pada list box [1 Attachment]

Sun Sep 15, 2019 7:48 am (PDT) . Posted by:

"Agus"

Dear Hairul,

Kenapa harus pakai macro?
Bukankah lebih mudah dengan Format Control?
(Klik kanan di list box, pilih format control, KLik tab Control, isi
Input range dengan C2:C5)

Jika memaksa menggunakan vba berarti cekripnya harusnya sama dengan cara
di atas, yaitu:

Worksheets("data").Shapes("List Box 1").ControlFormat.ListFillRange =
"C2:C5"

Perlu dibedakan antara List Box format control dan ListBox ActiveX Control.

Regard
NangAgus

On 9/15/2019 17:01, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] wrote:
> Salam Para Master yang Baik
>
> Terlampir data yang saya mau tampilkan ke listbox, bagaimana code
> macronya karena dengan menggunakan code macro ;
>
> Sub Listbox()
>   Data = "C2:C20"
>   ListBox1.ColumnCount = 1
>   ListBox1.RowSource = Data
>
> End Sub
>
> tidak berfungsi, mohon Pencerahannya
>
> Terimakasih Banyak
>
> Assalamualaikum
> Hairul Alam
>
>

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

3c

Re: data tampil pada list box

Sun Sep 15, 2019 8:44 am (PDT) . Posted by:

"HAIRUL ALAM"

Salam Mas Agus
Terimakasih banyak pencerahannya
AssalamualaikumHairul Alam
Pada Minggu, 15 September 2019 21.48.59 GMT+7, Agus nangagus@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Dear Hairul,
Kenapa harus pakai macro? Bukankah lebih mudah dengan Format Control? (Klik kanan di list box, pilih format control, KLik tab Control, isi Input range dengan C2:C5)
Jika memaksa menggunakan vba berarti cekripnya harusnya sama dengan cara di atas, yaitu:

Worksheets("data").Shapes("List Box 1").ControlFormat..ListFillRange = "C2:C5"

Perlu dibedakan antara List Box format control dan ListBox ActiveX Control.
Regard NangAgus

On 9/15/2019 17:01, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] wrote:

  Salam Para Master yang Baik
Terlampir data yang saya mau tampilkan ke listbox, bagaimana code macronya karena dengan menggunakan code macro ;
Sub Listbox()      Data = "C2:C20"   ListBox1.ColumnCount = 1   ListBox1.RowSource = Data
End Sub
tidak berfungsi, mohon Pencerahannya
Terimakasih Banyak
Assalamualaikum Hairul Alam



#yiv8468672139 #yiv8468672139 -- #yiv8468672139ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8468672139 #yiv8468672139ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8468672139 #yiv8468672139ygrp-mkp #yiv8468672139hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8468672139 #yiv8468672139ygrp-mkp #yiv8468672139ads {margin-bottom:10px;}#yiv8468672139 #yiv8468672139ygrp-mkp .yiv8468672139ad {padding:0 0;}#yiv8468672139 #yiv8468672139ygrp-mkp .yiv8468672139ad p {margin:0;}#yiv8468672139 #yiv8468672139ygrp-mkp .yiv8468672139ad a {color:#0000ff;text-decoration:none;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ygrp-lc {font-family:Arial;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ygrp-lc #yiv8468672139hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ygrp-lc .yiv8468672139ad {margin-bottom:10px;padding:0 0;}#yiv8468672139 #yiv8468672139actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8468672139 #yiv8468672139activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8468672139 #yiv8468672139activity span {font-weight:700;}#yiv8468672139 #yiv8468672139activity span:first-child {text-transform:uppercase;}#yiv8468672139 #yiv8468672139activity span a {color:#5085b6;text-decoration:none;}#yiv8468672139 #yiv8468672139activity span span {color:#ff7900;}#yiv8468672139 #yiv8468672139activity span .yiv8468672139underline {text-decoration:underline;}#yiv8468672139 .yiv8468672139attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8468672139 .yiv8468672139attach div a {text-decoration:none;}#yiv8468672139 .yiv8468672139attach img {border:none;padding-right:5px;}#yiv8468672139 .yiv8468672139attach label {display:block;margin-bottom:5px;}#yiv8468672139 .yiv8468672139attach label a {text-decoration:none;}#yiv8468672139 blockquote {margin:0 0 0 4px;}#yiv8468672139 .yiv8468672139bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8468672139 .yiv8468672139bold a {text-decoration:none;}#yiv8468672139 dd.yiv8468672139last p a {font-family:Verdana;font-weight:700;}#yiv8468672139 dd.yiv8468672139last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8468672139 dd.yiv8468672139last p span.yiv8468672139yshortcuts {margin-right:0;}#yiv8468672139 div.yiv8468672139attach-table div div a {text-decoration:none;}#yiv8468672139 div.yiv8468672139attach-table {width:400px;}#yiv8468672139 div.yiv8468672139file-title a, #yiv8468672139 div.yiv8468672139file-title a:active, #yiv8468672139 div.yiv8468672139file-title a:hover, #yiv8468672139 div.yiv8468672139file-title a:visited {text-decoration:none;}#yiv8468672139 div.yiv8468672139photo-title a, #yiv8468672139 div.yiv8468672139photo-title a:active, #yiv8468672139 div.yiv8468672139photo-title a:hover, #yiv8468672139 div.yiv8468672139photo-title a:visited {text-decoration:none;}#yiv8468672139 div#yiv8468672139ygrp-mlmsg #yiv8468672139ygrp-msg p a span.yiv8468672139yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8468672139 .yiv8468672139green {color:#628c2a;}#yiv8468672139 .yiv8468672139MsoNormal {margin:0 0 0 0;}#yiv8468672139 o {font-size:0;}#yiv8468672139 #yiv8468672139photos div {float:left;width:72px;}#yiv8468672139 #yiv8468672139photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8468672139 #yiv8468672139photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8468672139 #yiv8468672139reco-category {font-size:77%;}#yiv8468672139 #yiv8468672139reco-desc {font-size:77%;}#yiv8468672139 .yiv8468672139replbq {margin:4px;}#yiv8468672139 #yiv8468672139ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8468672139 #yiv8468672139ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8468672139 #yiv8468672139ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8468672139 #yiv8468672139ygrp-mlmsg select, #yiv8468672139 input, #yiv8468672139 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8468672139 #yiv8468672139ygrp-mlmsg pre, #yiv8468672139 code {font:115% monospace;}#yiv8468672139 #yiv8468672139ygrp-mlmsg * {line-height:1.22em;}#yiv8468672139 #yiv8468672139ygrp-mlmsg #yiv8468672139logo {padding-bottom:10px;}#yiv8468672139 #yiv8468672139ygrp-msg p a {font-family:Verdana;}#yiv8468672139 #yiv8468672139ygrp-msg p#yiv8468672139attach-count span {color:#1E66AE;font-weight:700;}#yiv8468672139 #yiv8468672139ygrp-reco #yiv8468672139reco-head {color:#ff7900;font-weight:700;}#yiv8468672139 #yiv8468672139ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ov li a {font-size:130%;text-decoration:none;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8468672139 #yiv8468672139ygrp-sponsor #yiv8468672139ov ul {margin:0;padding:0 0 0 8px;}#yiv8468672139 #yiv8468672139ygrp-text {font-family:Georgia;}#yiv8468672139 #yiv8468672139ygrp-text p {margin:0 0 1em 0;}#yiv8468672139 #yiv8468672139ygrp-text tt {font-size:120%;}#yiv8468672139 #yiv8468672139ygrp-vital ul li:last-child {border-right:none !important;}#yiv8468672139

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

4a

Re: Rencana kopdar

Sun Sep 15, 2019 8:43 pm (PDT) . Posted by:

iq_bal76id

Update kopdar :

No

Nama

No Telp

1

Hairul Alam

2

Muhammad Iqbal

Done

3

Hendrik Karnadi

Done

4

Netty Wuryanti

Done

5

Eira I Arie

Cancel

6

Adi irawan

7

Afdhol Marthoni

8

Kiki Tanjung

Done

9

Pamor Ron Nessen

Done

10

Halkit S

Done

11

NangAgus

12

M. Fahmi

Done

13



14

15

16

17

18

19

Monggo yang belum share no telp bisa di share :

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
Sent: Tuesday, September 10, 2019 2:49 PM
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Rencana kopdar

Dear Mas Hendrik,

Oh iya betul mas, ndak teliti saya. Thanks info nya mas.

No

Nama

No Telp

1

Hairul Alam

2

Muhammad Iqbal

Done

3

Hendrik Karnadi

Done

4

Netty Wuryanti

Done

5

Eira I Arie

6

Adi irawan

7

Afdhol Marthoni

8

Kiki Tanjung

Done

9

Pamor Ron Nessen

Done

10

Halkit S

Done

11

NangAgus

12

M. Fahmi

Done

13



14

15

16

17

18

19

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Monday, September 9, 2019 7:31 PM
To: BeExcel <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Subject: Fw: [belajar-excel] Rencana kopdar

Dear mas Iqbal,

Mas Pamor No 13 apakah sama dengan No. 9 ?

Terima kasih.

Salam,

HK

Sent from Yahoo Mail on Android <https://overview.mail.yahoo.com/mobile/?.src=Android>

On Mon, Sep 9, 2019 at 17:22, iq_bal76id@yahoo.com <mailto:iq_bal76id@yahoo.com> [belajar-excel]

<belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

New Update 09 septemebr 2019 17:00

No

Nama

No Telp

1

Hairul Alam

2

Muhammad Iqbal

Done

3

Hendrik Karnadi

Done

4

Netty Wuryanti

Done

5

Eira I Arie

6

Adi irawan

7

Afdhol Marthoni

8

Kiki Tanjung

Done

9

Pamor Ron Nessen

10

Halkit S

11

NangAgus

12

M. Fahmi

Done

13

Pamor Ron Nessen

Done

14

15

16

17

18

19

Ada yg bisa bantu untuk no lain, mungkin ada yang memiliki monggo di share

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Monday, September 9, 2019 10:52 AM
To: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com>
Subject: RE: [belajar-excel] Rencana kopdar

Update untuk Kopdar :

Yang sudah masuk no telp di saya 4 orang :

No

Nama

No Telp

1

Hairul Alam

2

Muhammad Iqbal

Done

3

Hendrik Karnadi

Done

4

Netty Wuryanti

Done

5

Eira I Arie

6

Adi irawan

7

Afdhol Marthoni

8

Kiki Tanjung

Done

9

Pamor Ron Nessen

10

Halkit S

11

NangAgus

12

M. Fahmi

Done

13

14

15

16

17

18

19

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Friday, September 6, 2019 3:31 PM
To: iq_bal76id@yahoo.com <mailto:iq_bal76id@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Subject: Re: [belajar-excel] Rencana kopdar [2 Attachments]

Sudah mas Iqbal.

Terima kasih.

Salam,

HK

Pada Jumat, 6 September 2019 00.34.58 GMT+7, iq_bal76id@yahoo.com <mailto:iq_bal76id@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > menulis:

Lanjut preparationnya neh,

Boleh share no Hp masing2 biar easy koordinasi nya, mungkin klo di email ndak semua tiap hari buka email.

Boleh japri wa ke saya no telp masing2 ke no saya yang 08990909010.

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Tuesday, September 3, 2019 5:11 PM
To: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com>
Subject: RE: [belajar-excel] Rencana kopdar

Dari data berikut,

No

Nama

Topik

Waktu

1

Hairul Alam

databse excel, Macro, Power query&pivot, lock excel

Sabtu

2

Muhammad Iqbal

Sabtu

3

Hendrik Karnadi

Sabtu

4

Netty Wuryanti

Sabtu

5

Eira I Arie

Sabtu

6

Adi irawan

Minggu

7

Afdhol Marthoni

Sabtu

8

Kiki Tanjung

Sabtu

9

Pamor Ron Nessen

Sabtu

10

Halkit S

Sabtu

11

NangAgus

Sabtu

12

13

14

15

16

17

18

19

Karena banyak yang hari sabtu available, maka dibuat saja hari sabtu,

Untuk tanggal monggo di set 21 atau 28, klo saya lebih proper tgl 28.

Untuk gambaran gubug nya aku lampirkan

Dan untuk makan bisa makan di sebelah kantor atau nanti dikirim dalam kantor

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Tuesday, September 3, 2019 1:21 PM
To: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com>
Subject: Re: [belajar-excel] Rencana kopdar

Boleh

Sent from my smart enough phone

On Sep 3, 2019, at 11:10, iq_bal76id@yahoo.com <mailto:iq_bal76id@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups..com <mailto:belajar-excel@yahoogroups...com> > wrote:

Melanjutkan,

Untuk waktu dan tempat adakah usulan?

28 / 29 September 2019

4 / 5 Oktober 2019.

Tempat : Kalibata utara II no 22 Jaksel.

Mr Kid,

Sebagai owner sekaligus guidance sharing session nya, available time mr Kid adakah di tanggal diatas?

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

From: belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >
Sent: Tuesday, September 3, 2019 9:08 AM
To: BeExcel <belajar-excel@yahoogroups..com <mailto:belajar-excel@yahoogroups.com> >
Subject: Fw: [belajar-excel] Rencana kopdar

Siapa menyusul ?

Quota tinggal 50%....

Salam,

HK

Sent from Yahoo Mail on Android <https://overview.mail.yahoo.com/mobile/?.src=Android>

On Fri, Aug 30, 2019 at 9:40, hendrik karnadi hendrikkarnadi@yahoo..com <mailto:hendrikkarnadi@yahoo.com> [belajar-excel]

<belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

No. Nama Pilihan Topik Hari (Sabtu/Minggu) Tempat

1. Hairul Alam Database Excel Sabtu Kalibata Utara II No22

2. Muhammad Iqbal Macro, Power Query Sabtu Dekat Superindo..Mampang

3. Hendrik Karnadi Power Query, Power Pivot Sabtu (Kapasitas +- 20 orang)

4. Netty Wuryanti Power Query, Power Pivot ................

5. Eira I Arie Review Basic Excel + sda Sabtu

6. Adi irawan Power Query, Power Pivot Minggu

7. Afdhol Marthoni Power Query, Power Pivot ...................

8. Kiki Tanjung Power Query, Power Pivot .................

9. Pamor Ron Nessen Power Query, Power Pivot ................

10. Halkit S Power Query, Power Pivot Sabtu

11. NangAgus LockExcel Pivot Libur Panjang

12.

13.

14.

15..

dst,nya

----- Pesan yang Diteruskan -----

Dari: Eira I Arie cheivory_bridge@yahoo.com <mailto:cheivory_bridge@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >

Kepada: "belajar-excel@yahoogroups..com <mailto:belajar-excel@yahoogroups.com> " <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> >

Terkirim: Jumat, 30 Agustus 2019 08.03.20 WIB

Judul: Re: [belajar-excel] Rencana kopdar

No. Nama Pilihan Topik Hari (Sabtu/Minggu) Tempat

1. Hairul Alam Database Excel ............... Kalibata Utara II No22

2... Muhammad Iqbal Macro, Power Query Sabtu Dekat Superindo Mampang

3. Hendrik Karnadi Power Query, Power Pivot Sabtu (Kapasitas +- 20 orang)

4. Netty Wuryanti Power Query, Power Pivot .................

5.. Eira I Arie Review Basic Excel, Power Query, Power Pivot Sabtu

6.. Adi irawan Power Query, Power Pivot Minggu

7. Afdhol Marthoni Power Query, Power Pivot ..................

8. Kiki Tanjung Power Query, Power Pivot ..................

9. Pamor Ron Nessen Power Query, Power Pivot ................

10. Halkit S Power Query, Power Pivot Sabtu

11.. NangAgus LockExcel Pivot Libur Panjang

12,

dst,nya

tks ari

On Thursday, August 29, 2019, 12:08:21 PM GMT+7, hendrik karnadi hendrikkarnadi@yahoo.com <mailto:hendrikkarnadi@yahoo.com> [belajar-excel] <belajar-excel@yahoogroups.com <mailto:belajar-excel@yahoogroups.com> > wrote:

Dear BeExcel,

Sehubungan dengan email saya yang lalu mengenai Pendalaman Power Query dan Power Pivot serta penawaran tempat dari Mas Muhammad Iqbal yang bisa digunakan untuk kopdar, saya mencoba mengupdate calon peserta Pendalaman Power Query dan Power Pivot yang sdh mengirim email kepada saya (ditambah saya sendiri).

Topiknya diganti menjadi Rencana Kopdar.

Untuk selanjutnya, calon peserta yang Namanya sdh terdaftar tinggal Copy Paste kemudian melengkapi Hari, dan yang belum terdaftar silakan Copy Paste kemudian menambahkan No., Nama, Pilihan Topik dan Hari.

No. Nama Pilihan Topik Hari (Sabtu/Minggu) Tempat

1. Hairul Alam Database Excel ............... Kalibata Utara II No22

2. Muhammad Iqbal Macro, Power Query Sabtu Dekat Superindo Mampang

3. Hendrik Karnadi Power Query, Power Pivot Sabtu (Kapasitas +- 20 orang)

4. Netty Wuryanti Power Query, Power Pivot ..............

5. Eira I Arie Power Query, Power Pivot ..............

6. Adi irawan Power Query, Power Pivot Minggu

7. Afdhol Marthoni Power Query, Power Pivot ...............

8. Kiki Tanjung Power Query, Power Pivot ..............

9.. Pamor Ron Nessen Power Query, Power Pivot ................

10.

11.

12,

dst,nya

Kita semua berharap semoga Kopdar ini benar2 dapat terlaksana, tentunya dengan bantuan Mr. Kid dan pakar lainnya.

Salam,

HK

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

5

[belajar excel] Mencari data pada table

Sun Sep 15, 2019 9:07 pm (PDT) . Posted by:

"jackie yunianto" tanfidzularus

Dear all, 
Mohon dibantu. 
Saya mempunyai table seperti berikut. 1. List nilai mahasiswa dan mata kuliah nya2. Mata Kuliah wajib
Yg ingin dicari adalah bagaimana dengan 2 table tersebut dapat di ketahui :1. Mahasiswa yang Nilai nya belum lengkap 2. Mata kuliah yg belum ada nilainya

Sent from Yahoo Mail on Android

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