Kamis, 31 Oktober 2019

[belajar-excel] Digest Number 4893

1 Message

Digest #4893
1a
Re: Mencari Nilai dengan Kriteria Khusus by "Mr. Kid" nmkid.family@ymail.com

Message

Thu Oct 31, 2019 11:09 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Di Excel 2016 ke atas, powerquery sudah include (langsung ter-install) saat
install ms office.
Di Excel 2010 dan Excel 2013, powerquery perlu meng-install addin (free
dari microsoft), minimal versi 2.62xxx.
Saya rasa, daripada admin komouter kantor menginstall add in solver dan
sebagainya bisa, berarti sewajarnya menginstall powerquery pun diijinkan
tanpa perlu banyak alasan.

On Wed, Oct 30, 2019 at 11:55 PM Kamirin Faqoth kamirin_2@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> Dear Mr Kid,
>
> Terima kasih atas atas petunjuknya, tapi sepertinya saya belum bisa
> mengaplikasikan power query dikarenakan PC yang saya gunakan adalah PC
> Client, jadi kalau install Add Ins harus dari servernya, makanya saya lebih
> nyaman menggunakan mega formula aja untuk saat ini
>
> Salam,
> Kamirin
>
> Pada Senin, 28 Oktober 2019 20.20.44 WIB, 'Mr. Kid' mr.nmkid@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Coba unduh materi kopdar 3, bisa disini :
>
> https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
> atau disini :
>
> https://drive.google.com/file/d/1oXf4cE8CzZhqvEJE-_dvvbMUtTFYrctT/view?usp=sharing
> atau di folder files milis di gdrive berikut :
>
> https://drive.google.com/drive/folders/1JoNf0qm5xgXDsRDaI3I85r_YZOAsiEoO?usp=sharing
> ke folder materi kopdar, unduh file kopdar_03
>
>
>
>
>
> On Sat, Oct 26, 2019 at 7:10 PM Kamirin Faqoth kamirin_2@yahoo.co.id
> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Dear Pa Iqbal,
>
>
> Maaf, bisa dijelaskan tentang apa itu Power Query & step by stepnya dari
> kasus saya bagaimana yaa pengerjaannya?
>
> Maaf, Saya masih awam tentang power query?
>
>
> Terima Kasih
>
> Pada Rabu, 23 Oktober 2019 04.06.57 WIB, iq_bal76id@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
>
>
>
> Hi Kamirin,
>
> Bisa di gunakan power query
>
>
>
>
>
> Thanks
>
> Best Regards
>
> Muhammad Iqbal
>
> +62890909010/0811101854
>
>
>
>
>
>
>
> *From:* belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
> *Sent:* Tuesday, October 22, 2019 3:50 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* [belajar-excel] Mencari Nilai dengan Kriteria Khusus [1
> Attachment]
>
>
>
>
>
> Dear All Member,
>
>
>
> Mohon bantuannya, saya agak kesulitan mencari nilai dengan kriteria khusus
> pada tabel data yang sifatnya statis, dengan acuan tabel yang saya tandain
> warna kuning dan
>
> dengan mengabaikan tabel yang tandain warna merah, Berikut Contoh Potongan
> File terlampir, terdiri dari 20 baris, file aslinya lebih dari 1000 baris.
>
>
>
> Terim Kasih,
>
> Kamirin
>
>
>
============================================================
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
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 22.44 0 komentar

[smf_addin] Digest Number 4639

2 Messages

Digest #4639
1a
Re: RCHCreateComment by sdkli6s74riwydpnmq2gtjfye62jlz2eu35n4ipf
1b
Re: RCHCreateComment by "Randy Harmelink" rharmelink

Messages

Wed Oct 30, 2019 6:43 am (PDT) . Posted by:

sdkli6s74riwydpnmq2gtjfye62jlz2eu35n4ipf

I've received the "#VALUE" error for each of the following along with a comment insert that is a standard excel comment box containing only my username

=rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart") where $B$6 is the ticker SPY



rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart&quot;)



rchcreatecomment("SPY",99,550,450,1,1,1,1,"","Chart")



Before Monday of this week, I had been using this same sheet for more than 3 years without any issues. I am using the latest version of the plugin as well.

Wed Oct 30, 2019 2:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You last one won't work, because you're giving it a ticker symbol instead
of a URL. The other two are working fine for me right now.

However, when I first tried this link in my browser:

https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473

....I got a message about not having authority to access that chart. But
every access after that first try is working fine. So maybe you're running
into some version of that security check? Try the above link in the IE
object of EXCEL and see if it shows you the chart. If you do get a chart,
try doing RCHCreateComment() with that URL again and see if it works.

I'm not sure how their chart security is working, but once I tried it,
every instance after that appears to be working fine? But I'm not sure
what's going on... :(

On Wed, Oct 30, 2019 at 1:40 PM nate.propes@... wrote:

>
> I've received the "#VALUE" error for each of the following along with a
> comment insert that is a standard excel comment box containing only my
> username
>
> =rchcreatecomment("https://c.stockcharts.com/c-sc/sc?s="&$B$6&"&p=D&b=5&g=0&i=0&r=1546444207473",99,550,450,1,1,1,1,"","Chart")
> where $B$6 is the ticker SPY
>
> rchcreatecomment("
> https://c.stockcharts.com/c-sc/sc?s=SPY&p=D&b=5&g=0&i=0&r=1546444207473
> ",99,550,450,1,1,1,1,"","Chart&quot;)
>
> rchcreatecomment("SPY",99,550,450,1,1,1,1,"","Chart")
>
> Before Monday of this week, I had been using this same sheet for more than
> 3 years without any issues. I am using the latest version of the plugin as
> well.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.51 0 komentar

Rabu, 30 Oktober 2019

[belajar-excel] Digest Number 4892

9 Messages

Digest #4892
1a
Hitung Bonus Tambahan untuk Petugas Kring by "Edhie Wibowo" edhiewibowo
1c
Re: Hitung Bonus Tambahan untuk Petugas Kring by "ghozi alkatiri" ghozialkatiri
1d
Re: Hitung Bonus Tambahan untuk Petugas Kring by "ghozi alkatiri" ghozialkatiri
1e
1f
1g
2a
Re: Mencari Nilai dengan Kriteria Khusus by "Kamirin Faqoth" kamirin_2

Messages

Tue Oct 29, 2019 11:17 pm (PDT) . Posted by:

"Edhie Wibowo" edhiewibowo

Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

Wed Oct 30, 2019 1:38 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))

wassalam 
Ghozi Alkatiri Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo edhiewibowo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

#yiv7265349575 #yiv7265349575 -- #yiv7265349575ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7265349575 #yiv7265349575ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7265349575 #yiv7265349575ygrp-mkp #yiv7265349575hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7265349575 #yiv7265349575ygrp-mkp #yiv7265349575ads {margin-bottom:10px;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad {padding:0 0;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad p {margin:0;}#yiv7265349575 #yiv7265349575ygrp-mkp .yiv7265349575ad a {color:#0000ff;text-decoration:none;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc {font-family:Arial;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc #yiv7265349575hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ygrp-lc .yiv7265349575ad {margin-bottom:10px;padding:0 0;}#yiv7265349575 #yiv7265349575actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7265349575 #yiv7265349575activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7265349575 #yiv7265349575activity span {font-weight:700;}#yiv7265349575 #yiv7265349575activity span:first-child {text-transform:uppercase;}#yiv7265349575 #yiv7265349575activity span a {color:#5085b6;text-decoration:none;}#yiv7265349575 #yiv7265349575activity span span {color:#ff7900;}#yiv7265349575 #yiv7265349575activity span .yiv7265349575underline {text-decoration:underline;}#yiv7265349575 .yiv7265349575attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7265349575 .yiv7265349575attach div a {text-decoration:none;}#yiv7265349575 .yiv7265349575attach img {border:none;padding-right:5px;}#yiv7265349575 .yiv7265349575attach label {display:block;margin-bottom:5px;}#yiv7265349575 .yiv7265349575attach label a {text-decoration:none;}#yiv7265349575 blockquote {margin:0 0 0 4px;}#yiv7265349575 .yiv7265349575bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7265349575 .yiv7265349575bold a {text-decoration:none;}#yiv7265349575 dd.yiv7265349575last p a {font-family:Verdana;font-weight:700;}#yiv7265349575 dd.yiv7265349575last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7265349575 dd.yiv7265349575last p span.yiv7265349575yshortcuts {margin-right:0;}#yiv7265349575 div.yiv7265349575attach-table div div a {text-decoration:none;}#yiv7265349575 div.yiv7265349575attach-table {width:400px;}#yiv7265349575 div.yiv7265349575file-title a, #yiv7265349575 div.yiv7265349575file-title a:active, #yiv7265349575 div.yiv7265349575file-title a:hover, #yiv7265349575 div.yiv7265349575file-title a:visited {text-decoration:none;}#yiv7265349575 div.yiv7265349575photo-title a, #yiv7265349575 div.yiv7265349575photo-title a:active, #yiv7265349575 div.yiv7265349575photo-title a:hover, #yiv7265349575 div.yiv7265349575photo-title a:visited {text-decoration:none;}#yiv7265349575 div#yiv7265349575ygrp-mlmsg #yiv7265349575ygrp-msg p a span.yiv7265349575yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7265349575 .yiv7265349575green {color:#628c2a;}#yiv7265349575 .yiv7265349575MsoNormal {margin:0 0 0 0;}#yiv7265349575 o {font-size:0;}#yiv7265349575 #yiv7265349575photos div {float:left;width:72px;}#yiv7265349575 #yiv7265349575photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7265349575 #yiv7265349575photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7265349575 #yiv7265349575reco-category {font-size:77%;}#yiv7265349575 #yiv7265349575reco-desc {font-size:77%;}#yiv7265349575 .yiv7265349575replbq {margin:4px;}#yiv7265349575 #yiv7265349575ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7265349575 #yiv7265349575ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7265349575 #yiv7265349575ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7265349575 #yiv7265349575ygrp-mlmsg select, #yiv7265349575 input, #yiv7265349575 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7265349575 #yiv7265349575ygrp-mlmsg pre, #yiv7265349575 code {font:115% monospace;}#yiv7265349575 #yiv7265349575ygrp-mlmsg * {line-height:1.22em;}#yiv7265349575 #yiv7265349575ygrp-mlmsg #yiv7265349575logo {padding-bottom:10px;}#yiv7265349575 #yiv7265349575ygrp-msg p a {font-family:Verdana;}#yiv7265349575 #yiv7265349575ygrp-msg p#yiv7265349575attach-count span {color:#1E66AE;font-weight:700;}#yiv7265349575 #yiv7265349575ygrp-reco #yiv7265349575reco-head {color:#ff7900;font-weight:700;}#yiv7265349575 #yiv7265349575ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov li a {font-size:130%;text-decoration:none;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7265349575 #yiv7265349575ygrp-sponsor #yiv7265349575ov ul {margin:0;padding:0 0 0 8px;}#yiv7265349575 #yiv7265349575ygrp-text {font-family:Georgia;}#yiv7265349575 #yiv7265349575ygrp-text p {margin:0 0 1em 0;}#yiv7265349575 #yiv7265349575ygrp-text tt {font-size:120%;}#yiv7265349575 #yiv7265349575ygrp-vital ul li:last-child {border-right:none !important;}#yiv7265349575

Wed Oct 30, 2019 3:22 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

sory yang benar adalah:
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))

Ghozi Alkatiri
Pada Kamis, 31 Oktober 2019 03.38.50 WIB, ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))

wassalam 
Ghozi Alkatiri Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo edhiewibowo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

#yiv2318001825 #yiv2318001825 -- #yiv2318001825ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2318001825 #yiv2318001825ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2318001825 #yiv2318001825ygrp-mkp #yiv2318001825hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2318001825 #yiv2318001825ygrp-mkp #yiv2318001825ads {margin-bottom:10px;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad {padding:0 0;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad p {margin:0;}#yiv2318001825 #yiv2318001825ygrp-mkp .yiv2318001825ad a {color:#0000ff;text-decoration:none;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc {font-family:Arial;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc #yiv2318001825hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ygrp-lc .yiv2318001825ad {margin-bottom:10px;padding:0 0;}#yiv2318001825 #yiv2318001825actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2318001825 #yiv2318001825activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2318001825 #yiv2318001825activity span {font-weight:700;}#yiv2318001825 #yiv2318001825activity span:first-child {text-transform:uppercase;}#yiv2318001825 #yiv2318001825activity span a {color:#5085b6;text-decoration:none;}#yiv2318001825 #yiv2318001825activity span span {color:#ff7900;}#yiv2318001825 #yiv2318001825activity span .yiv2318001825underline {text-decoration:underline;}#yiv2318001825 .yiv2318001825attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2318001825 .yiv2318001825attach div a {text-decoration:none;}#yiv2318001825 .yiv2318001825attach img {border:none;padding-right:5px;}#yiv2318001825 .yiv2318001825attach label {display:block;margin-bottom:5px;}#yiv2318001825 .yiv2318001825attach label a {text-decoration:none;}#yiv2318001825 blockquote {margin:0 0 0 4px;}#yiv2318001825 .yiv2318001825bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2318001825 .yiv2318001825bold a {text-decoration:none;}#yiv2318001825 dd.yiv2318001825last p a {font-family:Verdana;font-weight:700;}#yiv2318001825 dd.yiv2318001825last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2318001825 dd.yiv2318001825last p span.yiv2318001825yshortcuts {margin-right:0;}#yiv2318001825 div.yiv2318001825attach-table div div a {text-decoration:none;}#yiv2318001825 div.yiv2318001825attach-table {width:400px;}#yiv2318001825 div.yiv2318001825file-title a, #yiv2318001825 div.yiv2318001825file-title a:active, #yiv2318001825 div.yiv2318001825file-title a:hover, #yiv2318001825 div.yiv2318001825file-title a:visited {text-decoration:none;}#yiv2318001825 div.yiv2318001825photo-title a, #yiv2318001825 div.yiv2318001825photo-title a:active, #yiv2318001825 div.yiv2318001825photo-title a:hover, #yiv2318001825 div.yiv2318001825photo-title a:visited {text-decoration:none;}#yiv2318001825 div#yiv2318001825ygrp-mlmsg #yiv2318001825ygrp-msg p a span.yiv2318001825yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2318001825 .yiv2318001825green {color:#628c2a;}#yiv2318001825 .yiv2318001825MsoNormal {margin:0 0 0 0;}#yiv2318001825 o {font-size:0;}#yiv2318001825 #yiv2318001825photos div {float:left;width:72px;}#yiv2318001825 #yiv2318001825photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2318001825 #yiv2318001825photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2318001825 #yiv2318001825reco-category {font-size:77%;}#yiv2318001825 #yiv2318001825reco-desc {font-size:77%;}#yiv2318001825 .yiv2318001825replbq {margin:4px;}#yiv2318001825 #yiv2318001825ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2318001825 #yiv2318001825ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2318001825 #yiv2318001825ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2318001825 #yiv2318001825ygrp-mlmsg select, #yiv2318001825 input, #yiv2318001825 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2318001825 #yiv2318001825ygrp-mlmsg pre, #yiv2318001825 code {font:115% monospace;}#yiv2318001825 #yiv2318001825ygrp-mlmsg * {line-height:1.22em;}#yiv2318001825 #yiv2318001825ygrp-mlmsg #yiv2318001825logo {padding-bottom:10px;}#yiv2318001825 #yiv2318001825ygrp-msg p a {font-family:Verdana;}#yiv2318001825 #yiv2318001825ygrp-msg p#yiv2318001825attach-count span {color:#1E66AE;font-weight:700;}#yiv2318001825 #yiv2318001825ygrp-reco #yiv2318001825reco-head {color:#ff7900;font-weight:700;}#yiv2318001825 #yiv2318001825ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov li a {font-size:130%;text-decoration:none;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2318001825 #yiv2318001825ygrp-sponsor #yiv2318001825ov ul {margin:0;padding:0 0 0 8px;}#yiv2318001825 #yiv2318001825ygrp-text {font-family:Georgia;}#yiv2318001825 #yiv2318001825ygrp-text p {margin:0 0 1em 0;}#yiv2318001825 #yiv2318001825ygrp-text tt {font-size:120%;}#yiv2318001825 #yiv2318001825ygrp-vital ul li:last-child {border-right:none !important;}#yiv2318001825

Wed Oct 30, 2019 3:30 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

atau kalau mau lebih sederhana dengan hasil yang sama tulis di J2
=IFERROR(INDEX({500000,450000,400000,325000},MONTH(G2)-3),"zonk")

Ghozi Alkatiri

Pada Kamis, 31 Oktober 2019 05.23.19 WIB, ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

sory yang benar adalah:
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))

Ghozi Alkatiri
Pada Kamis, 31 Oktober 2019 03.38.50 WIB, ghozi alkatiri ghozialkatiri@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

mungkin rumus untuk J2  yang benar adalah =IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000, IF(G2=MONTH=4,500000,"zonk"))))

wassalam 
Ghozi Alkatiri Pada Rabu, 30 Oktober 2019 22.38.14 WIB, Edhie Wibowo edhiewibowo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Selamat Siang semua rekan2,
mohon ijin utk bertanya ttg rumus IF bertingkat di kolom "I"
untuk memberikan uang bonus penghargaan kepada petugas Kring PBB.
Ketentuan bonus:
Untuk pelunasan bln Juli 2019 = Rp.325.000,-
Untuk pelunasan bln Juni 2019 = Rp.400.000,-
Untuk pelunasan bln Mei 2019 = Rp.450.000,-
Untuk pelunasan bln April 2019 = Rp.400.000,-

Saya coba memakai formula "IF" tapi kok error, mohon
pencerahannya.

Trims sebelumnya.

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

#yiv6224570014 #yiv6224570014 -- #yiv6224570014ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6224570014 #yiv6224570014ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6224570014 #yiv6224570014ygrp-mkp #yiv6224570014hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6224570014 #yiv6224570014ygrp-mkp #yiv6224570014ads {margin-bottom:10px;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad {padding:0 0;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad p {margin:0;}#yiv6224570014 #yiv6224570014ygrp-mkp .yiv6224570014ad a {color:#0000ff;text-decoration:none;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc {font-family:Arial;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc #yiv6224570014hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ygrp-lc .yiv6224570014ad {margin-bottom:10px;padding:0 0;}#yiv6224570014 #yiv6224570014actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6224570014 #yiv6224570014activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6224570014 #yiv6224570014activity span {font-weight:700;}#yiv6224570014 #yiv6224570014activity span:first-child {text-transform:uppercase;}#yiv6224570014 #yiv6224570014activity span a {color:#5085b6;text-decoration:none;}#yiv6224570014 #yiv6224570014activity span span {color:#ff7900;}#yiv6224570014 #yiv6224570014activity span .yiv6224570014underline {text-decoration:underline;}#yiv6224570014 .yiv6224570014attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6224570014 .yiv6224570014attach div a {text-decoration:none;}#yiv6224570014 .yiv6224570014attach img {border:none;padding-right:5px;}#yiv6224570014 .yiv6224570014attach label {display:block;margin-bottom:5px;}#yiv6224570014 .yiv6224570014attach label a {text-decoration:none;}#yiv6224570014 blockquote {margin:0 0 0 4px;}#yiv6224570014 .yiv6224570014bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6224570014 .yiv6224570014bold a {text-decoration:none;}#yiv6224570014 dd.yiv6224570014last p a {font-family:Verdana;font-weight:700;}#yiv6224570014 dd.yiv6224570014last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6224570014 dd.yiv6224570014last p span.yiv6224570014yshortcuts {margin-right:0;}#yiv6224570014 div.yiv6224570014attach-table div div a {text-decoration:none;}#yiv6224570014 div.yiv6224570014attach-table {width:400px;}#yiv6224570014 div.yiv6224570014file-title a, #yiv6224570014 div.yiv6224570014file-title a:active, #yiv6224570014 div.yiv6224570014file-title a:hover, #yiv6224570014 div.yiv6224570014file-title a:visited {text-decoration:none;}#yiv6224570014 div.yiv6224570014photo-title a, #yiv6224570014 div.yiv6224570014photo-title a:active, #yiv6224570014 div.yiv6224570014photo-title a:hover, #yiv6224570014 div.yiv6224570014photo-title a:visited {text-decoration:none;}#yiv6224570014 div#yiv6224570014ygrp-mlmsg #yiv6224570014ygrp-msg p a span.yiv6224570014yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6224570014 .yiv6224570014green {color:#628c2a;}#yiv6224570014 .yiv6224570014MsoNormal {margin:0 0 0 0;}#yiv6224570014 o {font-size:0;}#yiv6224570014 #yiv6224570014photos div {float:left;width:72px;}#yiv6224570014 #yiv6224570014photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6224570014 #yiv6224570014photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6224570014 #yiv6224570014reco-category {font-size:77%;}#yiv6224570014 #yiv6224570014reco-desc {font-size:77%;}#yiv6224570014 .yiv6224570014replbq {margin:4px;}#yiv6224570014 #yiv6224570014ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6224570014 #yiv6224570014ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6224570014 #yiv6224570014ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6224570014 #yiv6224570014ygrp-mlmsg select, #yiv6224570014 input, #yiv6224570014 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6224570014 #yiv6224570014ygrp-mlmsg pre, #yiv6224570014 code {font:115% monospace;}#yiv6224570014 #yiv6224570014ygrp-mlmsg * {line-height:1.22em;}#yiv6224570014 #yiv6224570014ygrp-mlmsg #yiv6224570014logo {padding-bottom:10px;}#yiv6224570014 #yiv6224570014ygrp-msg p a {font-family:Verdana;}#yiv6224570014 #yiv6224570014ygrp-msg p#yiv6224570014attach-count span {color:#1E66AE;font-weight:700;}#yiv6224570014 #yiv6224570014ygrp-reco #yiv6224570014reco-head {color:#ff7900;font-weight:700;}#yiv6224570014 #yiv6224570014ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov li a {font-size:130%;text-decoration:none;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6224570014 #yiv6224570014ygrp-sponsor #yiv6224570014ov ul {margin:0;padding:0 0 0 8px;}#yiv6224570014 #yiv6224570014ygrp-text {font-family:Georgia;}#yiv6224570014 #yiv6224570014ygrp-text p {margin:0 0 1em 0;}#yiv6224570014 #yiv6224570014ygrp-text tt {font-size:120%;}#yiv6224570014 #yiv6224570014ygrp-vital ul li:last-child {border-right:none !important;}#yiv6224570014

Wed Oct 30, 2019 4:20 pm (PDT) . Posted by:

"Edhie Wibowo" edhiewibowo

Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
----------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2 yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
----------------------------------------------------------
--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

Wed Oct 30, 2019 4:20 pm (PDT) . Posted by:

"Edhie Wibowo" edhiewibowo

Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
----------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2 yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
----------------------------------------------------------

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

Wed Oct 30, 2019 4:20 pm (PDT) . Posted by:

"Edhie Wibowo" edhiewibowo

Makasih banyak mas Ghozi, skr sdh benar rumusnya. :)

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

Wed Oct 30, 2019 5:12 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

selamat pagi,kan sudah saya ralat , yang betul adalah di J2 copy ke bawah
=IF(MONTH(G2)=7,325000, IF(MONTH(G2)=6,400000, IF(MONTH(G2)=5,450000, IF(MONTH(G2)=4,500000,"zonk"))))

atau yang lebih sederhana
=IFERROR(INDEX({500000,450000,400000,325000},MONTH(G2)-3),"zonk")

silahkan dicoba dua duanya saya tunggu responnya
wassalam

Pada Kamis, 31 Oktober 2019 06.21.41 WIB, Edhie Wibowo edhiewibowo@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 
Pagi mas Ghozi dan temen2, untuk rumus yg disarankan mas, ini saya
coba kok blm bisa, mohon pencerahannya. (saya sertakan file utk
dianalisa). Terima kasih
----------------------------------------------------------
Rumus yg disarankan:
mungkin rumus untuk J2 yang benar adalah
=IF(G2=MONTH=7,325000, IF(G2=MONTH=6,400000, IF(G2=MONTH=5,450000,
IF(G2=MONTH=4,500000,"zonk"))))
----------------------------------------------------------

--
Jabat hangat,
Edhie Wibowo

"Vision Shows the Way, Passion Sustains the Journey"

#yiv6343239071 #yiv6343239071 -- #yiv6343239071ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6343239071 #yiv6343239071ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6343239071 #yiv6343239071ygrp-mkp #yiv6343239071hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6343239071 #yiv6343239071ygrp-mkp #yiv6343239071ads {margin-bottom:10px;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad {padding:0 0;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad p {margin:0;}#yiv6343239071 #yiv6343239071ygrp-mkp .yiv6343239071ad a {color:#0000ff;text-decoration:none;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc {font-family:Arial;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc #yiv6343239071hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ygrp-lc .yiv6343239071ad {margin-bottom:10px;padding:0 0;}#yiv6343239071 #yiv6343239071actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6343239071 #yiv6343239071activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6343239071 #yiv6343239071activity span {font-weight:700;}#yiv6343239071 #yiv6343239071activity span:first-child {text-transform:uppercase;}#yiv6343239071 #yiv6343239071activity span a {color:#5085b6;text-decoration:none;}#yiv6343239071 #yiv6343239071activity span span {color:#ff7900;}#yiv6343239071 #yiv6343239071activity span .yiv6343239071underline {text-decoration:underline;}#yiv6343239071 .yiv6343239071attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6343239071 .yiv6343239071attach div a {text-decoration:none;}#yiv6343239071 .yiv6343239071attach img {border:none;padding-right:5px;}#yiv6343239071 .yiv6343239071attach label {display:block;margin-bottom:5px;}#yiv6343239071 .yiv6343239071attach label a {text-decoration:none;}#yiv6343239071 blockquote {margin:0 0 0 4px;}#yiv6343239071 .yiv6343239071bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6343239071 .yiv6343239071bold a {text-decoration:none;}#yiv6343239071 dd.yiv6343239071last p a {font-family:Verdana;font-weight:700;}#yiv6343239071 dd.yiv6343239071last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6343239071 dd.yiv6343239071last p span.yiv6343239071yshortcuts {margin-right:0;}#yiv6343239071 div.yiv6343239071attach-table div div a {text-decoration:none;}#yiv6343239071 div.yiv6343239071attach-table {width:400px;}#yiv6343239071 div.yiv6343239071file-title a, #yiv6343239071 div.yiv6343239071file-title a:active, #yiv6343239071 div.yiv6343239071file-title a:hover, #yiv6343239071 div.yiv6343239071file-title a:visited {text-decoration:none;}#yiv6343239071 div.yiv6343239071photo-title a, #yiv6343239071 div.yiv6343239071photo-title a:active, #yiv6343239071 div.yiv6343239071photo-title a:hover, #yiv6343239071 div.yiv6343239071photo-title a:visited {text-decoration:none;}#yiv6343239071 div#yiv6343239071ygrp-mlmsg #yiv6343239071ygrp-msg p a span.yiv6343239071yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6343239071 .yiv6343239071green {color:#628c2a;}#yiv6343239071 .yiv6343239071MsoNormal {margin:0 0 0 0;}#yiv6343239071 o {font-size:0;}#yiv6343239071 #yiv6343239071photos div {float:left;width:72px;}#yiv6343239071 #yiv6343239071photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6343239071 #yiv6343239071photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6343239071 #yiv6343239071reco-category {font-size:77%;}#yiv6343239071 #yiv6343239071reco-desc {font-size:77%;}#yiv6343239071 .yiv6343239071replbq {margin:4px;}#yiv6343239071 #yiv6343239071ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6343239071 #yiv6343239071ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6343239071 #yiv6343239071ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6343239071 #yiv6343239071ygrp-mlmsg select, #yiv6343239071 input, #yiv6343239071 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6343239071 #yiv6343239071ygrp-mlmsg pre, #yiv6343239071 code {font:115% monospace;}#yiv6343239071 #yiv6343239071ygrp-mlmsg * {line-height:1.22em;}#yiv6343239071 #yiv6343239071ygrp-mlmsg #yiv6343239071logo {padding-bottom:10px;}#yiv6343239071 #yiv6343239071ygrp-msg p a {font-family:Verdana;}#yiv6343239071 #yiv6343239071ygrp-msg p#yiv6343239071attach-count span {color:#1E66AE;font-weight:700;}#yiv6343239071 #yiv6343239071ygrp-reco #yiv6343239071reco-head {color:#ff7900;font-weight:700;}#yiv6343239071 #yiv6343239071ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov li a {font-size:130%;text-decoration:none;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6343239071 #yiv6343239071ygrp-sponsor #yiv6343239071ov ul {margin:0;padding:0 0 0 8px;}#yiv6343239071 #yiv6343239071ygrp-text {font-family:Georgia;}#yiv6343239071 #yiv6343239071ygrp-text p {margin:0 0 1em 0;}#yiv6343239071 #yiv6343239071ygrp-text tt {font-size:120%;}#yiv6343239071 #yiv6343239071ygrp-vital ul li:last-child {border-right:none !important;}#yiv6343239071

Wed Oct 30, 2019 1:14 am (PDT) . Posted by:

"Kamirin Faqoth" kamirin_2

Dear Mr Kid,
Terima kasih atas atas petunjuknya, tapi sepertinya saya belum bisa mengaplikasikan power query dikarenakan PC yang saya gunakan adalah PC Client, jadi kalau install Add Ins harus dari servernya, makanya saya lebih nyaman menggunakan mega formula aja untuk saat ini
Salam,Kamirin

Pada Senin, 28 Oktober 2019 20.20.44 WIB, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Coba unduh materi kopdar 3, bisa disini :https://drive.google.com/file/d/13DQWES-OcUe-BHpwtki60SYBEQruRjXO/view?usp=sharing
atau disini :https://drive.google.com/file/d/1oXf4cE8CzZhqvEJE-_dvvbMUtTFYrctT/view?usp=sharing
atau di folder files milis di gdrive berikut :https://drive.google.com/drive/folders/1JoNf0qm5xgXDsRDaI3I85r_YZOAsiEoO?usp=sharing
ke folder materi kopdar, unduh file kopdar_03

On Sat, Oct 26, 2019 at 7:10 PM Kamirin Faqoth kamirin_2@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear Pa Iqbal,

Maaf, bisa dijelaskan tentang apa itu Power Query &  step by stepnya dari kasus saya bagaimana yaa pengerjaannya?
Maaf, Saya masih awam tentang power query?

Terima Kasih

Pada Rabu, 23 Oktober 2019 04.06.57 WIB, iq_bal76id@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Hi Kamirin,

Bisa di gunakan power query

 

 

Thanks

Best Regards

Muhammad Iqbal

+62890909010/0811101854

 

 

 

From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com>
Sent: Tuesday, October 22, 2019 3:50 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mencari Nilai dengan Kriteria Khusus [1 Attachment]

 

 

Dear All Member,

 

Mohon bantuannya, saya agak kesulitan mencari nilai dengan kriteria khusus pada tabel data yang sifatnya statis, dengan acuan tabel yang saya tandain warna kuning dan

dengan mengabaikan tabel yang tandain warna merah, Berikut Contoh Potongan File terlampir, terdiri dari 20 baris, file aslinya lebih dari 1000 baris.

 

Terim Kasih,

Kamirin

#yiv5552883195 #yiv5552883195 -- #yiv5552883195ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5552883195 #yiv5552883195ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5552883195 #yiv5552883195ygrp-mkp #yiv5552883195hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5552883195 #yiv5552883195ygrp-mkp #yiv5552883195ads {margin-bottom:10px;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad {padding:0 0;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad p {margin:0;}#yiv5552883195 #yiv5552883195ygrp-mkp .yiv5552883195ad a {color:#0000ff;text-decoration:none;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ygrp-lc {font-family:Arial;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ygrp-lc #yiv5552883195hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ygrp-lc .yiv5552883195ad {margin-bottom:10px;padding:0 0;}#yiv5552883195 #yiv5552883195actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5552883195 #yiv5552883195activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5552883195 #yiv5552883195activity span {font-weight:700;}#yiv5552883195 #yiv5552883195activity span:first-child {text-transform:uppercase;}#yiv5552883195 #yiv5552883195activity span a {color:#5085b6;text-decoration:none;}#yiv5552883195 #yiv5552883195activity span span {color:#ff7900;}#yiv5552883195 #yiv5552883195activity span .yiv5552883195underline {text-decoration:underline;}#yiv5552883195 .yiv5552883195attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5552883195 .yiv5552883195attach div a {text-decoration:none;}#yiv5552883195 .yiv5552883195attach img {border:none;padding-right:5px;}#yiv5552883195 .yiv5552883195attach label {display:block;margin-bottom:5px;}#yiv5552883195 .yiv5552883195attach label a {text-decoration:none;}#yiv5552883195 blockquote {margin:0 0 0 4px;}#yiv5552883195 .yiv5552883195bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5552883195 .yiv5552883195bold a {text-decoration:none;}#yiv5552883195 dd.yiv5552883195last p a {font-family:Verdana;font-weight:700;}#yiv5552883195 dd.yiv5552883195last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5552883195 dd.yiv5552883195last p span.yiv5552883195yshortcuts {margin-right:0;}#yiv5552883195 div.yiv5552883195attach-table div div a {text-decoration:none;}#yiv5552883195 div.yiv5552883195attach-table {width:400px;}#yiv5552883195 div.yiv5552883195file-title a, #yiv5552883195 div.yiv5552883195file-title a:active, #yiv5552883195 div.yiv5552883195file-title a:hover, #yiv5552883195 div.yiv5552883195file-title a:visited {text-decoration:none;}#yiv5552883195 div.yiv5552883195photo-title a, #yiv5552883195 div.yiv5552883195photo-title a:active, #yiv5552883195 div.yiv5552883195photo-title a:hover, #yiv5552883195 div.yiv5552883195photo-title a:visited {text-decoration:none;}#yiv5552883195 div#yiv5552883195ygrp-mlmsg #yiv5552883195ygrp-msg p a span.yiv5552883195yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5552883195 .yiv5552883195green {color:#628c2a;}#yiv5552883195 .yiv5552883195MsoNormal {margin:0 0 0 0;}#yiv5552883195 o {font-size:0;}#yiv5552883195 #yiv5552883195photos div {float:left;width:72px;}#yiv5552883195 #yiv5552883195photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5552883195 #yiv5552883195photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5552883195 #yiv5552883195reco-category {font-size:77%;}#yiv5552883195 #yiv5552883195reco-desc {font-size:77%;}#yiv5552883195 .yiv5552883195replbq {margin:4px;}#yiv5552883195 #yiv5552883195ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5552883195 #yiv5552883195ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5552883195 #yiv5552883195ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5552883195 #yiv5552883195ygrp-mlmsg select, #yiv5552883195 input, #yiv5552883195 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5552883195 #yiv5552883195ygrp-mlmsg pre, #yiv5552883195 code {font:115% monospace;}#yiv5552883195 #yiv5552883195ygrp-mlmsg * {line-height:1.22em;}#yiv5552883195 #yiv5552883195ygrp-mlmsg #yiv5552883195logo {padding-bottom:10px;}#yiv5552883195 #yiv5552883195ygrp-msg p a {font-family:Verdana;}#yiv5552883195 #yiv5552883195ygrp-msg p#yiv5552883195attach-count span {color:#1E66AE;font-weight:700;}#yiv5552883195 #yiv5552883195ygrp-reco #yiv5552883195reco-head {color:#ff7900;font-weight:700;}#yiv5552883195 #yiv5552883195ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ov li a {font-size:130%;text-decoration:none;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5552883195 #yiv5552883195ygrp-sponsor #yiv5552883195ov ul {margin:0;padding:0 0 0 8px;}#yiv5552883195 #yiv5552883195ygrp-text {font-family:Georgia;}#yiv5552883195 #yiv5552883195ygrp-text p {margin:0 0 1em 0;}#yiv5552883195 #yiv5552883195ygrp-text tt {font-size:120%;}#yiv5552883195 #yiv5552883195ygrp-vital ul li:last-child {border-right:none !important;}#yiv5552883195
============================================================
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
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 22.17 0 komentar
Langganan: Postingan (Atom)