Kamis, 21 Mei 2015

[belajar-excel] Digest Number 3437

10 Messages

Digest #3437
3a
Dropdown ComboBox by "It Dpm" it_dpm
3b
Re: Dropdown ComboBox [1 Attachment] by "hendrik karnadi" hendrikkarnadi
4a
Angka terakhir by "sh.Ronald" sh.ronald
4c
Re: Angka terakhir [1 Attachment] by "zainul_ulum[at]yahoo[dot]com" zainul_ulum
4e
Fw: [belajar-excel] Angka terakhir by "hendrik karnadi" hendrikkarnadi

Messages

Wed May 20, 2015 2:55 am (PDT) . Posted by:

"Salim Jenggot"

Dear Master2 Excel,

mohon dibantu, saya memiliki data yg saya download dari system.
data tersebut akan saya lengkapi (kolom berwarna kuning dan biru) seperti
contoh terlampir.

kolom berwarna kuning otomatis terisi dengan Nopol yg sama dalam setiap
paragrafnya.

kolom biru otomatis terisi dgn pekerjaan yg sama dalam setiap paragrafnya.

mohon suggestnya, terima kasih,

Salim Jenggot

Wed May 20, 2015 2:56 am (PDT) . Posted by:

"Subroto, Matzen"

Dear Pak Kusnadi

VB nya sangat membantu file saya, tapi kalau filternya tanpa harus di klick Button Filter gimana tuh, jadi ketika ketik di cell filte secara Auto langsung terfilter


Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan


Terima Kasih

Matzen



From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 19 Mei 2015 15:30
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] selain Pivot Table, adakah formulanya [1 Attachment]


Dear Pak Kusnadi,

Berikut saya berikan contoh dengan menggunakan Formula Excel dan menggunakan VBA.

TerimaKasih.


Pada Selasa, 19 Mei 2015 14:59, "'Mr. Kid' mr.nmkid@gmail.com<mailto:mr.nmkid@gmail.com> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>> menulis:


Ikutan ah....
File terlampir menggunakan array formula filtering. Bisa juga dengan array formula unique values. Andai dibuatkan sebuah kolom komposit yang menjadi kriteria pencarian, maka formula hasil tak perlu berupa array formula.

Wassalam,
Kid


2015-05-19 16:40 GMT+10:00 Kusnadi Bin zain kbinzain@yahoo.co.id<mailto:kbinzain@yahoo.co.id> [belajar-excel] <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>:

Dear : para exceller

Terlampir ada pertanyaan dari anak saya, yg blm bsa saya jwab dg memuaskan
Saya sarankan untuk mudahnya memakai Pivot Table, tapi dia penasaran kalau pake rumus/formula seperti apa baiknya .... begitu.

terima kasih sebelumnya

Wassalam


kusnadi





__________________________________________________________
This email has been scanned for Viruses and Spam. For more information
please contact your local Business Unit Information Security representative.
__________________________________________________________

Wed May 20, 2015 9:32 pm (PDT) . Posted by:

"It Dpm" it_dpm

Dear master,
saya ada kesulitan nih, bagaimana supaya tampilan di dropdown combobox pada tombol [LIHAT COMBOBOX] (contoh file terlampir) tidak muncul data yang duplikat dan jika ada nilai 0 tidak ditampilkan Terima kasih banyak atas bantuannya.




Thu May 21, 2015 12:10 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Kalau datanya tidak mau duplikat maka harus dibuat data collection (data penampung) lebih dahulu baru ditranspose. Data penampung ini bisa dibuat untuk tidak memasukkan data yang nilainya 0 ke dalam list.
Karena datanya tidak ada yang double maka untuk mengabaikan nilai o (nol) mungkin perlu ada sedikit perubahan code berikut ini:
Dari...Private Sub UserForm_Initialize()Set datane = Sheets("dbase")Set DinamisC = datane.Range("A3", Sheets("dbase").Range("A4").End(xlDown))ComboBox1.ClearFor Each sDATANE In DinamisCWith Me.ComboBox1.AddItem sDATANE.Value
.List(.ListCount - 1, 1) = sDATANE.Offset(0, 2).Value
End WithNext sDATANEComboBox1.Value = ComboBox1.List(0)ComboBox1.Value = ""
Menjadi:Private Sub UserForm_Initialize()Set datane = Sheets("dbase")Set DinamisC = datane.Range("A2", Sheets("dbase").Range("A2").End(xlDown))ComboBox1.ClearFor Each sDATANE In DinamisCWith Me.ComboBox1If sDATANE <> 0 Then.AddItem sDATANE.ValueEnd If.List(.ListCount - 1, 1) = sDATANE.Offset(0, 2).ValueEnd WithNext sDATANEComboBox1.Value = ComboBox1.List(0)ComboBox1.Value = ""
A3 dan A4 dikoreksi menjadi A2 agar data yag ada pada A2 ikut masuk dalm list.
Semoga sesuai keinginan.
Salam,HK
From: "It Dpm it_dpm@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 21 May 2015, 11:20
Subject: [belajar-excel] Dropdown ComboBox [1 Attachment]

  Dear master,
saya ada kesulitan nih, bagaimana supaya tampilan di dropdown combobox pada tombol [LIHAT COMBOBOX] (contoh file terlampir) tidak muncul data yang duplikat dan jika ada nilai 0 tidak ditampilkan Terima kasih banyak atas bantuannya.  
#yiv3970551709 #yiv3970551709 -- #yiv3970551709ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3970551709 #yiv3970551709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3970551709 #yiv3970551709ygrp-mkp #yiv3970551709hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3970551709 #yiv3970551709ygrp-mkp #yiv3970551709ads {margin-bottom:10px;}#yiv3970551709 #yiv3970551709ygrp-mkp .yiv3970551709ad {padding:0 0;}#yiv3970551709 #yiv3970551709ygrp-mkp .yiv3970551709ad p {margin:0;}#yiv3970551709 #yiv3970551709ygrp-mkp .yiv3970551709ad a {color:#0000ff;text-decoration:none;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ygrp-lc {font-family:Arial;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ygrp-lc #yiv3970551709hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ygrp-lc .yiv3970551709ad {margin-bottom:10px;padding:0 0;}#yiv3970551709 #yiv3970551709actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3970551709 #yiv3970551709activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3970551709 #yiv3970551709activity span {font-weight:700;}#yiv3970551709 #yiv3970551709activity span:first-child {text-transform:uppercase;}#yiv3970551709 #yiv3970551709activity span a {color:#5085b6;text-decoration:none;}#yiv3970551709 #yiv3970551709activity span span {color:#ff7900;}#yiv3970551709 #yiv3970551709activity span .yiv3970551709underline {text-decoration:underline;}#yiv3970551709 .yiv3970551709attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3970551709 .yiv3970551709attach div a {text-decoration:none;}#yiv3970551709 .yiv3970551709attach img {border:none;padding-right:5px;}#yiv3970551709 .yiv3970551709attach label {display:block;margin-bottom:5px;}#yiv3970551709 .yiv3970551709attach label a {text-decoration:none;}#yiv3970551709 blockquote {margin:0 0 0 4px;}#yiv3970551709 .yiv3970551709bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3970551709 .yiv3970551709bold a {text-decoration:none;}#yiv3970551709 dd.yiv3970551709last p a {font-family:Verdana;font-weight:700;}#yiv3970551709 dd.yiv3970551709last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3970551709 dd.yiv3970551709last p span.yiv3970551709yshortcuts {margin-right:0;}#yiv3970551709 div.yiv3970551709attach-table div div a {text-decoration:none;}#yiv3970551709 div.yiv3970551709attach-table {width:400px;}#yiv3970551709 div.yiv3970551709file-title a, #yiv3970551709 div.yiv3970551709file-title a:active, #yiv3970551709 div.yiv3970551709file-title a:hover, #yiv3970551709 div.yiv3970551709file-title a:visited {text-decoration:none;}#yiv3970551709 div.yiv3970551709photo-title a, #yiv3970551709 div.yiv3970551709photo-title a:active, #yiv3970551709 div.yiv3970551709photo-title a:hover, #yiv3970551709 div.yiv3970551709photo-title a:visited {text-decoration:none;}#yiv3970551709 div#yiv3970551709ygrp-mlmsg #yiv3970551709ygrp-msg p a span.yiv3970551709yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3970551709 .yiv3970551709green {color:#628c2a;}#yiv3970551709 .yiv3970551709MsoNormal {margin:0 0 0 0;}#yiv3970551709 o {font-size:0;}#yiv3970551709 #yiv3970551709photos div {float:left;width:72px;}#yiv3970551709 #yiv3970551709photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3970551709 #yiv3970551709photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3970551709 #yiv3970551709reco-category {font-size:77%;}#yiv3970551709 #yiv3970551709reco-desc {font-size:77%;}#yiv3970551709 .yiv3970551709replbq {margin:4px;}#yiv3970551709 #yiv3970551709ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3970551709 #yiv3970551709ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3970551709 #yiv3970551709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3970551709 #yiv3970551709ygrp-mlmsg select, #yiv3970551709 input, #yiv3970551709 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3970551709 #yiv3970551709ygrp-mlmsg pre, #yiv3970551709 code {font:115% monospace;}#yiv3970551709 #yiv3970551709ygrp-mlmsg * {line-height:1.22em;}#yiv3970551709 #yiv3970551709ygrp-mlmsg #yiv3970551709logo {padding-bottom:10px;}#yiv3970551709 #yiv3970551709ygrp-msg p a {font-family:Verdana;}#yiv3970551709 #yiv3970551709ygrp-msg p#yiv3970551709attach-count span {color:#1E66AE;font-weight:700;}#yiv3970551709 #yiv3970551709ygrp-reco #yiv3970551709reco-head {color:#ff7900;font-weight:700;}#yiv3970551709 #yiv3970551709ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ov li a {font-size:130%;text-decoration:none;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3970551709 #yiv3970551709ygrp-sponsor #yiv3970551709ov ul {margin:0;padding:0 0 0 8px;}#yiv3970551709 #yiv3970551709ygrp-text {font-family:Georgia;}#yiv3970551709 #yiv3970551709ygrp-text p {margin:0 0 1em 0;}#yiv3970551709 #yiv3970551709ygrp-text tt {font-size:120%;}#yiv3970551709 #yiv3970551709ygrp-vital ul li:last-child {border-right:none !important;}#yiv3970551709

Thu May 21, 2015 2:02 am (PDT) . Posted by:

it_dpm

Terima kasih master HK atas petunjuknya...dan ternyata datanya sudah saya antisipasi supaya tidak duplikat kecuali 0 (nol).

Thu May 21, 2015 2:02 am (PDT) . Posted by:

"sh.Ronald" sh.ronald

Selamat sore pada pecinta Excel, mohon dibantu untuk mencari angka terakhir dari suatu kolom excel.Contoh dari masalah saya saya lampirkan disini.
Terima kasih,
/shr

Thu May 21, 2015 2:16 am (PDT) . Posted by:

"Bagus"

Hai ronald;

Coba begini:
=INDEX(B5:B13,COUNT(B5:B13),0)

copas kekanan

Wassalam
Bagus

Pada 21 Mei 2015 15.57, 'sh.Ronald' sh.ronald@yahoo.co.id [belajar-excel] <
belajar-excel@yahoogroups.com> menulis:

>
>
> Selamat sore pada pecinta Excel, mohon dibantu untuk mencari angka
> terakhir dari suatu kolom excel.
> Contoh dari masalah saya saya lampirkan disini.
>
> Terima kasih,
>
> /shr
>
>
>

Thu May 21, 2015 2:18 am (PDT) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

B14=LOOKUP(9^9,B4:B12,B4:B12)

kemudian copy ke kanan rumus di B14

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, May 21, 2015 3:57 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Angka terakhir [1 Attachment]

Selamat sore pada pecinta Excel, mohon dibantu untuk mencari angka terakhir dari suatu kolom excel.

Contoh dari masalah saya saya lampirkan disini.

Terima kasih,

/shr

Thu May 21, 2015 2:31 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Ronald, Coba pake: =VLOOKUP(10^10,D1:D30,1) untuk yang ada di column D, untuk di column yang lain tinggal di sesuaikan aja. TerimaKasih, 

Pada Kamis, 21 Mei 2015 15:57, "'sh.Ronald' sh.ronald@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Selamat sore pada pecinta Excel, mohon dibantu untuk mencari angka terakhir dari suatu kolom excel.Contoh dari masalah saya saya lampirkan disini.
Terima kasih,
/shr #yiv7402869068 #yiv7402869068 -- #yiv7402869068ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7402869068 #yiv7402869068ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7402869068 #yiv7402869068ygrp-mkp #yiv7402869068hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7402869068 #yiv7402869068ygrp-mkp #yiv7402869068ads {margin-bottom:10px;}#yiv7402869068 #yiv7402869068ygrp-mkp .yiv7402869068ad {padding:0 0;}#yiv7402869068 #yiv7402869068ygrp-mkp .yiv7402869068ad p {margin:0;}#yiv7402869068 #yiv7402869068ygrp-mkp .yiv7402869068ad a {color:#0000ff;text-decoration:none;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ygrp-lc {font-family:Arial;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ygrp-lc #yiv7402869068hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ygrp-lc .yiv7402869068ad {margin-bottom:10px;padding:0 0;}#yiv7402869068 #yiv7402869068actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7402869068 #yiv7402869068activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7402869068 #yiv7402869068activity span {font-weight:700;}#yiv7402869068 #yiv7402869068activity span:first-child {text-transform:uppercase;}#yiv7402869068 #yiv7402869068activity span a {color:#5085b6;text-decoration:none;}#yiv7402869068 #yiv7402869068activity span span {color:#ff7900;}#yiv7402869068 #yiv7402869068activity span .yiv7402869068underline {text-decoration:underline;}#yiv7402869068 .yiv7402869068attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7402869068 .yiv7402869068attach div a {text-decoration:none;}#yiv7402869068 .yiv7402869068attach img {border:none;padding-right:5px;}#yiv7402869068 .yiv7402869068attach label {display:block;margin-bottom:5px;}#yiv7402869068 .yiv7402869068attach label a {text-decoration:none;}#yiv7402869068 blockquote {margin:0 0 0 4px;}#yiv7402869068 .yiv7402869068bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7402869068 .yiv7402869068bold a {text-decoration:none;}#yiv7402869068 dd.yiv7402869068last p a {font-family:Verdana;font-weight:700;}#yiv7402869068 dd.yiv7402869068last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7402869068 dd.yiv7402869068last p span.yiv7402869068yshortcuts {margin-right:0;}#yiv7402869068 div.yiv7402869068attach-table div div a {text-decoration:none;}#yiv7402869068 div.yiv7402869068attach-table {width:400px;}#yiv7402869068 div.yiv7402869068file-title a, #yiv7402869068 div.yiv7402869068file-title a:active, #yiv7402869068 div.yiv7402869068file-title a:hover, #yiv7402869068 div.yiv7402869068file-title a:visited {text-decoration:none;}#yiv7402869068 div.yiv7402869068photo-title a, #yiv7402869068 div.yiv7402869068photo-title a:active, #yiv7402869068 div.yiv7402869068photo-title a:hover, #yiv7402869068 div.yiv7402869068photo-title a:visited {text-decoration:none;}#yiv7402869068 div#yiv7402869068ygrp-mlmsg #yiv7402869068ygrp-msg p a span.yiv7402869068yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7402869068 .yiv7402869068green {color:#628c2a;}#yiv7402869068 .yiv7402869068MsoNormal {margin:0 0 0 0;}#yiv7402869068 o {font-size:0;}#yiv7402869068 #yiv7402869068photos div {float:left;width:72px;}#yiv7402869068 #yiv7402869068photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7402869068 #yiv7402869068photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7402869068 #yiv7402869068reco-category {font-size:77%;}#yiv7402869068 #yiv7402869068reco-desc {font-size:77%;}#yiv7402869068 .yiv7402869068replbq {margin:4px;}#yiv7402869068 #yiv7402869068ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7402869068 #yiv7402869068ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7402869068 #yiv7402869068ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7402869068 #yiv7402869068ygrp-mlmsg select, #yiv7402869068 input, #yiv7402869068 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7402869068 #yiv7402869068ygrp-mlmsg pre, #yiv7402869068 code {font:115% monospace;}#yiv7402869068 #yiv7402869068ygrp-mlmsg * {line-height:1.22em;}#yiv7402869068 #yiv7402869068ygrp-mlmsg #yiv7402869068logo {padding-bottom:10px;}#yiv7402869068 #yiv7402869068ygrp-msg p a {font-family:Verdana;}#yiv7402869068 #yiv7402869068ygrp-msg p#yiv7402869068attach-count span {color:#1E66AE;font-weight:700;}#yiv7402869068 #yiv7402869068ygrp-reco #yiv7402869068reco-head {color:#ff7900;font-weight:700;}#yiv7402869068 #yiv7402869068ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ov li a {font-size:130%;text-decoration:none;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7402869068 #yiv7402869068ygrp-sponsor #yiv7402869068ov ul {margin:0;padding:0 0 0 8px;}#yiv7402869068 #yiv7402869068ygrp-text {font-family:Georgia;}#yiv7402869068 #yiv7402869068ygrp-text p {margin:0 0 1em 0;}#yiv7402869068 #yiv7402869068ygrp-text tt {font-size:120%;}#yiv7402869068 #yiv7402869068ygrp-vital ul li:last-child {border-right:none !important;}#yiv7402869068

Thu May 21, 2015 2:36 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Ini forward dari jawaban sebelumnya (kalu ndak salah dari Mr. Kid),Untuk data yang berisi angka: =LOOKUP(9^9,Rangenya)Untuk data yang berisi huruf : =LOOKUP("zz",Rangenya)
File terlampir.
Salam,HK

----- Forwarded Message -----
From: "'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 21 May 2015, 16:17
Subject: RE: [belajar-excel] Angka terakhir

  B14=LOOKUP(9^9,B4:B12,B4:B12)kemudian copy ke kanan rumus di B14  From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, May 21, 2015 3:57 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Angka terakhir [1 Attachment]    Selamat sore pada pecinta Excel, mohon dibantu untuk mencari angka terakhir dari suatu kolom excel.Contoh dari masalah saya saya lampirkan disini.  Terima kasih,  /shr #yiv0955695227 -- #yiv0955695227ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0955695227 #yiv0955695227ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0955695227 #yiv0955695227ygrp-mkp #yiv0955695227hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0955695227 #yiv0955695227ygrp-mkp #yiv0955695227ads {margin-bottom:10px;}#yiv0955695227 #yiv0955695227ygrp-mkp .yiv0955695227ad {padding:0 0;}#yiv0955695227 #yiv0955695227ygrp-mkp .yiv0955695227ad p {margin:0;}#yiv0955695227 #yiv0955695227ygrp-mkp .yiv0955695227ad a {color:#0000ff;text-decoration:none;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ygrp-lc {font-family:Arial;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ygrp-lc #yiv0955695227hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ygrp-lc .yiv0955695227ad {margin-bottom:10px;padding:0 0;}#yiv0955695227 #yiv0955695227actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0955695227 #yiv0955695227activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0955695227 #yiv0955695227activity span {font-weight:700;}#yiv0955695227 #yiv0955695227activity span:first-child {text-transform:uppercase;}#yiv0955695227 #yiv0955695227activity span a {color:#5085b6;text-decoration:none;}#yiv0955695227 #yiv0955695227activity span span {color:#ff7900;}#yiv0955695227 #yiv0955695227activity span .yiv0955695227underline {text-decoration:underline;}#yiv0955695227 .yiv0955695227attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0955695227 .yiv0955695227attach div a {text-decoration:none;}#yiv0955695227 .yiv0955695227attach img {border:none;padding-right:5px;}#yiv0955695227 .yiv0955695227attach label {display:block;margin-bottom:5px;}#yiv0955695227 .yiv0955695227attach label a {text-decoration:none;}#yiv0955695227 blockquote {margin:0 0 0 4px;}#yiv0955695227 .yiv0955695227bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0955695227 .yiv0955695227bold a {text-decoration:none;}#yiv0955695227 dd.yiv0955695227last p a {font-family:Verdana;font-weight:700;}#yiv0955695227 dd.yiv0955695227last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0955695227 dd.yiv0955695227last p span.yiv0955695227yshortcuts {margin-right:0;}#yiv0955695227 div.yiv0955695227attach-table div div a {text-decoration:none;}#yiv0955695227 div.yiv0955695227attach-table {width:400px;}#yiv0955695227 div.yiv0955695227file-title a, #yiv0955695227 div.yiv0955695227file-title a:active, #yiv0955695227 div.yiv0955695227file-title a:hover, #yiv0955695227 div.yiv0955695227file-title a:visited {text-decoration:none;}#yiv0955695227 div.yiv0955695227photo-title a, #yiv0955695227 div.yiv0955695227photo-title a:active, #yiv0955695227 div.yiv0955695227photo-title a:hover, #yiv0955695227 div.yiv0955695227photo-title a:visited {text-decoration:none;}#yiv0955695227 div#yiv0955695227ygrp-mlmsg #yiv0955695227ygrp-msg p a span.yiv0955695227yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0955695227 .yiv0955695227green {color:#628c2a;}#yiv0955695227 .yiv0955695227MsoNormal {margin:0 0 0 0;}#yiv0955695227 o {font-size:0;}#yiv0955695227 #yiv0955695227photos div {float:left;width:72px;}#yiv0955695227 #yiv0955695227photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0955695227 #yiv0955695227photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0955695227 #yiv0955695227reco-category {font-size:77%;}#yiv0955695227 #yiv0955695227reco-desc {font-size:77%;}#yiv0955695227 .yiv0955695227replbq {margin:4px;}#yiv0955695227 #yiv0955695227ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0955695227 #yiv0955695227ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0955695227 #yiv0955695227ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0955695227 #yiv0955695227ygrp-mlmsg select, #yiv0955695227 input, #yiv0955695227 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0955695227 #yiv0955695227ygrp-mlmsg pre, #yiv0955695227 code {font:115% monospace;}#yiv0955695227 #yiv0955695227ygrp-mlmsg * {line-height:1.22em;}#yiv0955695227 #yiv0955695227ygrp-mlmsg #yiv0955695227logo {padding-bottom:10px;}#yiv0955695227 #yiv0955695227ygrp-msg p a {font-family:Verdana;}#yiv0955695227 #yiv0955695227ygrp-msg p#yiv0955695227attach-count span {color:#1E66AE;font-weight:700;}#yiv0955695227 #yiv0955695227ygrp-reco #yiv0955695227reco-head {color:#ff7900;font-weight:700;}#yiv0955695227 #yiv0955695227ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ov li a {font-size:130%;text-decoration:none;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0955695227 #yiv0955695227ygrp-sponsor #yiv0955695227ov ul {margin:0;padding:0 0 0 8px;}#yiv0955695227 #yiv0955695227ygrp-text {font-family:Georgia;}#yiv0955695227 #yiv0955695227ygrp-text p {margin:0 0 1em 0;}#yiv0955695227 #yiv0955695227ygrp-text tt {font-size:120%;}#yiv0955695227 #yiv0955695227ygrp-vital ul li:last-child {border-right:none !important;}#yiv0955695227

============================================================
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
---------------------------------------------------------------------
Diposting oleh EXCEL FEED LEARNING di 02.49

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)