Senin, 29 Agustus 2016

[belajar-excel] Digest Number 3951

4 Messages

Digest #3951

Messages

Sun Aug 28, 2016 7:30 pm (PDT) . Posted by:

"Fendik Anton Wijaya"

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.

Please consider the environment before printing this email.

Sun Aug 28, 2016 7:30 pm (PDT) . Posted by:

"farud oke"

Assalamualaikum wr.wb
Mohon bantuan para master sekalian...
Saya ingin menghilangkan/menyembunyikan gambar yang sudah di insert ketika
cell tertentu bernilai 2 dengan macro vba atau dengan rumus/formula jika
memang memungkinkan
untuk lebih jelasnya ada di file yang saya lampirkan,atas bantuan para
master sekalian saya sampaikan terimakasih
Wassalamualaikum wr.wb

Mon Aug 29, 2016 1:41 am (PDT) . Posted by:

"Abang Jakarta" budi170177



On Tuesday, August 23, 2016 11:00 AM, "Abang Jakarta abang_jakarta17@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Dear all ...
Mohon bantuannya dan sharing ilmunya ...
Saya punya data dalam lampiran, dalam data ini ada:1. Kolom B : tanggal kejadian 2. kolom D : incident category 3. kolom E : list of incident 4. kolom F : tower 5. kolom G :status 6. kolom H : date closed / kejadian selesai di follow up
Disheet statistic adalah jumlah total kejadian untuk keseluruhan. Yang saya ingin minta bantuan atau petunjuk dari para master excel adalah bagaimana caranya Rumus:
1. Menghitung kategori kejadian / incident category dimasing masing tower, misalnya berapa banyak kejadian yang berkaitan dengan Security di Tower 1 ( antara kolom D dan kolom F) 
2. Menghitung kejadian yang sering terjadi atau kejadian yang paling sering terjadi di masing masing tower dari data dikolom List of incident, misalnya kejadian " Door not Lock " di tower 1 ( kolom E dan F )
3. Menghitung status yang sudah closed, open atau on going di masing masing tower ( kolom G dan F )
4. Menghitung jumlah waktu response mulai dari yang tercepat statusnya closed dan terlama statusnya closed di masing masing tower dan secara keseluruhan yang merupakan gabungan tower 1 sampai tower 3
Terimakasih
arzie #yiv8371065051 #yiv8371065051 -- #yiv8371065051ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8371065051 #yiv8371065051ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8371065051 #yiv8371065051ygrp-mkp #yiv8371065051hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8371065051 #yiv8371065051ygrp-mkp #yiv8371065051ads {margin-bottom:10px;}#yiv8371065051 #yiv8371065051ygrp-mkp .yiv8371065051ad {padding:0 0;}#yiv8371065051 #yiv8371065051ygrp-mkp .yiv8371065051ad p {margin:0;}#yiv8371065051 #yiv8371065051ygrp-mkp .yiv8371065051ad a {color:#0000ff;text-decoration:none;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ygrp-lc {font-family:Arial;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ygrp-lc #yiv8371065051hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ygrp-lc .yiv8371065051ad {margin-bottom:10px;padding:0 0;}#yiv8371065051 #yiv8371065051actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8371065051 #yiv8371065051activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8371065051 #yiv8371065051activity span {font-weight:700;}#yiv8371065051 #yiv8371065051activity span:first-child {text-transform:uppercase;}#yiv8371065051 #yiv8371065051activity span a {color:#5085b6;text-decoration:none;}#yiv8371065051 #yiv8371065051activity span span {color:#ff7900;}#yiv8371065051 #yiv8371065051activity span .yiv8371065051underline {text-decoration:underline;}#yiv8371065051 .yiv8371065051attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8371065051 .yiv8371065051attach div a {text-decoration:none;}#yiv8371065051 .yiv8371065051attach img {border:none;padding-right:5px;}#yiv8371065051 .yiv8371065051attach label {display:block;margin-bottom:5px;}#yiv8371065051 .yiv8371065051attach label a {text-decoration:none;}#yiv8371065051 blockquote {margin:0 0 0 4px;}#yiv8371065051 .yiv8371065051bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8371065051 .yiv8371065051bold a {text-decoration:none;}#yiv8371065051 dd.yiv8371065051last p a {font-family:Verdana;font-weight:700;}#yiv8371065051 dd.yiv8371065051last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8371065051 dd.yiv8371065051last p span.yiv8371065051yshortcuts {margin-right:0;}#yiv8371065051 div.yiv8371065051attach-table div div a {text-decoration:none;}#yiv8371065051 div.yiv8371065051attach-table {width:400px;}#yiv8371065051 div.yiv8371065051file-title a, #yiv8371065051 div.yiv8371065051file-title a:active, #yiv8371065051 div.yiv8371065051file-title a:hover, #yiv8371065051 div.yiv8371065051file-title a:visited {text-decoration:none;}#yiv8371065051 div.yiv8371065051photo-title a, #yiv8371065051 div.yiv8371065051photo-title a:active, #yiv8371065051 div.yiv8371065051photo-title a:hover, #yiv8371065051 div.yiv8371065051photo-title a:visited {text-decoration:none;}#yiv8371065051 div#yiv8371065051ygrp-mlmsg #yiv8371065051ygrp-msg p a span.yiv8371065051yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8371065051 .yiv8371065051green {color:#628c2a;}#yiv8371065051 .yiv8371065051MsoNormal {margin:0 0 0 0;}#yiv8371065051 o {font-size:0;}#yiv8371065051 #yiv8371065051photos div {float:left;width:72px;}#yiv8371065051 #yiv8371065051photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8371065051 #yiv8371065051photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8371065051 #yiv8371065051reco-category {font-size:77%;}#yiv8371065051 #yiv8371065051reco-desc {font-size:77%;}#yiv8371065051 .yiv8371065051replbq {margin:4px;}#yiv8371065051 #yiv8371065051ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8371065051 #yiv8371065051ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8371065051 #yiv8371065051ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8371065051 #yiv8371065051ygrp-mlmsg select, #yiv8371065051 input, #yiv8371065051 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8371065051 #yiv8371065051ygrp-mlmsg pre, #yiv8371065051 code {font:115% monospace;}#yiv8371065051 #yiv8371065051ygrp-mlmsg * {line-height:1.22em;}#yiv8371065051 #yiv8371065051ygrp-mlmsg #yiv8371065051logo {padding-bottom:10px;}#yiv8371065051 #yiv8371065051ygrp-msg p a {font-family:Verdana;}#yiv8371065051 #yiv8371065051ygrp-msg p#yiv8371065051attach-count span {color:#1E66AE;font-weight:700;}#yiv8371065051 #yiv8371065051ygrp-reco #yiv8371065051reco-head {color:#ff7900;font-weight:700;}#yiv8371065051 #yiv8371065051ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ov li a {font-size:130%;text-decoration:none;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8371065051 #yiv8371065051ygrp-sponsor #yiv8371065051ov ul {margin:0;padding:0 0 0 8px;}#yiv8371065051 #yiv8371065051ygrp-text {font-family:Georgia;}#yiv8371065051 #yiv8371065051ygrp-text p {margin:0 0 1em 0;}#yiv8371065051 #yiv8371065051ygrp-text tt {font-size:120%;}#yiv8371065051 #yiv8371065051ygrp-vital ul li:last-child {border-right:none !important;}#yiv8371065051

Mon Aug 29, 2016 1:41 am (PDT) . Posted by:

"ilyas.akbar@ymail.com"

say perlu bantuan anda sedikit ini ada file xls berupa formulir pendaftaran. yabg ingin saya tanyakan disini adalah bagaimana caranya membuat seperti formulir tersebut
============================================================
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