[belajar-excel] Digest Number 4094

Milis Belajar Microsoft Excel Group

7 Messages

Digest #4094

1a

Re: Bls: [belajar-excel] memilih nilai pada sheet tertentu by "hendrik karnadi" hendrikkarnadi

2a

Gabung textboxt / combobox by "Odhyz" odhyz83_assasaky

2b

Bls: [belajar-excel] Gabung textboxt / combobox by "Toby kenzo" tobykenzo

3a

Menentukan nilai dengan tahun berbeda by "Cety Carmelo Julita"

3b

Bls: [belajar-excel] Menentukan nilai dengan tahun berbeda [1 Attach by "Toby kenzo" tobykenzo

4a

Re: memilih nilai pada sheet tertentu by "Cety Carmelo Julita"

4b

Re: memilih nilai pada sheet tertentu by "ghozi alkatiri" ghozialkatiri

Messages

1a

Re: Bls: [belajar-excel] memilih nilai pada sheet tertentu

Wed Feb 15, 2017 12:00 am (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Cety,Bisa lihat contohnya diINDIRECT (Fungsi INDIRECT) - Dukungan Office
|
|
|
| | |

|

|
|
| |
INDIRECT (Fungsi INDIRECT) - Dukungan Office

Artikel ini menguraikan sintaks rumus dan penggunaan fungsi INDIRECT di Microsoft Excel.
| |

|

|

Salam,HK

Sent from Yahoo Mail on Android

On Tue, Feb 14, 2017 at 20:03, Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Makasih atas bantuan semua suhu. Bolehkah saya minta sedikit penjelasan mengenai penggunaan formula indirect? Sesuaikan dengan konteks pertanyaan saya biar sya lebih paham. Supaya bila ada kasus yang sama atau hampir sama saya mudah menggunakannya. Makasih sebelumnya.

--
Sent from myMail for Android
Minggu, 12 Februari 2017, 04:32PM +09:00 from ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] belajar-excel@yahoogroups.com:

 
tulis di B2
=INDIRECT($I$2"!B"&ROW(1:1))
copy ke bawah

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sab, 11/2/17, Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Sabtu, 11 Februari, 2017, 12:05 PM


 










Selamat siang para
suhu, saya punya masalah formula excel seperti pada
lampiran. Mohon bantuannya. Makasih










#yiv9320867305 #yiv9320867305 --
#yiv9320867305ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv9320867305 #yiv9320867305ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305ads {
margin-bottom:10px;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad {
padding:0 0;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad p {
margin:0;}

#yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad a {
color:#0000ff;text-decoration:none;}
#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc {
font-family:Arial;}

#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc #yiv9320867305hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ygrp-lc .yiv9320867305ad {
margin-bottom:10px;padding:0 0;}

#yiv9320867305 #yiv9320867305actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv9320867305 #yiv9320867305activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv9320867305 #yiv9320867305activity span {
font-weight:700;}

#yiv9320867305 #yiv9320867305activity span:first-child {
text-transform:uppercase;}

#yiv9320867305 #yiv9320867305activity span a {
color:#5085b6;text-decoration:none;}

#yiv9320867305 #yiv9320867305activity span span {
color:#ff7900;}

#yiv9320867305 #yiv9320867305activity span
.yiv9320867305underline {
text-decoration:underline;}

#yiv9320867305 .yiv9320867305attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv9320867305 .yiv9320867305attach div a {
text-decoration:none;}

#yiv9320867305 .yiv9320867305attach img {
border:none;padding-right:5px;}

#yiv9320867305 .yiv9320867305attach label {
display:block;margin-bottom:5px;}

#yiv9320867305 .yiv9320867305attach label a {
text-decoration:none;}

#yiv9320867305 blockquote {
margin:0 0 0 4px;}

#yiv9320867305 .yiv9320867305bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv9320867305 .yiv9320867305bold a {
text-decoration:none;}

#yiv9320867305 dd.yiv9320867305last p a {
font-family:Verdana;font-weight:700;}

#yiv9320867305 dd.yiv9320867305last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv9320867305 dd.yiv9320867305last p
span.yiv9320867305yshortcuts {
margin-right:0;}

#yiv9320867305 div.yiv9320867305attach-table div div a {
text-decoration:none;}

#yiv9320867305 div.yiv9320867305attach-table {
width:400px;}

#yiv9320867305 div.yiv9320867305file-title a, #yiv9320867305
div.yiv9320867305file-title a:active, #yiv9320867305
div.yiv9320867305file-title a:hover, #yiv9320867305
div.yiv9320867305file-title a:visited {
text-decoration:none;}

#yiv9320867305 div.yiv9320867305photo-title a,
#yiv9320867305 div.yiv9320867305photo-title a:active,
#yiv9320867305 div.yiv9320867305photo-title a:hover,
#yiv9320867305 div.yiv9320867305photo-title a:visited {
text-decoration:none;}

#yiv9320867305 div#yiv9320867305ygrp-mlmsg
#yiv9320867305ygrp-msg p a span.yiv9320867305yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv9320867305 .yiv9320867305green {
color:#628c2a;}

#yiv9320867305 .yiv9320867305MsoNormal {
margin:0 0 0 0;}

#yiv9320867305 o {
font-size:0;}

#yiv9320867305 #yiv9320867305photos div {
float:left;width:72px;}

#yiv9320867305 #yiv9320867305photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv9320867305 #yiv9320867305photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv9320867305 #yiv9320867305reco-category {
font-size:77%;}

#yiv9320867305 #yiv9320867305reco-desc {
font-size:77%;}

#yiv9320867305 .yiv9320867305replbq {
margin:4px;}

#yiv9320867305 #yiv9320867305ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg select,
#yiv9320867305 input, #yiv9320867305 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg pre, #yiv9320867305
code {
font:115% monospace;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg * {
line-height:1.22em;}

#yiv9320867305 #yiv9320867305ygrp-mlmsg #yiv9320867305logo {
padding-bottom:10px;}


#yiv9320867305 #yiv9320867305ygrp-msg p a {
font-family:Verdana;}

#yiv9320867305 #yiv9320867305ygrp-msg
p#yiv9320867305attach-count span {
color:#1E66AE;font-weight:700;}

#yiv9320867305 #yiv9320867305ygrp-reco
#yiv9320867305reco-head {
color:#ff7900;font-weight:700;}

#yiv9320867305 #yiv9320867305ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
li a {
font-size:130%;text-decoration:none;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv9320867305 #yiv9320867305ygrp-text {
font-family:Georgia;}

#yiv9320867305 #yiv9320867305ygrp-text p {
margin:0 0 1em 0;}

#yiv9320867305 #yiv9320867305ygrp-text tt {
font-size:120%;}

#yiv9320867305 #yiv9320867305ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv9320867305

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

2a

Gabung textboxt / combobox

Wed Feb 15, 2017 12:25 am (PST) . Posted by:

"Odhyz" odhyz83_assasaky

Dear Master,
Mohon pencerahannya, saya ingin menggabungkan isi textbox1, textbok2, textbok3 dan hasil penggabungannya di textbox4.

Terimakasih atas pencerahannya...
Odhy

Dikirim dari iPhone saya

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

2b

Bls: [belajar-excel] Gabung textboxt / combobox

Wed Feb 15, 2017 3:32 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Odhy, Saya kasi contoh untuk penggabungan kata pada textbox di sebuah worksheet. TerimaKasih.

Pada Rabu, 15 Februari 2017 15:25, "Odhyz odhyz83_assasaky@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Master,
Mohon pencerahannya, saya ingin menggabungkan isi textbox1, textbok2, textbok3 dan hasil penggabungannya di textbox4.

Terimakasih atas pencerahannya...
Odhy

Dikirim dari iPhone saya
#yiv9756290347 #yiv9756290347 -- #yiv9756290347ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9756290347 #yiv9756290347ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9756290347 #yiv9756290347ygrp-mkp #yiv9756290347hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9756290347 #yiv9756290347ygrp-mkp #yiv9756290347ads {margin-bottom:10px;}#yiv9756290347 #yiv9756290347ygrp-mkp .yiv9756290347ad {padding:0 0;}#yiv9756290347 #yiv9756290347ygrp-mkp .yiv9756290347ad p {margin:0;}#yiv9756290347 #yiv9756290347ygrp-mkp .yiv9756290347ad a {color:#0000ff;text-decoration:none;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ygrp-lc {font-family:Arial;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ygrp-lc #yiv9756290347hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ygrp-lc .yiv9756290347ad {margin-bottom:10px;padding:0 0;}#yiv9756290347 #yiv9756290347actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9756290347 #yiv9756290347activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9756290347 #yiv9756290347activity span {font-weight:700;}#yiv9756290347 #yiv9756290347activity span:first-child {text-transform:uppercase;}#yiv9756290347 #yiv9756290347activity span a {color:#5085b6;text-decoration:none;}#yiv9756290347 #yiv9756290347activity span span {color:#ff7900;}#yiv9756290347 #yiv9756290347activity span .yiv9756290347underline {text-decoration:underline;}#yiv9756290347 .yiv9756290347attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9756290347 .yiv9756290347attach div a {text-decoration:none;}#yiv9756290347 .yiv9756290347attach img {border:none;padding-right:5px;}#yiv9756290347 .yiv9756290347attach label {display:block;margin-bottom:5px;}#yiv9756290347 .yiv9756290347attach label a {text-decoration:none;}#yiv9756290347 blockquote {margin:0 0 0 4px;}#yiv9756290347 .yiv9756290347bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9756290347 .yiv9756290347bold a {text-decoration:none;}#yiv9756290347 dd.yiv9756290347last p a {font-family:Verdana;font-weight:700;}#yiv9756290347 dd.yiv9756290347last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9756290347 dd.yiv9756290347last p span.yiv9756290347yshortcuts {margin-right:0;}#yiv9756290347 div.yiv9756290347attach-table div div a {text-decoration:none;}#yiv9756290347 div.yiv9756290347attach-table {width:400px;}#yiv9756290347 div.yiv9756290347file-title a, #yiv9756290347 div.yiv9756290347file-title a:active, #yiv9756290347 div.yiv9756290347file-title a:hover, #yiv9756290347 div.yiv9756290347file-title a:visited {text-decoration:none;}#yiv9756290347 div.yiv9756290347photo-title a, #yiv9756290347 div.yiv9756290347photo-title a:active, #yiv9756290347 div.yiv9756290347photo-title a:hover, #yiv9756290347 div.yiv9756290347photo-title a:visited {text-decoration:none;}#yiv9756290347 div#yiv9756290347ygrp-mlmsg #yiv9756290347ygrp-msg p a span.yiv9756290347yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9756290347 .yiv9756290347green {color:#628c2a;}#yiv9756290347 .yiv9756290347MsoNormal {margin:0 0 0 0;}#yiv9756290347 o {font-size:0;}#yiv9756290347 #yiv9756290347photos div {float:left;width:72px;}#yiv9756290347 #yiv9756290347photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9756290347 #yiv9756290347photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9756290347 #yiv9756290347reco-category {font-size:77%;}#yiv9756290347 #yiv9756290347reco-desc {font-size:77%;}#yiv9756290347 .yiv9756290347replbq {margin:4px;}#yiv9756290347 #yiv9756290347ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9756290347 #yiv9756290347ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9756290347 #yiv9756290347ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9756290347 #yiv9756290347ygrp-mlmsg select, #yiv9756290347 input, #yiv9756290347 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9756290347 #yiv9756290347ygrp-mlmsg pre, #yiv9756290347 code {font:115% monospace;}#yiv9756290347 #yiv9756290347ygrp-mlmsg * {line-height:1.22em;}#yiv9756290347 #yiv9756290347ygrp-mlmsg #yiv9756290347logo {padding-bottom:10px;}#yiv9756290347 #yiv9756290347ygrp-msg p a {font-family:Verdana;}#yiv9756290347 #yiv9756290347ygrp-msg p#yiv9756290347attach-count span {color:#1E66AE;font-weight:700;}#yiv9756290347 #yiv9756290347ygrp-reco #yiv9756290347reco-head {color:#ff7900;font-weight:700;}#yiv9756290347 #yiv9756290347ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ov li a {font-size:130%;text-decoration:none;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9756290347 #yiv9756290347ygrp-sponsor #yiv9756290347ov ul {margin:0;padding:0 0 0 8px;}#yiv9756290347 #yiv9756290347ygrp-text {font-family:Georgia;}#yiv9756290347 #yiv9756290347ygrp-text p {margin:0 0 1em 0;}#yiv9756290347 #yiv9756290347ygrp-text tt {font-size:120%;}#yiv9756290347 #yiv9756290347ygrp-vital ul li:last-child {border-right:none !important;}#yiv9756290347

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

3a

Menentukan nilai dengan tahun berbeda

Wed Feb 15, 2017 12:27 am (PST) . Posted by:

"Cety Carmelo Julita"

Mohon maaf para suhu, ada pengembangan dalam kasus saya.
Selengakapnya ada dalam lampiran.
Maaf sudah sangat merepotkan.
Makasih atas bantuannya.

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

3b

Bls: [belajar-excel] Menentukan nilai dengan tahun berbeda [1 Attach

Wed Feb 15, 2017 3:28 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Cety, Coba gunakan formula ini di cell B2 : =IFERROR(INDEX(basedata!$D$2:$D$30,MATCH(1,(umum!A2=basedata!$C$2:$C$30)*(umum!$H$2=basedata!$A$2:$A$30)*(umum!$I$2=basedata!$B$2:$B$30),0)),0)  
karena Array formula, jangan lupa tekan ctrl+shift+enter sesudah memasukan formula di cell tersebut.

TerimaKasih.
 

Pada Rabu, 15 Februari 2017 15:27, "Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Mohon maaf para suhu, ada pengembangan dalam kasus saya.
Selengakapnya ada dalam lampiran.
Maaf sudah sangat merepotkan.
Makasih atas bantuannya.
#yiv6013656335 #yiv6013656335 -- #yiv6013656335ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6013656335 #yiv6013656335ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6013656335 #yiv6013656335ygrp-mkp #yiv6013656335hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6013656335 #yiv6013656335ygrp-mkp #yiv6013656335ads {margin-bottom:10px;}#yiv6013656335 #yiv6013656335ygrp-mkp .yiv6013656335ad {padding:0 0;}#yiv6013656335 #yiv6013656335ygrp-mkp .yiv6013656335ad p {margin:0;}#yiv6013656335 #yiv6013656335ygrp-mkp .yiv6013656335ad a {color:#0000ff;text-decoration:none;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ygrp-lc {font-family:Arial;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ygrp-lc #yiv6013656335hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ygrp-lc .yiv6013656335ad {margin-bottom:10px;padding:0 0;}#yiv6013656335 #yiv6013656335actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6013656335 #yiv6013656335activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6013656335 #yiv6013656335activity span {font-weight:700;}#yiv6013656335 #yiv6013656335activity span:first-child {text-transform:uppercase;}#yiv6013656335 #yiv6013656335activity span a {color:#5085b6;text-decoration:none;}#yiv6013656335 #yiv6013656335activity span span {color:#ff7900;}#yiv6013656335 #yiv6013656335activity span .yiv6013656335underline {text-decoration:underline;}#yiv6013656335 .yiv6013656335attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6013656335 .yiv6013656335attach div a {text-decoration:none;}#yiv6013656335 .yiv6013656335attach img {border:none;padding-right:5px;}#yiv6013656335 .yiv6013656335attach label {display:block;margin-bottom:5px;}#yiv6013656335 .yiv6013656335attach label a {text-decoration:none;}#yiv6013656335 blockquote {margin:0 0 0 4px;}#yiv6013656335 .yiv6013656335bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6013656335 .yiv6013656335bold a {text-decoration:none;}#yiv6013656335 dd.yiv6013656335last p a {font-family:Verdana;font-weight:700;}#yiv6013656335 dd.yiv6013656335last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6013656335 dd.yiv6013656335last p span.yiv6013656335yshortcuts {margin-right:0;}#yiv6013656335 div.yiv6013656335attach-table div div a {text-decoration:none;}#yiv6013656335 div.yiv6013656335attach-table {width:400px;}#yiv6013656335 div.yiv6013656335file-title a, #yiv6013656335 div.yiv6013656335file-title a:active, #yiv6013656335 div.yiv6013656335file-title a:hover, #yiv6013656335 div.yiv6013656335file-title a:visited {text-decoration:none;}#yiv6013656335 div.yiv6013656335photo-title a, #yiv6013656335 div.yiv6013656335photo-title a:active, #yiv6013656335 div.yiv6013656335photo-title a:hover, #yiv6013656335 div.yiv6013656335photo-title a:visited {text-decoration:none;}#yiv6013656335 div#yiv6013656335ygrp-mlmsg #yiv6013656335ygrp-msg p a span.yiv6013656335yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6013656335 .yiv6013656335green {color:#628c2a;}#yiv6013656335 .yiv6013656335MsoNormal {margin:0 0 0 0;}#yiv6013656335 o {font-size:0;}#yiv6013656335 #yiv6013656335photos div {float:left;width:72px;}#yiv6013656335 #yiv6013656335photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6013656335 #yiv6013656335photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6013656335 #yiv6013656335reco-category {font-size:77%;}#yiv6013656335 #yiv6013656335reco-desc {font-size:77%;}#yiv6013656335 .yiv6013656335replbq {margin:4px;}#yiv6013656335 #yiv6013656335ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6013656335 #yiv6013656335ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6013656335 #yiv6013656335ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6013656335 #yiv6013656335ygrp-mlmsg select, #yiv6013656335 input, #yiv6013656335 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6013656335 #yiv6013656335ygrp-mlmsg pre, #yiv6013656335 code {font:115% monospace;}#yiv6013656335 #yiv6013656335ygrp-mlmsg * {line-height:1.22em;}#yiv6013656335 #yiv6013656335ygrp-mlmsg #yiv6013656335logo {padding-bottom:10px;}#yiv6013656335 #yiv6013656335ygrp-msg p a {font-family:Verdana;}#yiv6013656335 #yiv6013656335ygrp-msg p#yiv6013656335attach-count span {color:#1E66AE;font-weight:700;}#yiv6013656335 #yiv6013656335ygrp-reco #yiv6013656335reco-head {color:#ff7900;font-weight:700;}#yiv6013656335 #yiv6013656335ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ov li a {font-size:130%;text-decoration:none;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6013656335 #yiv6013656335ygrp-sponsor #yiv6013656335ov ul {margin:0;padding:0 0 0 8px;}#yiv6013656335 #yiv6013656335ygrp-text {font-family:Georgia;}#yiv6013656335 #yiv6013656335ygrp-text p {margin:0 0 1em 0;}#yiv6013656335 #yiv6013656335ygrp-text tt {font-size:120%;}#yiv6013656335 #yiv6013656335ygrp-vital ul li:last-child {border-right:none !important;}#yiv6013656335

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

4a

Re: memilih nilai pada sheet tertentu

Wed Feb 15, 2017 12:27 am (PST) . Posted by:

"Cety Carmelo Julita"

Selamat siang bang ghozi, saya sudah coba rumusnya tapi kok hasilnya
salah ya.. Mohon penjelasannya biar saya paham. Makasih

2017-02-12 16:32 GMT+09.00, ghozi alkatiri ghozialkatiri@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
> tulis di B2
> =INDIRECT($I$2&"!B"&ROW(1:1))
> copy ke bawah
>
> wassalam
>
> Ghozi Alkatiri
> --------------------------------------------
> Pada Sab, 11/2/17, Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel]
> <belajar-excel@yahoogroups.com> menulis:
>
> Judul: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]
> Kepada: belajar-excel@yahoogroups.com
> Tanggal: Sabtu, 11 Februari, 2017, 12:05 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
> Selamat siang para
> suhu, saya punya masalah formula excel seperti pada
> lampiran. Mohon bantuannya. Makasih
>
>
>
>
>
>
>
>
>
>
> #yiv9320867305 #yiv9320867305 --
> #yiv9320867305ygrp-mkp {
> border:1px solid #d8d8d8;font-family:Arial;margin:10px
> 0;padding:0 10px;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp hr {
> border:1px solid #d8d8d8;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305hd {
> color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305ads {
> margin-bottom:10px;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad {
> padding:0 0;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad p {
> margin:0;}
>
> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad a {
> color:#0000ff;text-decoration:none;}
> #yiv9320867305 #yiv9320867305ygrp-sponsor
> #yiv9320867305ygrp-lc {
> font-family:Arial;}
>
> #yiv9320867305 #yiv9320867305ygrp-sponsor
> #yiv9320867305ygrp-lc #yiv9320867305hd {
> margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}
>
> #yiv9320867305 #yiv9320867305ygrp-sponsor
> #yiv9320867305ygrp-lc .yiv9320867305ad {
> margin-bottom:10px;padding:0 0;}
>
> #yiv9320867305 #yiv9320867305actions {
> font-family:Verdana;font-size:11px;padding:10px 0;}
>
> #yiv9320867305 #yiv9320867305activity {
> background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
>
> #yiv9320867305 #yiv9320867305activity span {
> font-weight:700;}
>
> #yiv9320867305 #yiv9320867305activity span:first-child {
> text-transform:uppercase;}
>
> #yiv9320867305 #yiv9320867305activity span a {
> color:#5085b6;text-decoration:none;}
>
> #yiv9320867305 #yiv9320867305activity span span {
> color:#ff7900;}
>
> #yiv9320867305 #yiv9320867305activity span
> .yiv9320867305underline {
> text-decoration:underline;}
>
> #yiv9320867305 .yiv9320867305attach {
> clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}
>
> #yiv9320867305 .yiv9320867305attach div a {
> text-decoration:none;}
>
> #yiv9320867305 .yiv9320867305attach img {
> border:none;padding-right:5px;}
>
> #yiv9320867305 .yiv9320867305attach label {
> display:block;margin-bottom:5px;}
>
> #yiv9320867305 .yiv9320867305attach label a {
> text-decoration:none;}
>
> #yiv9320867305 blockquote {
> margin:0 0 0 4px;}
>
> #yiv9320867305 .yiv9320867305bold {
> font-family:Arial;font-size:13px;font-weight:700;}
>
> #yiv9320867305 .yiv9320867305bold a {
> text-decoration:none;}
>
> #yiv9320867305 dd.yiv9320867305last p a {
> font-family:Verdana;font-weight:700;}
>
> #yiv9320867305 dd.yiv9320867305last p span {
> margin-right:10px;font-family:Verdana;font-weight:700;}
>
> #yiv9320867305 dd.yiv9320867305last p
> span.yiv9320867305yshortcuts {
> margin-right:0;}
>
> #yiv9320867305 div.yiv9320867305attach-table div div a {
> text-decoration:none;}
>
> #yiv9320867305 div.yiv9320867305attach-table {
> width:400px;}
>
> #yiv9320867305 div.yiv9320867305file-title a, #yiv9320867305
> div.yiv9320867305file-title a:active, #yiv9320867305
> div.yiv9320867305file-title a:hover, #yiv9320867305
> div.yiv9320867305file-title a:visited {
> text-decoration:none;}
>
> #yiv9320867305 div.yiv9320867305photo-title a,
> #yiv9320867305 div.yiv9320867305photo-title a:active,
> #yiv9320867305 div.yiv9320867305photo-title a:hover,
> #yiv9320867305 div.yiv9320867305photo-title a:visited {
> text-decoration:none;}
>
> #yiv9320867305 div#yiv9320867305ygrp-mlmsg
> #yiv9320867305ygrp-msg p a span.yiv9320867305yshortcuts {
> font-family:Verdana;font-size:10px;font-weight:normal;}
>
> #yiv9320867305 .yiv9320867305green {
> color:#628c2a;}
>
> #yiv9320867305 .yiv9320867305MsoNormal {
> margin:0 0 0 0;}
>
> #yiv9320867305 o {
> font-size:0;}
>
> #yiv9320867305 #yiv9320867305photos div {
> float:left;width:72px;}
>
> #yiv9320867305 #yiv9320867305photos div div {
> border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}
>
> #yiv9320867305 #yiv9320867305photos div label {
> color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
>
> #yiv9320867305 #yiv9320867305reco-category {
> font-size:77%;}
>
> #yiv9320867305 #yiv9320867305reco-desc {
> font-size:77%;}
>
> #yiv9320867305 .yiv9320867305replbq {
> margin:4px;}
>
> #yiv9320867305 #yiv9320867305ygrp-actbar div a:first-child {
> margin-right:2px;padding-right:5px;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg {
> font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg table {
> font-size:inherit;font:100%;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg select,
> #yiv9320867305 input, #yiv9320867305 textarea {
> font:99% Arial, Helvetica, clean, sans-serif;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg pre, #yiv9320867305
> code {
> font:115% monospace;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg * {
> line-height:1.22em;}
>
> #yiv9320867305 #yiv9320867305ygrp-mlmsg #yiv9320867305logo {
> padding-bottom:10px;}
>
>
> #yiv9320867305 #yiv9320867305ygrp-msg p a {
> font-family:Verdana;}
>
> #yiv9320867305 #yiv9320867305ygrp-msg
> p#yiv9320867305attach-count span {
> color:#1E66AE;font-weight:700;}
>
> #yiv9320867305 #yiv9320867305ygrp-reco
> #yiv9320867305reco-head {
> color:#ff7900;font-weight:700;}
>
> #yiv9320867305 #yiv9320867305ygrp-reco {
> margin-bottom:20px;padding:0px;}
>
> #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
> li a {
> font-size:130%;text-decoration:none;}
>
> #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
> li {
> font-size:77%;list-style-type:square;padding:6px 0;}
>
> #yiv9320867305 #yiv9320867305ygrp-sponsor #yiv9320867305ov
> ul {
> margin:0;padding:0 0 0 8px;}
>
> #yiv9320867305 #yiv9320867305ygrp-text {
> font-family:Georgia;}
>
> #yiv9320867305 #yiv9320867305ygrp-text p {
> margin:0 0 1em 0;}
>
> #yiv9320867305 #yiv9320867305ygrp-text tt {
> font-size:120%;}
>
> #yiv9320867305 #yiv9320867305ygrp-vital ul li:last-child {
> border-right:none !important;
> }
> #yiv9320867305
>
>

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

4b

Re: memilih nilai pada sheet tertentu

Wed Feb 15, 2017 1:07 pm (PST) . Posted by:

"ghozi alkatiri" ghozialkatiri

ini coba langsung saya kirim attachmentnya
wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Rab, 15/2/17, Cety Carmelo Julita cetycarmelo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] memilih nilai pada sheet tertentu
Kepada: belajar-excel@yahoogroups.com
Tanggal: Rabu, 15 Februari, 2017, 2:00 PM


 









Selamat siang bang ghozi, saya sudah coba rumusnya
tapi kok hasilnya

salah ya.. Mohon penjelasannya biar saya paham. Makasih



2017-02-12 16:32 GMT+09.00, ghozi alkatiri
ghozialkatiri@yahoo.co.id

[belajar-excel] <belajar-excel@yahoogroups.com>:

> tulis di B2

> =INDIRECT($I$2&"!B"&ROW(1:1))

> copy ke bawah

>

> wassalam

>

> Ghozi Alkatiri

> --------------------------------------------

> Pada Sab, 11/2/17, Cety Carmelo Julita
cetycarmelo@gmail.com [belajar-excel]

> <belajar-excel@yahoogroups.com> menulis:

>

> Judul: [belajar-excel] memilih nilai pada sheet
tertentu [1 Attachment]

> Kepada: belajar-excel@yahoogroups.com

> Tanggal: Sabtu, 11 Februari, 2017, 12:05 PM

>

>

>

>

>

>

>

>

>

>

>

>

>

> Selamat siang para

> suhu, saya punya masalah formula excel seperti pada

> lampiran. Mohon bantuannya. Makasih

>

>

>

>

>

>

>

>

>

>

> #yiv9320867305 #yiv9320867305 --

> #yiv9320867305ygrp-mkp {

> border:1px solid
#d8d8d8;font-family:Arial;margin:10px

> 0;padding:0 10px;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp hr {

> border:1px solid #d8d8d8;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp #yiv9320867305hd
{

>
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

> 0;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp
#yiv9320867305ads {

> margin-bottom:10px;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad
{

> padding:0 0;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad
p {

> margin:0;}

>

> #yiv9320867305 #yiv9320867305ygrp-mkp .yiv9320867305ad
a {

> color:#0000ff;text-decoration:none;}

> #yiv9320867305 #yiv9320867305ygrp-sponsor

> #yiv9320867305ygrp-lc {

> font-family:Arial;}

>

> #yiv9320867305 #yiv9320867305ygrp-sponsor

> #yiv9320867305ygrp-lc #yiv9320867305hd {

> margin:10px

>
0px;font-weight:700;font-size:78%;line-height:122%;}

>

> #yiv9320867305 #yiv9320867305ygrp-sponsor

> #yiv9320867305ygrp-lc .yiv9320867305ad {

> margin-bottom:10px;padding:0 0;}

>

> #yiv9320867305 #yiv9320867305actions {

> font-family:Verdana;font-size:11px;padding:10px 0;}

>

> #yiv9320867305 #yiv9320867305activity {

>
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

>

> #yiv9320867305 #yiv9320867305activity span {

> font-weight:700;}

>

> #yiv9320867305 #yiv9320867305activity span:first-child
{

> text-transform:uppercase;}

>

> #yiv9320867305 #yiv9320867305activity span a {

> color:#5085b6;text-decoration:none;}

>

> #yiv9320867305 #yiv9320867305activity span span {

> color:#ff7900;}

>

> #yiv9320867305 #yiv9320867305activity span

> .yiv9320867305underline {

> text-decoration:underline;}

>

> #yiv9320867305 .yiv9320867305attach {

>
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

> 0;width:400px;}

>

> #yiv9320867305 .yiv9320867305attach div a {

> text-decoration:none;}

>

> #yiv9320867305 .yiv9320867305attach img {

> border:none;padding-right:5px;}

>

> #yiv9320867305 .yiv9320867305attach label {

> display:block;margin-bottom:5px;}

>

> #yiv9320867305 .yiv9320867305attach label a {

> text-decoration:none;}

>

> #yiv9320867305 blockquote {

> margin:0 0 0 4px;}

>

> #yiv9320867305 .yiv9320867305bold {

> font-family:Arial;font-size:13px;font-weight:700;}

>

> #yiv9320867305 .yiv9320867305bold a {

> text-decoration:none;}

>

> #yiv9320867305 dd.yiv9320867305last p a {

> font-family:Verdana;font-weight:700;}

>

> #yiv9320867305 dd.yiv9320867305last p span {

>
margin-right:10px;font-family:Verdana;font-weight:700;}

>

> #yiv9320867305 dd.yiv9320867305last p

> span.yiv9320867305yshortcuts {

> margin-right:0;}

>

> #yiv9320867305 div.yiv9320867305attach-table div div a
{

> text-decoration:none;}

>

> #yiv9320867305 div.yiv9320867305attach-table {

> width:400px;}

>

> #yiv9320867305 div.yiv9320867305file-title a,
#yiv9320867305

> div.yiv9320867305file-title a:active,
#yiv9320867305

> div.yiv9320867305file-title a:hover, #yiv9320867305

> div.yiv9320867305file-title a:visited {

> text-decoration:none;}

>

> #yiv9320867305 div.yiv9320867305photo-title a,

> #yiv9320867305 div.yiv9320867305photo-title
a:active,

> #yiv9320867305 div.yiv9320867305photo-title
a:hover,

> #yiv9320867305 div.yiv9320867305photo-title a:visited
{

> text-decoration:none;}

>

> #yiv9320867305 div#yiv9320867305ygrp-mlmsg

> #yiv9320867305ygrp-msg p a
span.yiv9320867305yshortcuts {

>
font-family:Verdana;font-size:10px;font-weight:normal;}

>

> #yiv9320867305 .yiv9320867305green {

> color:#628c2a;}

>

> #yiv9320867305 .yiv9320867305MsoNormal {

> margin:0 0 0 0;}

>

> #yiv9320867305 o {

> font-size:0;}

>

> #yiv9320867305 #yiv9320867305photos div {

> float:left;width:72px;}

>

> #yiv9320867305 #yiv9320867305photos div div {

> border:1px solid

> #666666;height:62px;overflow:hidden;width:62px;}

>

> #yiv9320867305 #yiv9320867305photos div label {

>
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

>

> #yiv9320867305 #yiv9320867305reco-category {

> font-size:77%;}

>

> #yiv9320867305 #yiv9320867305reco-desc {

> font-size:77%;}

>

> #yiv9320867305 .yiv9320867305replbq {

> margin:4px;}

>

> #yiv9320867305 #yiv9320867305ygrp-actbar div
a:first-child {

> margin-right:2px;padding-right:5px;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg {

> font-size:13px;font-family:Arial, helvetica, clean,

> sans-serif;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg table {

> font-size:inherit;font:100%;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg select,

> #yiv9320867305 input, #yiv9320867305 textarea {

> font:99% Arial, Helvetica, clean, sans-serif;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg pre,
#yiv9320867305

> code {

> font:115% monospace;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg * {

> line-height:1.22em;}

>

> #yiv9320867305 #yiv9320867305ygrp-mlmsg
#yiv9320867305logo {

> padding-bottom:10px;}

>

>

> #yiv9320867305 #yiv9320867305ygrp-msg p a {

> font-family:Verdana;}

>

> #yiv9320867305 #yiv9320867305ygrp-msg

> p#yiv9320867305attach-count span {

> color:#1E66AE;font-weight:700;}

>

> #yiv9320867305 #yiv9320867305ygrp-reco

> #yiv9320867305reco-head {

> color:#ff7900;font-weight:700;}

>

> #yiv9320867305 #yiv9320867305ygrp-reco {

> margin-bottom:20px;padding:0px;}

>

> #yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ov

> li a {

> font-size:130%;text-decoration:none;}

>

> #yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ov

> li {

> font-size:77%;list-style-type:square;padding:6px
0;}

>

> #yiv9320867305 #yiv9320867305ygrp-sponsor
#yiv9320867305ov

> ul {

> margin:0;padding:0 0 0 8px;}

>

> #yiv9320867305 #yiv9320867305ygrp-text {

> font-family:Georgia;}

>

> #yiv9320867305 #yiv9320867305ygrp-text p {

> margin:0 0 1em 0;}

>

> #yiv9320867305 #yiv9320867305ygrp-text tt {

> font-size:120%;}

>

> #yiv9320867305 #yiv9320867305ygrp-vital ul
li:last-child {

> border-right:none !important;

> }

> #yiv9320867305

>

>











#yiv6399590072 #yiv6399590072 --
#yiv6399590072ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv6399590072 #yiv6399590072ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv6399590072 #yiv6399590072ygrp-mkp #yiv6399590072hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv6399590072 #yiv6399590072ygrp-mkp #yiv6399590072ads {
margin-bottom:10px;}

#yiv6399590072 #yiv6399590072ygrp-mkp .yiv6399590072ad {
padding:0 0;}

#yiv6399590072 #yiv6399590072ygrp-mkp .yiv6399590072ad p {
margin:0;}

#yiv6399590072 #yiv6399590072ygrp-mkp .yiv6399590072ad a {
color:#0000ff;text-decoration:none;}
#yiv6399590072 #yiv6399590072ygrp-sponsor
#yiv6399590072ygrp-lc {
font-family:Arial;}

#yiv6399590072 #yiv6399590072ygrp-sponsor
#yiv6399590072ygrp-lc #yiv6399590072hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv6399590072 #yiv6399590072ygrp-sponsor
#yiv6399590072ygrp-lc .yiv6399590072ad {
margin-bottom:10px;padding:0 0;}

#yiv6399590072 #yiv6399590072actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv6399590072 #yiv6399590072activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv6399590072 #yiv6399590072activity span {
font-weight:700;}

#yiv6399590072 #yiv6399590072activity span:first-child {
text-transform:uppercase;}

#yiv6399590072 #yiv6399590072activity span a {
color:#5085b6;text-decoration:none;}

#yiv6399590072 #yiv6399590072activity span span {
color:#ff7900;}

#yiv6399590072 #yiv6399590072activity span
.yiv6399590072underline {
text-decoration:underline;}

#yiv6399590072 .yiv6399590072attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv6399590072 .yiv6399590072attach div a {
text-decoration:none;}

#yiv6399590072 .yiv6399590072attach img {
border:none;padding-right:5px;}

#yiv6399590072 .yiv6399590072attach label {
display:block;margin-bottom:5px;}

#yiv6399590072 .yiv6399590072attach label a {
text-decoration:none;}

#yiv6399590072 blockquote {
margin:0 0 0 4px;}

#yiv6399590072 .yiv6399590072bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv6399590072 .yiv6399590072bold a {
text-decoration:none;}

#yiv6399590072 dd.yiv6399590072last p a {
font-family:Verdana;font-weight:700;}

#yiv6399590072 dd.yiv6399590072last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv6399590072 dd.yiv6399590072last p
span.yiv6399590072yshortcuts {
margin-right:0;}

#yiv6399590072 div.yiv6399590072attach-table div div a {
text-decoration:none;}

#yiv6399590072 div.yiv6399590072attach-table {
width:400px;}

#yiv6399590072 div.yiv6399590072file-title a, #yiv6399590072
div.yiv6399590072file-title a:active, #yiv6399590072
div.yiv6399590072file-title a:hover, #yiv6399590072
div.yiv6399590072file-title a:visited {
text-decoration:none;}

#yiv6399590072 div.yiv6399590072photo-title a,
#yiv6399590072 div.yiv6399590072photo-title a:active,
#yiv6399590072 div.yiv6399590072photo-title a:hover,
#yiv6399590072 div.yiv6399590072photo-title a:visited {
text-decoration:none;}

#yiv6399590072 div#yiv6399590072ygrp-mlmsg
#yiv6399590072ygrp-msg p a span.yiv6399590072yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv6399590072 .yiv6399590072green {
color:#628c2a;}

#yiv6399590072 .yiv6399590072MsoNormal {
margin:0 0 0 0;}

#yiv6399590072 o {
font-size:0;}

#yiv6399590072 #yiv6399590072photos div {
float:left;width:72px;}

#yiv6399590072 #yiv6399590072photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv6399590072 #yiv6399590072photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv6399590072 #yiv6399590072reco-category {
font-size:77%;}

#yiv6399590072 #yiv6399590072reco-desc {
font-size:77%;}

#yiv6399590072 .yiv6399590072replbq {
margin:4px;}

#yiv6399590072 #yiv6399590072ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg select,
#yiv6399590072 input, #yiv6399590072 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg pre, #yiv6399590072
code {
font:115% monospace;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg * {
line-height:1.22em;}

#yiv6399590072 #yiv6399590072ygrp-mlmsg #yiv6399590072logo {
padding-bottom:10px;}


#yiv6399590072 #yiv6399590072ygrp-msg p a {
font-family:Verdana;}

#yiv6399590072 #yiv6399590072ygrp-msg
p#yiv6399590072attach-count span {
color:#1E66AE;font-weight:700;}

#yiv6399590072 #yiv6399590072ygrp-reco
#yiv6399590072reco-head {
color:#ff7900;font-weight:700;}

#yiv6399590072 #yiv6399590072ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv6399590072 #yiv6399590072ygrp-sponsor #yiv6399590072ov
li a {
font-size:130%;text-decoration:none;}

#yiv6399590072 #yiv6399590072ygrp-sponsor #yiv6399590072ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv6399590072 #yiv6399590072ygrp-sponsor #yiv6399590072ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv6399590072 #yiv6399590072ygrp-text {
font-family:Georgia;}

#yiv6399590072 #yiv6399590072ygrp-text p {
margin:0 0 1em 0;}

#yiv6399590072 #yiv6399590072ygrp-text tt {
font-size:120%;}

#yiv6399590072 #yiv6399590072ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv6399590072

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

• New Members 5

• Privacy • Unsubscribe • Terms of Use