[belajar-excel] Digest Number 4095

Milis Belajar Microsoft Excel Group

3 Messages

Digest #4095

1a

Re: Hide row, Nomor urut otomatis berubah [1 Attachment] by "M.Ade Alfarid" aderyo

2a

Re: memilih nilai pada sheet tertentu [1 Attachment] by "hendrik karnadi" hendrikkarnadi

2b

Fw: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment] by "hendrik karnadi" hendrikkarnadi

Messages

1a

Re: Hide row, Nomor urut otomatis berubah [1 Attachment]

Wed Feb 15, 2017 8:21 pm (PST) . Posted by:

"M.Ade Alfarid" aderyo

Nah mas ari,

Pertanyaan berikut adalah bagaimana kriteria untuk menyembunyikannya,

Apakah klik select atau orang yg input nya musti klik button terpisah?

Monggo di ulik ya mas ari,

Salam bexcel

*From:* belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]

*Sent:* Wednesday, February 15, 2017 5:50 AM
*To:* belajar-excel@yahoogroups.com
*Subject:* Bls: [belajar-excel] Hide row, Nomor urut otomatis berubah [1
Attachment]

lihat di attachment
pada tabel asal di sheet sebelum beri tanda silang (X) pada row yang ingin
disembunyikan selanutnya lihat hasilnya di sheet setelah

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sel, 14/2/17, Aku Ary akuary11@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] Hide row, Nomor urut otomatis berubah [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 14 Februari, 2017, 2:35 PM

Dear Para Suhu,
Mohon
bimbingannya..Apabila melakukan hide pada baris tertentu, maka nomor
urut secara otomatis akan ikut berubah mengikuti sesuai
urutan yang ada (hanya tampil urutan dari data yang tidak di
hidden).
Terima kasih atas bantuan dan
pencerahannya.
Mohon maaf apabila sudah pernah
dibahas sebelumnya..

salam,ary
*terlampir contoh kasus
sederhana

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

#yiv3269378210 #yiv3269378210ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210ads {
margin-bottom:10px;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad {
padding:0 0;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad p {
margin:0;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad a {
color:#0000ff;text-decoration:none;}
#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc {
font-family:Arial;}

#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc #yiv3269378210hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc .yiv3269378210ad {
margin-bottom:10px;padding:0 0;}

#yiv3269378210 #yiv3269378210actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv3269378210 #yiv3269378210activity span {
font-weight:700;}

#yiv3269378210 #yiv3269378210activity span:first-child {
text-transform:uppercase;}

#yiv3269378210 #yiv3269378210activity span a {
color:#5085b6;text-decoration:none;}

#yiv3269378210 #yiv3269378210activity span span {
color:#ff7900;}

#yiv3269378210 #yiv3269378210activity span
.yiv3269378210underline {
text-decoration:underline;}

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

#yiv3269378210 .yiv3269378210attach div a {
text-decoration:none;}

#yiv3269378210 .yiv3269378210attach img {
border:none;padding-right:5px;}

#yiv3269378210 .yiv3269378210attach label {
display:block;margin-bottom:5px;}

#yiv3269378210 .yiv3269378210attach label a {
text-decoration:none;}

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

#yiv3269378210 .yiv3269378210bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3269378210 .yiv3269378210bold a {
text-decoration:none;}

#yiv3269378210 dd.yiv3269378210last p a {
font-family:Verdana;font-weight:700;}

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

#yiv3269378210 dd.yiv3269378210last p
span.yiv3269378210yshortcuts {
margin-right:0;}

#yiv3269378210 div.yiv3269378210attach-table div div a {
text-decoration:none;}

#yiv3269378210 div.yiv3269378210attach-table {
width:400px;}

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

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

#yiv3269378210 div#yiv3269378210ygrp-mlmsg
#yiv3269378210ygrp-msg p a span.yiv3269378210yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3269378210 .yiv3269378210green {
color:#628c2a;}

#yiv3269378210 .yiv3269378210MsoNormal {
margin:0 0 0 0;}

#yiv3269378210 o {
font-size:0;}

#yiv3269378210 #yiv3269378210photos div {
float:left;width:72px;}

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

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

#yiv3269378210 #yiv3269378210reco-category {
font-size:77%;}

#yiv3269378210 #yiv3269378210reco-desc {
font-size:77%;}

#yiv3269378210 .yiv3269378210replbq {
margin:4px;}

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

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

#yiv3269378210 #yiv3269378210ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv3269378210 #yiv3269378210ygrp-mlmsg pre, #yiv3269378210
code {
font:115% monospace;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg * {
line-height:1.22em;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg #yiv3269378210logo {
padding-bottom:10px;}

#yiv3269378210 #yiv3269378210ygrp-msg p a {
font-family:Verdana;}

#yiv3269378210 #yiv3269378210ygrp-msg
p#yiv3269378210attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3269378210 #yiv3269378210ygrp-reco
#yiv3269378210reco-head {
color:#ff7900;font-weight:700;}

#yiv3269378210 #yiv3269378210ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
li a {
font-size:130%;text-decoration:none;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3269378210 #yiv3269378210ygrp-text {
font-family:Georgia;}

#yiv3269378210 #yiv3269378210ygrp-text p {
margin:0 0 1em 0;}

#yiv3269378210 #yiv3269378210ygrp-text tt {
font-size:120%;}

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

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

2a

Re: memilih nilai pada sheet tertentu [1 Attachment]

Wed Feb 15, 2017 9:32 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Cety,
Kalau boleh nambahin dikit ("menjelaskan yang sdh jelas" kata mbak Siti), maksud dari formula=INDIRECT($I$2&"!B"&ROW(1:1)) adalah sbb:

INDIRECT($I$2$I$2 adalah mengambil isi sel I2 (januari, februari atau maret) sesuai nama sheet yang dipilih.& adalah tanda penghubung"!B" adalah kolom B dari sheet yang dipilihROW(1:1) adalah baris 1
Jadi kalau pilihannya "februari" maka formula pada sel B2 menjadi =februari!B1, yang berisi angkak 8.Jika dicopy ke bawah maka formula pada sel B3 menjadi =februari!B2, yang berisi angka 0.
Jika kita ganti I2 menjadi januari maka formula pada sel B2 menjadi =januari!B1, yang berisi anga 5.Jika dicopy ke bawah maka formula pada sel B3 menjadi =januari!B2, yang berisi angka 6.
S&K susunan (urutan) data pada Sheet januari, februari dan maret harus sama.
Salam,HK

From: "ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 16 February 2017, 4:07
Subject: Re: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]

  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 #yiv2887357956 #yiv2887357956 -- #yiv2887357956ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2887357956 #yiv2887357956ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2887357956 #yiv2887357956ygrp-mkp #yiv2887357956hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2887357956 #yiv2887357956ygrp-mkp #yiv2887357956ads {margin-bottom:10px;}#yiv2887357956 #yiv2887357956ygrp-mkp .yiv2887357956ad {padding:0 0;}#yiv2887357956 #yiv2887357956ygrp-mkp .yiv2887357956ad p {margin:0;}#yiv2887357956 #yiv2887357956ygrp-mkp .yiv2887357956ad a {color:#0000ff;text-decoration:none;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ygrp-lc {font-family:Arial;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ygrp-lc #yiv2887357956hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ygrp-lc .yiv2887357956ad {margin-bottom:10px;padding:0 0;}#yiv2887357956 #yiv2887357956actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2887357956 #yiv2887357956activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2887357956 #yiv2887357956activity span {font-weight:700;}#yiv2887357956 #yiv2887357956activity span:first-child {text-transform:uppercase;}#yiv2887357956 #yiv2887357956activity span a {color:#5085b6;text-decoration:none;}#yiv2887357956 #yiv2887357956activity span span {color:#ff7900;}#yiv2887357956 #yiv2887357956activity span .yiv2887357956underline {text-decoration:underline;}#yiv2887357956 .yiv2887357956attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2887357956 .yiv2887357956attach div a {text-decoration:none;}#yiv2887357956 .yiv2887357956attach img {border:none;padding-right:5px;}#yiv2887357956 .yiv2887357956attach label {display:block;margin-bottom:5px;}#yiv2887357956 .yiv2887357956attach label a {text-decoration:none;}#yiv2887357956 blockquote {margin:0 0 0 4px;}#yiv2887357956 .yiv2887357956bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2887357956 .yiv2887357956bold a {text-decoration:none;}#yiv2887357956 dd.yiv2887357956last p a {font-family:Verdana;font-weight:700;}#yiv2887357956 dd.yiv2887357956last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2887357956 dd.yiv2887357956last p span.yiv2887357956yshortcuts {margin-right:0;}#yiv2887357956 div.yiv2887357956attach-table div div a {text-decoration:none;}#yiv2887357956 div.yiv2887357956attach-table {width:400px;}#yiv2887357956 div.yiv2887357956file-title a, #yiv2887357956 div.yiv2887357956file-title a:active, #yiv2887357956 div.yiv2887357956file-title a:hover, #yiv2887357956 div.yiv2887357956file-title a:visited {text-decoration:none;}#yiv2887357956 div.yiv2887357956photo-title a, #yiv2887357956 div.yiv2887357956photo-title a:active, #yiv2887357956 div.yiv2887357956photo-title a:hover, #yiv2887357956 div.yiv2887357956photo-title a:visited {text-decoration:none;}#yiv2887357956 div#yiv2887357956ygrp-mlmsg #yiv2887357956ygrp-msg p a span.yiv2887357956yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2887357956 .yiv2887357956green {color:#628c2a;}#yiv2887357956 .yiv2887357956MsoNormal {margin:0 0 0 0;}#yiv2887357956 o {font-size:0;}#yiv2887357956 #yiv2887357956photos div {float:left;width:72px;}#yiv2887357956 #yiv2887357956photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2887357956 #yiv2887357956photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2887357956 #yiv2887357956reco-category {font-size:77%;}#yiv2887357956 #yiv2887357956reco-desc {font-size:77%;}#yiv2887357956 .yiv2887357956replbq {margin:4px;}#yiv2887357956 #yiv2887357956ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2887357956 #yiv2887357956ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2887357956 #yiv2887357956ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2887357956 #yiv2887357956ygrp-mlmsg select, #yiv2887357956 input, #yiv2887357956 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2887357956 #yiv2887357956ygrp-mlmsg pre, #yiv2887357956 code {font:115% monospace;}#yiv2887357956 #yiv2887357956ygrp-mlmsg * {line-height:1.22em;}#yiv2887357956 #yiv2887357956ygrp-mlmsg #yiv2887357956logo {padding-bottom:10px;}#yiv2887357956 #yiv2887357956ygrp-msg p a {font-family:Verdana;}#yiv2887357956 #yiv2887357956ygrp-msg p#yiv2887357956attach-count span {color:#1E66AE;font-weight:700;}#yiv2887357956 #yiv2887357956ygrp-reco #yiv2887357956reco-head {color:#ff7900;font-weight:700;}#yiv2887357956 #yiv2887357956ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ov li a {font-size:130%;text-decoration:none;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2887357956 #yiv2887357956ygrp-sponsor #yiv2887357956ov ul {margin:0;padding:0 0 0 8px;}#yiv2887357956 #yiv2887357956ygrp-text {font-family:Georgia;}#yiv2887357956 #yiv2887357956ygrp-text p {margin:0 0 1em 0;}#yiv2887357956 #yiv2887357956ygrp-text tt {font-size:120%;}#yiv2887357956 #yiv2887357956ygrp-vital ul li:last-child {border-right:none !important;}#yiv2887357956

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

2b

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

Wed Feb 15, 2017 9:33 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Maaf $I$2 nya dobel.

----- Forwarded Message -----
From: hendrik karnadi <hendrikkarnadi@yahoo.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Thursday, 16 February 2017, 12:28
Subject: Re: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]

Hai Cety,
Kalau boleh nambahin dikit ("menjelaskan yang sdh jelas" kata mbak Siti), maksud dari formula=INDIRECT($I$2&"!B"&ROW(1:1)) adalah sbb:

INDIRECT($I$2$I$2 adalah mengambil isi sel I2 (januari, februari atau maret) sesuai nama sheet yang dipilih.& adalah tanda penghubung"!B" adalah kolom B dari sheet yang dipilihROW(1:1) adalah baris 1
Jadi kalau pilihannya "februari" maka formula pada sel B2 menjadi =februari!B1, yang berisi angkak 8.Jika dicopy ke bawah maka formula pada sel B3 menjadi =februari!B2, yang berisi angka 0.
Jika kita ganti I2 menjadi januari maka formula pada sel B2 menjadi =januari!B1, yang berisi anga 5.Jika dicopy ke bawah maka formula pada sel B3 menjadi =januari!B2, yang berisi angka 6.
S&K susunan (urutan) data pada Sheet januari, februari dan maret harus sama.
Salam,HK

From: "ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 16 February 2017, 4:07
Subject: Re: [belajar-excel] memilih nilai pada sheet tertentu [1 Attachment]

  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 #yiv9195204245 -- #yiv9195204245ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9195204245 #yiv9195204245ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9195204245 #yiv9195204245ygrp-mkp #yiv9195204245hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9195204245 #yiv9195204245ygrp-mkp #yiv9195204245ads {margin-bottom:10px;}#yiv9195204245 #yiv9195204245ygrp-mkp .yiv9195204245ad {padding:0 0;}#yiv9195204245 #yiv9195204245ygrp-mkp .yiv9195204245ad p {margin:0;}#yiv9195204245 #yiv9195204245ygrp-mkp .yiv9195204245ad a {color:#0000ff;text-decoration:none;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ygrp-lc {font-family:Arial;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ygrp-lc #yiv9195204245hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ygrp-lc .yiv9195204245ad {margin-bottom:10px;padding:0 0;}#yiv9195204245 #yiv9195204245actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9195204245 #yiv9195204245activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9195204245 #yiv9195204245activity span {font-weight:700;}#yiv9195204245 #yiv9195204245activity span:first-child {text-transform:uppercase;}#yiv9195204245 #yiv9195204245activity span a {color:#5085b6;text-decoration:none;}#yiv9195204245 #yiv9195204245activity span span {color:#ff7900;}#yiv9195204245 #yiv9195204245activity span .yiv9195204245underline {text-decoration:underline;}#yiv9195204245 .yiv9195204245attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9195204245 .yiv9195204245attach div a {text-decoration:none;}#yiv9195204245 .yiv9195204245attach img {border:none;padding-right:5px;}#yiv9195204245 .yiv9195204245attach label {display:block;margin-bottom:5px;}#yiv9195204245 .yiv9195204245attach label a {text-decoration:none;}#yiv9195204245 blockquote {margin:0 0 0 4px;}#yiv9195204245 .yiv9195204245bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9195204245 .yiv9195204245bold a {text-decoration:none;}#yiv9195204245 dd.yiv9195204245last p a {font-family:Verdana;font-weight:700;}#yiv9195204245 dd.yiv9195204245last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9195204245 dd.yiv9195204245last p span.yiv9195204245yshortcuts {margin-right:0;}#yiv9195204245 div.yiv9195204245attach-table div div a {text-decoration:none;}#yiv9195204245 div.yiv9195204245attach-table {width:400px;}#yiv9195204245 div.yiv9195204245file-title a, #yiv9195204245 div.yiv9195204245file-title a:active, #yiv9195204245 div.yiv9195204245file-title a:hover, #yiv9195204245 div.yiv9195204245file-title a:visited {text-decoration:none;}#yiv9195204245 div.yiv9195204245photo-title a, #yiv9195204245 div.yiv9195204245photo-title a:active, #yiv9195204245 div.yiv9195204245photo-title a:hover, #yiv9195204245 div.yiv9195204245photo-title a:visited {text-decoration:none;}#yiv9195204245 div#yiv9195204245ygrp-mlmsg #yiv9195204245ygrp-msg p a span.yiv9195204245yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9195204245 .yiv9195204245green {color:#628c2a;}#yiv9195204245 .yiv9195204245MsoNormal {margin:0 0 0 0;}#yiv9195204245 o {font-size:0;}#yiv9195204245 #yiv9195204245photos div {float:left;width:72px;}#yiv9195204245 #yiv9195204245photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9195204245 #yiv9195204245photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9195204245 #yiv9195204245reco-category {font-size:77%;}#yiv9195204245 #yiv9195204245reco-desc {font-size:77%;}#yiv9195204245 .yiv9195204245replbq {margin:4px;}#yiv9195204245 #yiv9195204245ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9195204245 #yiv9195204245ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9195204245 #yiv9195204245ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9195204245 #yiv9195204245ygrp-mlmsg select, #yiv9195204245 input, #yiv9195204245 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9195204245 #yiv9195204245ygrp-mlmsg pre, #yiv9195204245 code {font:115% monospace;}#yiv9195204245 #yiv9195204245ygrp-mlmsg * {line-height:1.22em;}#yiv9195204245 #yiv9195204245ygrp-mlmsg #yiv9195204245logo {padding-bottom:10px;}#yiv9195204245 #yiv9195204245ygrp-msg p a {font-family:Verdana;}#yiv9195204245 #yiv9195204245ygrp-msg p#yiv9195204245attach-count span {color:#1E66AE;font-weight:700;}#yiv9195204245 #yiv9195204245ygrp-reco #yiv9195204245reco-head {color:#ff7900;font-weight:700;}#yiv9195204245 #yiv9195204245ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ov li a {font-size:130%;text-decoration:none;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9195204245 #yiv9195204245ygrp-sponsor #yiv9195204245ov ul {margin:0;padding:0 0 0 8px;}#yiv9195204245 #yiv9195204245ygrp-text {font-family:Georgia;}#yiv9195204245 #yiv9195204245ygrp-text p {margin:0 0 1em 0;}#yiv9195204245 #yiv9195204245ygrp-text tt {font-size:120%;}#yiv9195204245 #yiv9195204245ygrp-vital ul li:last-child {border-right:none !important;}#yiv9195204245

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

• Privacy • Unsubscribe • Terms of Use