Selasa, 30 Agustus 2016

[belajar-excel] Digest Number 3952

9 Messages

Digest #3952

Messages

Mon Aug 29, 2016 3:16 am (PDT) . Posted by:

"odong nando"

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..? 
br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

  Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli. Atas bantuannya saya ucapkan Terima Kasih Banyak.Semoga Amal  dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...Sekali lagi terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ýTowards a Sustainable Future - Please consider the environment before printing this email.
#yiv1640187844 #yiv1640187844 -- #yiv1640187844ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1640187844 #yiv1640187844ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1640187844 #yiv1640187844ygrp-mkp #yiv1640187844hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1640187844 #yiv1640187844ygrp-mkp #yiv1640187844ads {margin-bottom:10px;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad {padding:0 0;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad p {margin:0;}#yiv1640187844 #yiv1640187844ygrp-mkp .yiv1640187844ad a {color:#0000ff;text-decoration:none;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ygrp-lc {font-family:Arial;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ygrp-lc #yiv1640187844hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ygrp-lc .yiv1640187844ad {margin-bottom:10px;padding:0 0;}#yiv1640187844 #yiv1640187844actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1640187844 #yiv1640187844activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1640187844 #yiv1640187844activity span {font-weight:700;}#yiv1640187844 #yiv1640187844activity span:first-child {text-transform:uppercase;}#yiv1640187844 #yiv1640187844activity span a {color:#5085b6;text-decoration:none;}#yiv1640187844 #yiv1640187844activity span span {color:#ff7900;}#yiv1640187844 #yiv1640187844activity span .yiv1640187844underline {text-decoration:underline;}#yiv1640187844 .yiv1640187844attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1640187844 .yiv1640187844attach div a {text-decoration:none;}#yiv1640187844 .yiv1640187844attach img {border:none;padding-right:5px;}#yiv1640187844 .yiv1640187844attach label {display:block;margin-bottom:5px;}#yiv1640187844 .yiv1640187844attach label a {text-decoration:none;}#yiv1640187844 blockquote {margin:0 0 0 4px;}#yiv1640187844 .yiv1640187844bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1640187844 .yiv1640187844bold a {text-decoration:none;}#yiv1640187844 dd.yiv1640187844last p a {font-family:Verdana;font-weight:700;}#yiv1640187844 dd.yiv1640187844last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1640187844 dd.yiv1640187844last p span.yiv1640187844yshortcuts {margin-right:0;}#yiv1640187844 div.yiv1640187844attach-table div div a {text-decoration:none;}#yiv1640187844 div.yiv1640187844attach-table {width:400px;}#yiv1640187844 div.yiv1640187844file-title a, #yiv1640187844 div.yiv1640187844file-title a:active, #yiv1640187844 div.yiv1640187844file-title a:hover, #yiv1640187844 div.yiv1640187844file-title a:visited {text-decoration:none;}#yiv1640187844 div.yiv1640187844photo-title a, #yiv1640187844 div.yiv1640187844photo-title a:active, #yiv1640187844 div.yiv1640187844photo-title a:hover, #yiv1640187844 div.yiv1640187844photo-title a:visited {text-decoration:none;}#yiv1640187844 div#yiv1640187844ygrp-mlmsg #yiv1640187844ygrp-msg p a span.yiv1640187844yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1640187844 .yiv1640187844green {color:#628c2a;}#yiv1640187844 .yiv1640187844MsoNormal {margin:0 0 0 0;}#yiv1640187844 o {font-size:0;}#yiv1640187844 #yiv1640187844photos div {float:left;width:72px;}#yiv1640187844 #yiv1640187844photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1640187844 #yiv1640187844photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1640187844 #yiv1640187844reco-category {font-size:77%;}#yiv1640187844 #yiv1640187844reco-desc {font-size:77%;}#yiv1640187844 .yiv1640187844replbq {margin:4px;}#yiv1640187844 #yiv1640187844ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1640187844 #yiv1640187844ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1640187844 #yiv1640187844ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1640187844 #yiv1640187844ygrp-mlmsg select, #yiv1640187844 input, #yiv1640187844 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1640187844 #yiv1640187844ygrp-mlmsg pre, #yiv1640187844 code {font:115% monospace;}#yiv1640187844 #yiv1640187844ygrp-mlmsg * {line-height:1.22em;}#yiv1640187844 #yiv1640187844ygrp-mlmsg #yiv1640187844logo {padding-bottom:10px;}#yiv1640187844 #yiv1640187844ygrp-msg p a {font-family:Verdana;}#yiv1640187844 #yiv1640187844ygrp-msg p#yiv1640187844attach-count span {color:#1E66AE;font-weight:700;}#yiv1640187844 #yiv1640187844ygrp-reco #yiv1640187844reco-head {color:#ff7900;font-weight:700;}#yiv1640187844 #yiv1640187844ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ov li a {font-size:130%;text-decoration:none;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1640187844 #yiv1640187844ygrp-sponsor #yiv1640187844ov ul {margin:0;padding:0 0 0 8px;}#yiv1640187844 #yiv1640187844ygrp-text {font-family:Georgia;}#yiv1640187844 #yiv1640187844ygrp-text p {margin:0 0 1em 0;}#yiv1640187844 #yiv1640187844ygrp-text tt {font-size:120%;}#yiv1640187844 #yiv1640187844ygrp-vital ul li:last-child {border-right:none !important;}#yiv1640187844

Mon Aug 29, 2016 5:53 pm (PDT) . Posted by:

"Fendik Anton Wijaya"

Terima kasih banyak Om Odong Nando atas responnya...

Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...
Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan...

Mohon maaf om klo penjelasannya kurang jelas...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Monday, August 29, 2016 6:13 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com

Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli.

Atas bantuannya saya ucapkan Terima Kasih Banyak.
Semoga Amal dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...
Sekali lagi terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

-------------------

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

Please consider the environment before printing this email.

Mon Aug 29, 2016 9:01 pm (PDT) . Posted by:

"odong nando"

coba formula,
=COUNTIF(D5:D17;">="&TODAY()-7)

bila kompi setempat berigional english ganti titik koma ";" dengan koma ","
bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

  Terima kasih banyak Om Odong Nando atas responnya... Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan... Mohon maaf om klo penjelasannya kurang jelas... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Monday, August 29, 2016 6:13 PMTo: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?
 br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]
   Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli. Atas bantuannya saya ucapkan Terima Kasih Banyak.Semoga Amal  dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...Sekali lagi terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span>Towards a Sustainable Future - Please consider the environment before printing this email.
#yiv2159025051 #yiv2159025051 -- #yiv2159025051ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2159025051 #yiv2159025051ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2159025051 #yiv2159025051ygrp-mkp #yiv2159025051hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2159025051 #yiv2159025051ygrp-mkp #yiv2159025051ads {margin-bottom:10px;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad {padding:0 0;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad p {margin:0;}#yiv2159025051 #yiv2159025051ygrp-mkp .yiv2159025051ad a {color:#0000ff;text-decoration:none;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ygrp-lc {font-family:Arial;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ygrp-lc #yiv2159025051hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ygrp-lc .yiv2159025051ad {margin-bottom:10px;padding:0 0;}#yiv2159025051 #yiv2159025051actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2159025051 #yiv2159025051activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2159025051 #yiv2159025051activity span {font-weight:700;}#yiv2159025051 #yiv2159025051activity span:first-child {text-transform:uppercase;}#yiv2159025051 #yiv2159025051activity span a {color:#5085b6;text-decoration:none;}#yiv2159025051 #yiv2159025051activity span span {color:#ff7900;}#yiv2159025051 #yiv2159025051activity span .yiv2159025051underline {text-decoration:underline;}#yiv2159025051 .yiv2159025051attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2159025051 .yiv2159025051attach div a {text-decoration:none;}#yiv2159025051 .yiv2159025051attach img {border:none;padding-right:5px;}#yiv2159025051 .yiv2159025051attach label {display:block;margin-bottom:5px;}#yiv2159025051 .yiv2159025051attach label a {text-decoration:none;}#yiv2159025051 blockquote {margin:0 0 0 4px;}#yiv2159025051 .yiv2159025051bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2159025051 .yiv2159025051bold a {text-decoration:none;}#yiv2159025051 dd.yiv2159025051last p a {font-family:Verdana;font-weight:700;}#yiv2159025051 dd.yiv2159025051last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2159025051 dd.yiv2159025051last p span.yiv2159025051yshortcuts {margin-right:0;}#yiv2159025051 div.yiv2159025051attach-table div div a {text-decoration:none;}#yiv2159025051 div.yiv2159025051attach-table {width:400px;}#yiv2159025051 div.yiv2159025051file-title a, #yiv2159025051 div.yiv2159025051file-title a:active, #yiv2159025051 div.yiv2159025051file-title a:hover, #yiv2159025051 div.yiv2159025051file-title a:visited {text-decoration:none;}#yiv2159025051 div.yiv2159025051photo-title a, #yiv2159025051 div.yiv2159025051photo-title a:active, #yiv2159025051 div.yiv2159025051photo-title a:hover, #yiv2159025051 div.yiv2159025051photo-title a:visited {text-decoration:none;}#yiv2159025051 div#yiv2159025051ygrp-mlmsg #yiv2159025051ygrp-msg p a span.yiv2159025051yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2159025051 .yiv2159025051green {color:#628c2a;}#yiv2159025051 .yiv2159025051MsoNormal {margin:0 0 0 0;}#yiv2159025051 o {font-size:0;}#yiv2159025051 #yiv2159025051photos div {float:left;width:72px;}#yiv2159025051 #yiv2159025051photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2159025051 #yiv2159025051photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2159025051 #yiv2159025051reco-category {font-size:77%;}#yiv2159025051 #yiv2159025051reco-desc {font-size:77%;}#yiv2159025051 .yiv2159025051replbq {margin:4px;}#yiv2159025051 #yiv2159025051ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2159025051 #yiv2159025051ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2159025051 #yiv2159025051ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2159025051 #yiv2159025051ygrp-mlmsg select, #yiv2159025051 input, #yiv2159025051 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2159025051 #yiv2159025051ygrp-mlmsg pre, #yiv2159025051 code {font:115% monospace;}#yiv2159025051 #yiv2159025051ygrp-mlmsg * {line-height:1.22em;}#yiv2159025051 #yiv2159025051ygrp-mlmsg #yiv2159025051logo {padding-bottom:10px;}#yiv2159025051 #yiv2159025051ygrp-msg p a {font-family:Verdana;}#yiv2159025051 #yiv2159025051ygrp-msg p#yiv2159025051attach-count span {color:#1E66AE;font-weight:700;}#yiv2159025051 #yiv2159025051ygrp-reco #yiv2159025051reco-head {color:#ff7900;font-weight:700;}#yiv2159025051 #yiv2159025051ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ov li a {font-size:130%;text-decoration:none;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2159025051 #yiv2159025051ygrp-sponsor #yiv2159025051ov ul {margin:0;padding:0 0 0 8px;}#yiv2159025051 #yiv2159025051ygrp-text {font-family:Georgia;}#yiv2159025051 #yiv2159025051ygrp-text p {margin:0 0 1em 0;}#yiv2159025051 #yiv2159025051ygrp-text tt {font-size:120%;}#yiv2159025051 #yiv2159025051ygrp-vital ul li:last-child {border-right:none !important;}#yiv2159025051

Mon Aug 29, 2016 10:58 pm (PDT) . Posted by:

"Fendik Anton Wijaya"

Dear Om Odong Nando,

Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir...

Terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Tuesday, August 30, 2016 12:01 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

coba formula,

=COUNTIF(D5:D17;">="&TODAY()-7)

bila kompi setempat berigional english ganti titik koma ";" dengan koma ","

bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

Terima kasih banyak Om Odong Nando atas responnya...

Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...
Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan...

Mohon maaf om klo penjelasannya kurang jelas...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

From: mailto:belajar-excel@yahoogroups.com
Sent: Monday, August 29, 2016 6:13 PM
To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat

yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?

br,

odong nando

----------------------------------------------------------
Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli.
Atas bantuannya saya ucapkan Terima Kasih Banyak.
Semoga Amal dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...
Sekali lagi terima kasih banyak atas bantuannya...

Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

----------------------------------------------------------
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

-------------------

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

Please consider the environment before printing this email.

Tue Aug 30, 2016 12:21 am (PDT) . Posted by:

"odong nando"

=SUMPRODUCT(--(D5:D17>=EDATE(TODAY();-6))*--(E5:E17<=7))
EDATE bisa di ganti dengan EOMONTH, bila menginginkan month nya dibatsi dengan nilai bulannya saja, tidak termasuk tanggal, sebab formula di atas akan menghitung 5 bulan yang anda maksud namun di sesuaikan dengan tanggalnya. br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 11:29
Judul: Re: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]

  Dear Om Odong Nando, Sudah saya coba om tapi hasilnya 0...sudah saya jelaskan di kolom excel terlampir... Terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Tuesday, August 30, 2016 12:01 PMTo: belajar-excel@yahoogroups.com Subject: Bls: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   coba formula,
=COUNTIF(D5:D17;">="&TODAY()-7)
 bila kompi setempat berigional english ganti titik koma ";" dengan koma ","
bila belum sesuai, bisa di terangkan kembali knp tidak sesuainya, jangan lupa contoh nya, dan berikan bagaimana hasil yang diinginkan pada contoh tersebut, agar member milis yang lain dapat mengerti dan dapat membantu br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Selasa, 30 Agustus 2016 7:05
Judul: Re: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat
   Terima kasih banyak Om Odong Nando atas responnya... Betul om yang dicari hanya yg telat kurang dari 7 hari dari hari ini & hanya 5 bulan pertama yg saya lihat karena saya ada target F5PD...Jadi F5PD itu kemampuan customer bayar angsuran di 5 bulan pertama dari tanggal go live...karena saya ada target F5PD tsb jadi saya ingin melihat sapa aj yg nunggak < 7 hari & masih masuk 5 bulan... Mohon maaf om klo penjelasannya kurang jelas... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550 From: mailto:belajar-excel@yahoogroups.com Sent: Monday, August 29, 2016 6:13 PMTo: belajar-excel@yahoogroups.com Subject: Bls: [belajar-excel] rumus countif dengan beda kriteria bertingkat   yang dicari kan hanya yang telat kuran dari 7 hari dari hari "ini", kenapa harus pakai waktu 5 bulan ya..?
 br,

odong nando

Dari: "'Fendik Anton Wijaya' fendik.anton@tafinance.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 8:28
Judul: [belajar-excel] rumus countif dengan beda kriteria bertingkat [1 Attachment]
   Dear para suhu dan master sekalian mohon bantuannya saya masih bingung jika harus menggunakan formula countif bertingkat tapi dengan kriteria yg berbeda.Kriteria yang berbeda yang saya maksud adalah menggunakan kriteria bulan & kriteria jumlah hari over due dan jumlah penunggak tersebut juga bisa uptodate jika berganti bulan.Mohon bantuannya dengan sangat bagaimana rumusnya jika saya ingin mengetahui jumlah orang yang termasuk F5PD yang nunggak <= 7 hari tapi hanya 5 bulan dari bulan sekarang jadi yang dijumlahkan hanya bulan maret - juli. Atas bantuannya saya ucapkan Terima Kasih Banyak.Semoga Amal  dan ibadah di jadikan amal & saleh oleh ALLAH SWT...Amiin...Sekali lagi terima kasih banyak atas bantuannya... Best regards,

Fendik Anton Wijaya
PT. Toyota Astra Financial Services
Gedung GARDA OTO
Jl. A. Yani KM. 3.5 No. 66
Banjarmasin 70369
VOIP : 1929 EXT. 118
Telpon : 0511.3269136
Handphone : 081351356550
The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

ý Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span> Towards a Sustainable Future - Please consider the environment before printing this email.

The information transmitted is intended only for the person or the entity to which it is addressed and may contain confidential and/or privileged material. If you have received it by mistake please notify the sender by return e-mail and delete this message including any of its attachments from your system. Any use, review, reliance or dissemination of this message/information in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. The views expressed/presented in this email are solely those of the author and do not necessarily represent those of PT Toyota Astra Financial Services and should not be construed as the views, offers or acceptances of PT Toyota Astra Financial Services. The recipient should check this email/message and any attachments for the presence of viruses. PT Toyota Astra Financial Services accepts no liability for any damage caused by any viruses transmitted by this email/message.

�/span>Towards a Sustainable Future - Please consider the environment before printing this email.
#yiv5423879700 #yiv5423879700 -- #yiv5423879700ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5423879700 #yiv5423879700ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5423879700 #yiv5423879700ygrp-mkp #yiv5423879700hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5423879700 #yiv5423879700ygrp-mkp #yiv5423879700ads {margin-bottom:10px;}#yiv5423879700 #yiv5423879700ygrp-mkp .yiv5423879700ad {padding:0 0;}#yiv5423879700 #yiv5423879700ygrp-mkp .yiv5423879700ad p {margin:0;}#yiv5423879700 #yiv5423879700ygrp-mkp .yiv5423879700ad a {color:#0000ff;text-decoration:none;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ygrp-lc {font-family:Arial;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ygrp-lc #yiv5423879700hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ygrp-lc .yiv5423879700ad {margin-bottom:10px;padding:0 0;}#yiv5423879700 #yiv5423879700actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5423879700 #yiv5423879700activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5423879700 #yiv5423879700activity span {font-weight:700;}#yiv5423879700 #yiv5423879700activity span:first-child {text-transform:uppercase;}#yiv5423879700 #yiv5423879700activity span a {color:#5085b6;text-decoration:none;}#yiv5423879700 #yiv5423879700activity span span {color:#ff7900;}#yiv5423879700 #yiv5423879700activity span .yiv5423879700underline {text-decoration:underline;}#yiv5423879700 .yiv5423879700attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5423879700 .yiv5423879700attach div a {text-decoration:none;}#yiv5423879700 .yiv5423879700attach img {border:none;padding-right:5px;}#yiv5423879700 .yiv5423879700attach label {display:block;margin-bottom:5px;}#yiv5423879700 .yiv5423879700attach label a {text-decoration:none;}#yiv5423879700 blockquote {margin:0 0 0 4px;}#yiv5423879700 .yiv5423879700bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5423879700 .yiv5423879700bold a {text-decoration:none;}#yiv5423879700 dd.yiv5423879700last p a {font-family:Verdana;font-weight:700;}#yiv5423879700 dd.yiv5423879700last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5423879700 dd.yiv5423879700last p span.yiv5423879700yshortcuts {margin-right:0;}#yiv5423879700 div.yiv5423879700attach-table div div a {text-decoration:none;}#yiv5423879700 div.yiv5423879700attach-table {width:400px;}#yiv5423879700 div.yiv5423879700file-title a, #yiv5423879700 div.yiv5423879700file-title a:active, #yiv5423879700 div.yiv5423879700file-title a:hover, #yiv5423879700 div.yiv5423879700file-title a:visited {text-decoration:none;}#yiv5423879700 div.yiv5423879700photo-title a, #yiv5423879700 div.yiv5423879700photo-title a:active, #yiv5423879700 div.yiv5423879700photo-title a:hover, #yiv5423879700 div.yiv5423879700photo-title a:visited {text-decoration:none;}#yiv5423879700 div#yiv5423879700ygrp-mlmsg #yiv5423879700ygrp-msg p a span.yiv5423879700yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5423879700 .yiv5423879700green {color:#628c2a;}#yiv5423879700 .yiv5423879700MsoNormal {margin:0 0 0 0;}#yiv5423879700 o {font-size:0;}#yiv5423879700 #yiv5423879700photos div {float:left;width:72px;}#yiv5423879700 #yiv5423879700photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5423879700 #yiv5423879700photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5423879700 #yiv5423879700reco-category {font-size:77%;}#yiv5423879700 #yiv5423879700reco-desc {font-size:77%;}#yiv5423879700 .yiv5423879700replbq {margin:4px;}#yiv5423879700 #yiv5423879700ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5423879700 #yiv5423879700ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5423879700 #yiv5423879700ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5423879700 #yiv5423879700ygrp-mlmsg select, #yiv5423879700 input, #yiv5423879700 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5423879700 #yiv5423879700ygrp-mlmsg pre, #yiv5423879700 code {font:115% monospace;}#yiv5423879700 #yiv5423879700ygrp-mlmsg * {line-height:1.22em;}#yiv5423879700 #yiv5423879700ygrp-mlmsg #yiv5423879700logo {padding-bottom:10px;}#yiv5423879700 #yiv5423879700ygrp-msg p a {font-family:Verdana;}#yiv5423879700 #yiv5423879700ygrp-msg p#yiv5423879700attach-count span {color:#1E66AE;font-weight:700;}#yiv5423879700 #yiv5423879700ygrp-reco #yiv5423879700reco-head {color:#ff7900;font-weight:700;}#yiv5423879700 #yiv5423879700ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ov li a {font-size:130%;text-decoration:none;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5423879700 #yiv5423879700ygrp-sponsor #yiv5423879700ov ul {margin:0;padding:0 0 0 8px;}#yiv5423879700 #yiv5423879700ygrp-text {font-family:Georgia;}#yiv5423879700 #yiv5423879700ygrp-text p {margin:0 0 1em 0;}#yiv5423879700 #yiv5423879700ygrp-text tt {font-size:120%;}#yiv5423879700 #yiv5423879700ygrp-vital ul li:last-child {border-right:none !important;}#yiv5423879700

Mon Aug 29, 2016 4:01 am (PDT) . Posted by:

"odong nando"

yaodah ketik aja sesuai keinginan, dalam hal ini formulir lamaran, setelah itu block semua cell excel yang ada di sheet tersebut, klik kanan klik format cell cari tulisan protaction yang ada di samping kiri bawah dekat lambang ? "tandatanya" pojok kanan, centang locked dan hidden, klik "OK". setelah itu tinggal di proteck sheet nya dengan cara klik ribbon review klik protect sheet isi pasword sesuai kebutuhan, "OK"
jadi dah... br,

odong nando

Dari: "'ilyas.akbar@ymail.com' ilyas.akbar@ymail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Senin, 29 Agustus 2016 15:13
Judul: [belajar-excel] analisa file xls dan cara pembuatannya [1 Attachment]

  say perlu bantuan anda sedikit ini ada file xls berupa formulir pendaftaran. yabg ingin saya tanyakan disini adalah bagaimana caranya membuat seperti formulir tersebut #yiv4131072271 #yiv4131072271 -- #yiv4131072271ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4131072271 #yiv4131072271ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4131072271 #yiv4131072271ygrp-mkp #yiv4131072271hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4131072271 #yiv4131072271ygrp-mkp #yiv4131072271ads {margin-bottom:10px;}#yiv4131072271 #yiv4131072271ygrp-mkp .yiv4131072271ad {padding:0 0;}#yiv4131072271 #yiv4131072271ygrp-mkp .yiv4131072271ad p {margin:0;}#yiv4131072271 #yiv4131072271ygrp-mkp .yiv4131072271ad a {color:#0000ff;text-decoration:none;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ygrp-lc {font-family:Arial;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ygrp-lc #yiv4131072271hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ygrp-lc .yiv4131072271ad {margin-bottom:10px;padding:0 0;}#yiv4131072271 #yiv4131072271actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4131072271 #yiv4131072271activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4131072271 #yiv4131072271activity span {font-weight:700;}#yiv4131072271 #yiv4131072271activity span:first-child {text-transform:uppercase;}#yiv4131072271 #yiv4131072271activity span a {color:#5085b6;text-decoration:none;}#yiv4131072271 #yiv4131072271activity span span {color:#ff7900;}#yiv4131072271 #yiv4131072271activity span .yiv4131072271underline {text-decoration:underline;}#yiv4131072271 .yiv4131072271attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4131072271 .yiv4131072271attach div a {text-decoration:none;}#yiv4131072271 .yiv4131072271attach img {border:none;padding-right:5px;}#yiv4131072271 .yiv4131072271attach label {display:block;margin-bottom:5px;}#yiv4131072271 .yiv4131072271attach label a {text-decoration:none;}#yiv4131072271 blockquote {margin:0 0 0 4px;}#yiv4131072271 .yiv4131072271bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4131072271 .yiv4131072271bold a {text-decoration:none;}#yiv4131072271 dd.yiv4131072271last p a {font-family:Verdana;font-weight:700;}#yiv4131072271 dd.yiv4131072271last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4131072271 dd.yiv4131072271last p span.yiv4131072271yshortcuts {margin-right:0;}#yiv4131072271 div.yiv4131072271attach-table div div a {text-decoration:none;}#yiv4131072271 div.yiv4131072271attach-table {width:400px;}#yiv4131072271 div.yiv4131072271file-title a, #yiv4131072271 div.yiv4131072271file-title a:active, #yiv4131072271 div.yiv4131072271file-title a:hover, #yiv4131072271 div.yiv4131072271file-title a:visited {text-decoration:none;}#yiv4131072271 div.yiv4131072271photo-title a, #yiv4131072271 div.yiv4131072271photo-title a:active, #yiv4131072271 div.yiv4131072271photo-title a:hover, #yiv4131072271 div.yiv4131072271photo-title a:visited {text-decoration:none;}#yiv4131072271 div#yiv4131072271ygrp-mlmsg #yiv4131072271ygrp-msg p a span.yiv4131072271yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4131072271 .yiv4131072271green {color:#628c2a;}#yiv4131072271 .yiv4131072271MsoNormal {margin:0 0 0 0;}#yiv4131072271 o {font-size:0;}#yiv4131072271 #yiv4131072271photos div {float:left;width:72px;}#yiv4131072271 #yiv4131072271photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4131072271 #yiv4131072271photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4131072271 #yiv4131072271reco-category {font-size:77%;}#yiv4131072271 #yiv4131072271reco-desc {font-size:77%;}#yiv4131072271 .yiv4131072271replbq {margin:4px;}#yiv4131072271 #yiv4131072271ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4131072271 #yiv4131072271ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4131072271 #yiv4131072271ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4131072271 #yiv4131072271ygrp-mlmsg select, #yiv4131072271 input, #yiv4131072271 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4131072271 #yiv4131072271ygrp-mlmsg pre, #yiv4131072271 code {font:115% monospace;}#yiv4131072271 #yiv4131072271ygrp-mlmsg * {line-height:1.22em;}#yiv4131072271 #yiv4131072271ygrp-mlmsg #yiv4131072271logo {padding-bottom:10px;}#yiv4131072271 #yiv4131072271ygrp-msg p a {font-family:Verdana;}#yiv4131072271 #yiv4131072271ygrp-msg p#yiv4131072271attach-count span {color:#1E66AE;font-weight:700;}#yiv4131072271 #yiv4131072271ygrp-reco #yiv4131072271reco-head {color:#ff7900;font-weight:700;}#yiv4131072271 #yiv4131072271ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ov li a {font-size:130%;text-decoration:none;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4131072271 #yiv4131072271ygrp-sponsor #yiv4131072271ov ul {margin:0;padding:0 0 0 8px;}#yiv4131072271 #yiv4131072271ygrp-text {font-family:Georgia;}#yiv4131072271 #yiv4131072271ygrp-text p {margin:0 0 1em 0;}#yiv4131072271 #yiv4131072271ygrp-text tt {font-size:120%;}#yiv4131072271 #yiv4131072271ygrp-vital ul li:last-child {border-right:none !important;}#yiv4131072271

Tue Aug 30, 2016 12:08 am (PDT) . Posted by:

"him mah"

Assalamu'alaikum Wr. Wb.
Dear All
saya ada pertanyaan terkait dengan pencarian

saya punya tabel dengan 4 kolom (A-D)
kolom A: KODE
kolom B: TAHUN
kolom C: BULAN
kolom D: KET

kemudian isi tabel itu sebagai beikut:

KODE TAHUN BULAN KET
A1 2016 1 BAIK
A2 2016 2 BAIK
A3 2015 1 BAIK
B1 2015 3 CUKUP
B2 2014 4 CUKUP
B1 2013 5 KURANG
A1 2016 2 CUKUP
A3 2015 1 BAIK


yang jadi masalah
bagaiamana VBA untuk mencari apakah ada data
KODE: A2
TAHUN : 2016
BULAN : 2
KET: BAIK

sehingga nanti ketemu di baris ke-2

terima kasih

Tue Aug 30, 2016 12:32 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Buat kolom bantu disamping kiri tabel yang merupakan gabungan keempat kolom tersebut; untuk memudahkan tambahkan tanda "|"Jadi setelah insert kolom di kolom A maka pada sel A2 ditulis =B2&"|"&C2&"|"&D2&"|"&E2.Buat Vlookup dengan kriteria gabungan tersebut.

Salam,HK
From: "him mah himmah.mlg@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel <belajar-excel@yahoogroups.com>
Sent: Tuesday, 30 August 2016, 14:08
Subject: [belajar-excel] mencari string/kata dari range tertentu dan kolom tertentu

  Assalamu'alaikum Wr. Wb.Dear Allsaya ada pertanyaan terkait dengan pencarian

saya punya tabel dengan 4 kolom (A-D)kolom A: KODEkolom B: TAHUNkolom C: BULANkolom D: KET

kemudian isi tabel itu sebagai beikut:

| KODE | TAHUN | BULAN | KET |
| A1 | 2016 | 1 | BAIK |
| A2 | 2016 | 2 | BAIK |
| A3 | 2015 | 1 | BAIK |
| B1 | 2015 | 3 | CUKUP |
| B2 | 2014 | 4 | CUKUP |
| B1 | 2013 | 5 | KURANG |
| A1 | 2016 | 2 | CUKUP |
| A3 | 2015 | 1 | BAIK |


yang jadi masalahbagaiamana VBA untuk mencari apakah ada data  KODE: A2TAHUN : 2016BULAN : 2KET: BAIK
sehingga nanti ketemu di baris ke-2
terima kasih
#yiv8245229444 #yiv8245229444 -- #yiv8245229444ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8245229444 #yiv8245229444ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8245229444 #yiv8245229444ygrp-mkp #yiv8245229444hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8245229444 #yiv8245229444ygrp-mkp #yiv8245229444ads {margin-bottom:10px;}#yiv8245229444 #yiv8245229444ygrp-mkp .yiv8245229444ad {padding:0 0;}#yiv8245229444 #yiv8245229444ygrp-mkp .yiv8245229444ad p {margin:0;}#yiv8245229444 #yiv8245229444ygrp-mkp .yiv8245229444ad a {color:#0000ff;text-decoration:none;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ygrp-lc {font-family:Arial;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ygrp-lc #yiv8245229444hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ygrp-lc .yiv8245229444ad {margin-bottom:10px;padding:0 0;}#yiv8245229444 #yiv8245229444actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8245229444 #yiv8245229444activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8245229444 #yiv8245229444activity span {font-weight:700;}#yiv8245229444 #yiv8245229444activity span:first-child {text-transform:uppercase;}#yiv8245229444 #yiv8245229444activity span a {color:#5085b6;text-decoration:none;}#yiv8245229444 #yiv8245229444activity span span {color:#ff7900;}#yiv8245229444 #yiv8245229444activity span .yiv8245229444underline {text-decoration:underline;}#yiv8245229444 .yiv8245229444attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8245229444 .yiv8245229444attach div a {text-decoration:none;}#yiv8245229444 .yiv8245229444attach img {border:none;padding-right:5px;}#yiv8245229444 .yiv8245229444attach label {display:block;margin-bottom:5px;}#yiv8245229444 .yiv8245229444attach label a {text-decoration:none;}#yiv8245229444 blockquote {margin:0 0 0 4px;}#yiv8245229444 .yiv8245229444bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8245229444 .yiv8245229444bold a {text-decoration:none;}#yiv8245229444 dd.yiv8245229444last p a {font-family:Verdana;font-weight:700;}#yiv8245229444 dd.yiv8245229444last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8245229444 dd.yiv8245229444last p span.yiv8245229444yshortcuts {margin-right:0;}#yiv8245229444 div.yiv8245229444attach-table div div a {text-decoration:none;}#yiv8245229444 div.yiv8245229444attach-table {width:400px;}#yiv8245229444 div.yiv8245229444file-title a, #yiv8245229444 div.yiv8245229444file-title a:active, #yiv8245229444 div.yiv8245229444file-title a:hover, #yiv8245229444 div.yiv8245229444file-title a:visited {text-decoration:none;}#yiv8245229444 div.yiv8245229444photo-title a, #yiv8245229444 div.yiv8245229444photo-title a:active, #yiv8245229444 div.yiv8245229444photo-title a:hover, #yiv8245229444 div.yiv8245229444photo-title a:visited {text-decoration:none;}#yiv8245229444 div#yiv8245229444ygrp-mlmsg #yiv8245229444ygrp-msg p a span.yiv8245229444yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8245229444 .yiv8245229444green {color:#628c2a;}#yiv8245229444 .yiv8245229444MsoNormal {margin:0 0 0 0;}#yiv8245229444 o {font-size:0;}#yiv8245229444 #yiv8245229444photos div {float:left;width:72px;}#yiv8245229444 #yiv8245229444photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8245229444 #yiv8245229444photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8245229444 #yiv8245229444reco-category {font-size:77%;}#yiv8245229444 #yiv8245229444reco-desc {font-size:77%;}#yiv8245229444 .yiv8245229444replbq {margin:4px;}#yiv8245229444 #yiv8245229444ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8245229444 #yiv8245229444ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8245229444 #yiv8245229444ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8245229444 #yiv8245229444ygrp-mlmsg select, #yiv8245229444 input, #yiv8245229444 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8245229444 #yiv8245229444ygrp-mlmsg pre, #yiv8245229444 code {font:115% monospace;}#yiv8245229444 #yiv8245229444ygrp-mlmsg * {line-height:1.22em;}#yiv8245229444 #yiv8245229444ygrp-mlmsg #yiv8245229444logo {padding-bottom:10px;}#yiv8245229444 #yiv8245229444ygrp-msg p a {font-family:Verdana;}#yiv8245229444 #yiv8245229444ygrp-msg p#yiv8245229444attach-count span {color:#1E66AE;font-weight:700;}#yiv8245229444 #yiv8245229444ygrp-reco #yiv8245229444reco-head {color:#ff7900;font-weight:700;}#yiv8245229444 #yiv8245229444ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ov li a {font-size:130%;text-decoration:none;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8245229444 #yiv8245229444ygrp-sponsor #yiv8245229444ov ul {margin:0;padding:0 0 0 8px;}#yiv8245229444 #yiv8245229444ygrp-text {font-family:Georgia;}#yiv8245229444 #yiv8245229444ygrp-text p {margin:0 0 1em 0;}#yiv8245229444 #yiv8245229444ygrp-text tt {font-size:120%;}#yiv8245229444 #yiv8245229444ygrp-vital ul li:last-child {border-right:none !important;}#yiv8245229444

Tue Aug 30, 2016 1:05 am (PDT) . Posted by:

"him mah"

terima kasih pak
sudah ketemu

Sub find()
Dim i As Integer

Dim r as Integer r=0
for i = 1 to 15
If Cells(i, 1) & Cells(i, 2) & Cells(i, 3) & Cells(i, 4) =
"A220162BAIK" Then

r=r+1
End If
if r > 0 then goto ketemu
next i

ketemu:

msgbox(iif(r>0,"Ketemu","Tidak Ketemu")End Sub

2016-08-30 14:28 GMT+07:00 hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Buat kolom bantu disamping kiri tabel yang merupakan gabungan keempat
> kolom tersebut; untuk memudahkan tambahkan tanda "|"
> Jadi setelah insert kolom di kolom A maka pada sel A2 ditulis
> *=B2&"|"&C2&"|"&D2&"|"&E2*.
> Buat Vlookup dengan kriteria gabungan tersebut.
>
> Salam,
> HK
>
> ------------------------------
> *From:* "him mah himmah.mlg@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com>
> *To:* belajar-excel <belajar-excel@yahoogroups.com>
> *Sent:* Tuesday, 30 August 2016, 14:08
> *Subject:* [belajar-excel] mencari string/kata dari range tertentu dan
> kolom tertentu
>
>
> Assalamu'alaikum Wr. Wb.
> Dear All
> saya ada pertanyaan terkait dengan pencarian
>
>
> saya punya tabel dengan 4 kolom (A-D)
> kolom A: KODE
> kolom B: TAHUN
> kolom C: BULAN
> kolom D: KET
>
>
> kemudian isi tabel itu sebagai beikut:
>
> KODE TAHUN BULAN KET
> A1 2016 1 BAIK
> A2 2016 2 BAIK
> A3 2015 1 BAIK
> B1 2015 3 CUKUP
> B2 2014 4 CUKUP
> B1 2013 5 KURANG
> A1 2016 2 CUKUP
> A3 2015 1 BAIK
>
>
> ​
> yang jadi masalah
> bagaiamana VBA untuk mencari apakah ada data
> KODE: A2
> TAHUN : 2016
> BULAN : 2
> KET: BAIK
>
> sehingga nanti ketemu di baris ke-2
>
> terima kasih
>
>
>
>
>
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar