Re: [belajar-excel] Lookup2
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_m...@yahoo.co.id
[belajar-excel] 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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv4261607264
#yiv4261607264photos div label
{color:#66;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 #yiv4261607264ygr
Re: [belajar-excel] Lookup2 [1 Attachment]
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_m...@yahoo.co.id [belajar-excel] 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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0609693258
#yiv0609693258photos div label
{color:#66;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
#yiv0609693258ygr
Re: [belajar-excel] Mencari Nilai dengan 3 Kriteria
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 kamiri...@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
Re: [belajar-excel] Lookup2
Terimakasih Pak Hendrik
SalamHairul Alam
Pada Minggu, 15 September 2019 14.18.25 GMT+7, hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel]
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_m...@yahoo.co.id
[belajar-excel] 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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv6313499790
#yiv6313499790photos div label
{color:#66;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
{fon
Re: [belajar-excel] Lookup2
Terimakasi Mas Ghozi
AssalamualaikumHairul Alam
Pada Minggu, 15 September 2019 16.22.50 GMT+7, ghozi alkatiri
ghozialkat...@yahoo.co.id [belajar-excel]
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_m...@yahoo.co.id [belajar-excel] 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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv3626058003
#yiv3626058003photos div label
{color:#66;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%;}#yi
[belajar-excel] data tampil pada list box [1 Attachment]
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 data tampil pada list box.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
[belajar-excel] [belajar excel] Mencari data pada table
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 Excel Tes 12092019.xlsx Description: MS-Excel 2007 spreadsheet
[belajar-excel] Mohon dibantu untuk Ketika Tombol EDIT di klik Maka sheet SLIP pada No 1 dan 15 akan teredit dan hasilnya akan muncul di Sheet DATABASE
Dear All, Mohon dibantu untuk Ketika Tombol EDIT di klik Maka sheet SLIP pada No 1 dan 15 akan teredit dan hasilnya akan muncul di Sheet DATABASE. Terimakasih Terlampir Filenya Regards, Roni Edit.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
