[belajar-excel] Digest Number 4166

Milis Belajar Microsoft Excel Group

6 Messages

Digest #4166

1a

Membuat Laporan BOS K7a by "agus setiawan" agusmadania1

1b

Re: Membuat Laporan BOS K7a [1 Attachment] by "M.Ade Alfarid" aderyo

1c

Re: Membuat Laporan BOS K7a [1 Attachment] by "Eira I Arie" cheivory_bridge

2

Kopdar BeExceller by "Tio Adi Bayu Adjie"

3

Tambah hari kerja untuk 6 hari kerja by "imam cahyo yuwono"

4a

Re: Bls: [belajar-excel] kalender macro by "imam cahyo yuwono"

Messages

1a

Membuat Laporan BOS K7a

Tue Apr 25, 2017 11:02 pm (PDT) . Posted by:

"agus setiawan" agusmadania1

Yth para Master
mohon maaf ilmunya cetek
Belum bisa membuat Rumus dengan kriteria seperti data terlampir
Terimkasih atas bantuannya

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

1b

Re: Membuat Laporan BOS K7a [1 Attachment]

Tue Apr 25, 2017 11:15 pm (PDT) . Posted by:

"M.Ade Alfarid" aderyo

Mungkin kriterianya seperti terlampir?

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

*Sent:* Wednesday, April 26, 2017 12:27 PM
*To:* belajar-excel@yahoogroups.com
*Subject:* [belajar-excel] Membuat Laporan BOS K7a [1 Attachment]

Yth para Master

mohon maaf ilmunya cetek

Belum bisa membuat Rumus dengan kriteria seperti data terlampir

Terimkasih atas bantuannya

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

1c

Re: Membuat Laporan BOS K7a [1 Attachment]

Tue Apr 25, 2017 11:26 pm (PDT) . Posted by:

"Eira I Arie" cheivory_bridge

apakah seperti file terlampir ?

On Wednesday, April 26, 2017 1:02 PM, "agus setiawan agusmadania1@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Yth para Master
mohon maaf ilmunya cetek
Belum bisa membuat Rumus dengan kriteria seperti data terlampir
Terimkasih atas bantuannya

#yiv3579162291 #yiv3579162291 -- #yiv3579162291ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3579162291 #yiv3579162291ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3579162291 #yiv3579162291ygrp-mkp #yiv3579162291hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3579162291 #yiv3579162291ygrp-mkp #yiv3579162291ads {margin-bottom:10px;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad {padding:0 0;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad p {margin:0;}#yiv3579162291 #yiv3579162291ygrp-mkp .yiv3579162291ad a {color:#0000ff;text-decoration:none;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc {font-family:Arial;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc #yiv3579162291hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ygrp-lc .yiv3579162291ad {margin-bottom:10px;padding:0 0;}#yiv3579162291 #yiv3579162291actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3579162291 #yiv3579162291activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3579162291 #yiv3579162291activity span {font-weight:700;}#yiv3579162291 #yiv3579162291activity span:first-child {text-transform:uppercase;}#yiv3579162291 #yiv3579162291activity span a {color:#5085b6;text-decoration:none;}#yiv3579162291 #yiv3579162291activity span span {color:#ff7900;}#yiv3579162291 #yiv3579162291activity span .yiv3579162291underline {text-decoration:underline;}#yiv3579162291 .yiv3579162291attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3579162291 .yiv3579162291attach div a {text-decoration:none;}#yiv3579162291 .yiv3579162291attach img {border:none;padding-right:5px;}#yiv3579162291 .yiv3579162291attach label {display:block;margin-bottom:5px;}#yiv3579162291 .yiv3579162291attach label a {text-decoration:none;}#yiv3579162291 blockquote {margin:0 0 0 4px;}#yiv3579162291 .yiv3579162291bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3579162291 .yiv3579162291bold a {text-decoration:none;}#yiv3579162291 dd.yiv3579162291last p a {font-family:Verdana;font-weight:700;}#yiv3579162291 dd.yiv3579162291last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3579162291 dd.yiv3579162291last p span.yiv3579162291yshortcuts {margin-right:0;}#yiv3579162291 div.yiv3579162291attach-table div div a {text-decoration:none;}#yiv3579162291 div.yiv3579162291attach-table {width:400px;}#yiv3579162291 div.yiv3579162291file-title a, #yiv3579162291 div.yiv3579162291file-title a:active, #yiv3579162291 div.yiv3579162291file-title a:hover, #yiv3579162291 div.yiv3579162291file-title a:visited {text-decoration:none;}#yiv3579162291 div.yiv3579162291photo-title a, #yiv3579162291 div.yiv3579162291photo-title a:active, #yiv3579162291 div.yiv3579162291photo-title a:hover, #yiv3579162291 div.yiv3579162291photo-title a:visited {text-decoration:none;}#yiv3579162291 div#yiv3579162291ygrp-mlmsg #yiv3579162291ygrp-msg p a span.yiv3579162291yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3579162291 .yiv3579162291green {color:#628c2a;}#yiv3579162291 .yiv3579162291MsoNormal {margin:0 0 0 0;}#yiv3579162291 o {font-size:0;}#yiv3579162291 #yiv3579162291photos div {float:left;width:72px;}#yiv3579162291 #yiv3579162291photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3579162291 #yiv3579162291photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3579162291 #yiv3579162291reco-category {font-size:77%;}#yiv3579162291 #yiv3579162291reco-desc {font-size:77%;}#yiv3579162291 .yiv3579162291replbq {margin:4px;}#yiv3579162291 #yiv3579162291ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3579162291 #yiv3579162291ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3579162291 #yiv3579162291ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3579162291 #yiv3579162291ygrp-mlmsg select, #yiv3579162291 input, #yiv3579162291 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3579162291 #yiv3579162291ygrp-mlmsg pre, #yiv3579162291 code {font:115% monospace;}#yiv3579162291 #yiv3579162291ygrp-mlmsg * {line-height:1.22em;}#yiv3579162291 #yiv3579162291ygrp-mlmsg #yiv3579162291logo {padding-bottom:10px;}#yiv3579162291 #yiv3579162291ygrp-msg p a {font-family:Verdana;}#yiv3579162291 #yiv3579162291ygrp-msg p#yiv3579162291attach-count span {color:#1E66AE;font-weight:700;}#yiv3579162291 #yiv3579162291ygrp-reco #yiv3579162291reco-head {color:#ff7900;font-weight:700;}#yiv3579162291 #yiv3579162291ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov li a {font-size:130%;text-decoration:none;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3579162291 #yiv3579162291ygrp-sponsor #yiv3579162291ov ul {margin:0;padding:0 0 0 8px;}#yiv3579162291 #yiv3579162291ygrp-text {font-family:Georgia;}#yiv3579162291 #yiv3579162291ygrp-text p {margin:0 0 1em 0;}#yiv3579162291 #yiv3579162291ygrp-text tt {font-size:120%;}#yiv3579162291 #yiv3579162291ygrp-vital ul li:last-child {border-right:none !important;}#yiv3579162291

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

2

Kopdar BeExceller

Wed Apr 26, 2017 4:01 am (PDT) . Posted by:

"Tio Adi Bayu Adjie"

Salam Be Exceller,
Adakah ide untuk bikin Kopdar lagi ?

Regards,
Tio

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

3

Tambah hari kerja untuk 6 hari kerja

Wed Apr 26, 2017 4:01 am (PDT) . Posted by:

"imam cahyo yuwono"

Dear para expert
saya sedang membuat jadwal kegiatan dengan menggunakan formula workday dan networkdays, namum menemui kendala untuk membuat jadwal untuk 6 hari kerja, formula NETWORKDAYS.INTL tidak berfungsi, saya menggunakan excel 2007, apakah ada cara lain agar dapat dibuat jadwal untuk 6 hari kerja.
terima aksih

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

4a

Re: Bls: [belajar-excel] kalender macro

Wed Apr 26, 2017 6:40 pm (PDT) . Posted by:

"imam cahyo yuwono"

terima kasih mr Toby,

On Wednesday, December 7, 2016 9:19 AM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Dear Cahyo,
Sudah pernah menggunakan MonthView, coba menggunakan MonthView dengan Event DateClick.Dibanding menggunakan "Enter" untuk mencari tanggal yang dinginkan, akan lebih mudah dengan menggunakan mouse pointer untuk memilih tanggal, tinggal click aja..
TerimaKasih.

Pada Selasa, 6 Desember 2016 17:10, "imam cahyo yuwono chyywn@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear para Expert
Saya dapat form kalender yang sudah saya pakai namun ada yang saya minta bantuan agar tanggal yang tampil bisa dipilh dengan "ENTER" kalau bawaannya dengan double click agar bisa menggunakan keyboard saja untuk mempercepat pekerjaan
Terima kasih

#yiv1426456440 #yiv1426456440 -- #yiv1426456440ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1426456440 #yiv1426456440ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1426456440 #yiv1426456440ygrp-mkp #yiv1426456440hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1426456440 #yiv1426456440ygrp-mkp #yiv1426456440ads {margin-bottom:10px;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad {padding:0 0;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad p {margin:0;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad a {color:#0000ff;text-decoration:none;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc {font-family:Arial;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc #yiv1426456440hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc .yiv1426456440ad {margin-bottom:10px;padding:0 0;}#yiv1426456440 #yiv1426456440actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1426456440 #yiv1426456440activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1426456440 #yiv1426456440activity span {font-weight:700;}#yiv1426456440 #yiv1426456440activity span:first-child {text-transform:uppercase;}#yiv1426456440 #yiv1426456440activity span a {color:#5085b6;text-decoration:none;}#yiv1426456440 #yiv1426456440activity span span {color:#ff7900;}#yiv1426456440 #yiv1426456440activity span .yiv1426456440underline {text-decoration:underline;}#yiv1426456440 .yiv1426456440attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1426456440 .yiv1426456440attach div a {text-decoration:none;}#yiv1426456440 .yiv1426456440attach img {border:none;padding-right:5px;}#yiv1426456440 .yiv1426456440attach label {display:block;margin-bottom:5px;}#yiv1426456440 .yiv1426456440attach label a {text-decoration:none;}#yiv1426456440 blockquote {margin:0 0 0 4px;}#yiv1426456440 .yiv1426456440bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1426456440 .yiv1426456440bold a {text-decoration:none;}#yiv1426456440 dd.yiv1426456440last p a {font-family:Verdana;font-weight:700;}#yiv1426456440 dd.yiv1426456440last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1426456440 dd.yiv1426456440last p span.yiv1426456440yshortcuts {margin-right:0;}#yiv1426456440 div.yiv1426456440attach-table div div a {text-decoration:none;}#yiv1426456440 div.yiv1426456440attach-table {width:400px;}#yiv1426456440 div.yiv1426456440file-title a, #yiv1426456440 div.yiv1426456440file-title a:active, #yiv1426456440 div.yiv1426456440file-title a:hover, #yiv1426456440 div.yiv1426456440file-title a:visited {text-decoration:none;}#yiv1426456440 div.yiv1426456440photo-title a, #yiv1426456440 div.yiv1426456440photo-title a:active, #yiv1426456440 div.yiv1426456440photo-title a:hover, #yiv1426456440 div.yiv1426456440photo-title a:visited {text-decoration:none;}#yiv1426456440 div#yiv1426456440ygrp-mlmsg #yiv1426456440ygrp-msg p a span.yiv1426456440yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1426456440 .yiv1426456440green {color:#628c2a;}#yiv1426456440 .yiv1426456440MsoNormal {margin:0 0 0 0;}#yiv1426456440 o {font-size:0;}#yiv1426456440 #yiv1426456440photos div {float:left;width:72px;}#yiv1426456440 #yiv1426456440photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1426456440 #yiv1426456440photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1426456440 #yiv1426456440reco-category {font-size:77%;}#yiv1426456440 #yiv1426456440reco-desc {font-size:77%;}#yiv1426456440 .yiv1426456440replbq {margin:4px;}#yiv1426456440 #yiv1426456440ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1426456440 #yiv1426456440ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1426456440 #yiv1426456440ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1426456440 #yiv1426456440ygrp-mlmsg select, #yiv1426456440 input, #yiv1426456440 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1426456440 #yiv1426456440ygrp-mlmsg pre, #yiv1426456440 code {font:115% monospace;}#yiv1426456440 #yiv1426456440ygrp-mlmsg * {line-height:1.22em;}#yiv1426456440 #yiv1426456440ygrp-mlmsg #yiv1426456440logo {padding-bottom:10px;}#yiv1426456440 #yiv1426456440ygrp-msg p a {font-family:Verdana;}#yiv1426456440 #yiv1426456440ygrp-msg p#yiv1426456440attach-count span {color:#1E66AE;font-weight:700;}#yiv1426456440 #yiv1426456440ygrp-reco #yiv1426456440reco-head {color:#ff7900;font-weight:700;}#yiv1426456440 #yiv1426456440ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov li a {font-size:130%;text-decoration:none;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov ul {margin:0;padding:0 0 0 8px;}#yiv1426456440 #yiv1426456440ygrp-text {font-family:Georgia;}#yiv1426456440 #yiv1426456440ygrp-text p {margin:0 0 1em 0;}#yiv1426456440 #yiv1426456440ygrp-text tt {font-size:120%;}#yiv1426456440 #yiv1426456440ygrp-vital ul li:last-child {border-right:none !important;}#yiv1426456440

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

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use