Sabtu, 13 Februari 2016

[belajar-excel] Digest Number 3755

6 Messages

Digest #3755

Messages

Fri Feb 12, 2016 1:52 am (PST) . Posted by:

"Toby kenzo" tobykenzo


Dear Roy,

Coba formula cell C2 : =TEXT(A2&"-"&B2,"mmm-yy")

TerimaKasih.
Pada Jum, 12/2/16, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] menggbungkan [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 12 Februari, 2016, 4:41 PM


 









dear mater excell.



bagaimana menggabung kan bulan dan tanggal.. aku
bingung..



wasalm



roy









#yiv0144068376 #yiv0144068376 --
#yiv0144068376ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0144068376 #yiv0144068376ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv0144068376 #yiv0144068376ygrp-mkp #yiv0144068376hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0144068376 #yiv0144068376ygrp-mkp #yiv0144068376ads {
margin-bottom:10px;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad {
padding:0 0;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad p {
margin:0;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad a {
color:#0000ff;text-decoration:none;}
#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc {
font-family:Arial;}

#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc #yiv0144068376hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc .yiv0144068376ad {
margin-bottom:10px;padding:0 0;}

#yiv0144068376 #yiv0144068376actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0144068376 #yiv0144068376activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0144068376 #yiv0144068376activity span {
font-weight:700;}

#yiv0144068376 #yiv0144068376activity span:first-child {
text-transform:uppercase;}

#yiv0144068376 #yiv0144068376activity span a {
color:#5085b6;text-decoration:none;}

#yiv0144068376 #yiv0144068376activity span span {
color:#ff7900;}

#yiv0144068376 #yiv0144068376activity span
.yiv0144068376underline {
text-decoration:underline;}

#yiv0144068376 .yiv0144068376attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0144068376 .yiv0144068376attach div a {
text-decoration:none;}

#yiv0144068376 .yiv0144068376attach img {
border:none;padding-right:5px;}

#yiv0144068376 .yiv0144068376attach label {
display:block;margin-bottom:5px;}

#yiv0144068376 .yiv0144068376attach label a {
text-decoration:none;}

#yiv0144068376 blockquote {
margin:0 0 0 4px;}

#yiv0144068376 .yiv0144068376bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0144068376 .yiv0144068376bold a {
text-decoration:none;}

#yiv0144068376 dd.yiv0144068376last p a {
font-family:Verdana;font-weight:700;}

#yiv0144068376 dd.yiv0144068376last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0144068376 dd.yiv0144068376last p
span.yiv0144068376yshortcuts {
margin-right:0;}

#yiv0144068376 div.yiv0144068376attach-table div div a {
text-decoration:none;}

#yiv0144068376 div.yiv0144068376attach-table {
width:400px;}

#yiv0144068376 div.yiv0144068376file-title a, #yiv0144068376
div.yiv0144068376file-title a:active, #yiv0144068376
div.yiv0144068376file-title a:hover, #yiv0144068376
div.yiv0144068376file-title a:visited {
text-decoration:none;}

#yiv0144068376 div.yiv0144068376photo-title a,
#yiv0144068376 div.yiv0144068376photo-title a:active,
#yiv0144068376 div.yiv0144068376photo-title a:hover,
#yiv0144068376 div.yiv0144068376photo-title a:visited {
text-decoration:none;}

#yiv0144068376 div#yiv0144068376ygrp-mlmsg
#yiv0144068376ygrp-msg p a span.yiv0144068376yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0144068376 .yiv0144068376green {
color:#628c2a;}

#yiv0144068376 .yiv0144068376MsoNormal {
margin:0 0 0 0;}

#yiv0144068376 o {
font-size:0;}

#yiv0144068376 #yiv0144068376photos div {
float:left;width:72px;}

#yiv0144068376 #yiv0144068376photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0144068376 #yiv0144068376photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0144068376 #yiv0144068376reco-category {
font-size:77%;}

#yiv0144068376 #yiv0144068376reco-desc {
font-size:77%;}

#yiv0144068376 .yiv0144068376replbq {
margin:4px;}

#yiv0144068376 #yiv0144068376ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg select,
#yiv0144068376 input, #yiv0144068376 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg pre, #yiv0144068376
code {
font:115% monospace;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg * {
line-height:1.22em;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg #yiv0144068376logo {
padding-bottom:10px;}


#yiv0144068376 #yiv0144068376ygrp-msg p a {
font-family:Verdana;}

#yiv0144068376 #yiv0144068376ygrp-msg
p#yiv0144068376attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0144068376 #yiv0144068376ygrp-reco
#yiv0144068376reco-head {
color:#ff7900;font-weight:700;}

#yiv0144068376 #yiv0144068376ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
li a {
font-size:130%;text-decoration:none;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0144068376 #yiv0144068376ygrp-text {
font-family:Georgia;}

#yiv0144068376 #yiv0144068376ygrp-text p {
margin:0 0 1em 0;}

#yiv0144068376 #yiv0144068376ygrp-text tt {
font-size:120%;}

#yiv0144068376 #yiv0144068376ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0144068376

Fri Feb 12, 2016 4:16 am (PST) . Posted by:

"Dede Sulaeman"

Dear BeExceller,

Mohon solusi atas file terlampir.

Salam,

DD

Fri Feb 12, 2016 7:35 pm (PST) . Posted by:

"roy sumarna" rohendi_2000

terima kasih mr toby.. bantuannya sangat menolong sekali

Pada Jumat, 12 Februari 2016 16:53, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
Dear Roy,

Coba formula cell C2 : =TEXT(A2&"-"&B2,"mmm-yy")

TerimaKasih.
Pada Jum, 12/2/16, roy sumarna rohendi_2000@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] menggbungkan [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Jumat, 12 Februari, 2016, 4:41 PM


 









dear mater excell.



bagaimana menggabung kan bulan dan tanggal.. aku
bingung..



wasalm



roy









#yiv0144068376 #yiv0144068376 --
#yiv0144068376ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv0144068376 #yiv0144068376ygrp-mkp hr {
border:1px solid #d8d8d8;}


#yiv0144068376 #yiv0144068376ygrp-mkp #yiv0144068376hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv0144068376 #yiv0144068376ygrp-mkp #yiv0144068376ads {
margin-bottom:10px;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad {
padding:0 0;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad p {
margin:0;}

#yiv0144068376 #yiv0144068376ygrp-mkp .yiv0144068376ad a {
color:#0000ff;text-decoration:none;}
#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc {
font-family:Arial;}

#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc #yiv0144068376hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv0144068376 #yiv0144068376ygrp-sponsor
#yiv0144068376ygrp-lc .yiv0144068376ad {
margin-bottom:10px;padding:0 0;}

#yiv0144068376 #yiv0144068376actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv0144068376 #yiv0144068376activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv0144068376 #yiv0144068376activity span {
font-weight:700;}

#yiv0144068376 #yiv0144068376activity span:first-child {
text-transform:uppercase;}

#yiv0144068376 #yiv0144068376activity span a {
color:#5085b6;text-decoration:none;}

#yiv0144068376 #yiv0144068376activity span span {
color:#ff7900;}

#yiv0144068376 #yiv0144068376activity span
.yiv0144068376underline {
text-decoration:underline;}

#yiv0144068376 .yiv0144068376attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv0144068376 .yiv0144068376attach div a {

text-decoration:none;}

#yiv0144068376 .yiv0144068376attach img {
border:none;padding-right:5px;}

#yiv0144068376 .yiv0144068376attach label {
display:block;margin-bottom:5px;}

#yiv0144068376 .yiv0144068376attach label a {
text-decoration:none;}

#yiv0144068376 blockquote {
margin:0 0 0 4px;}

#yiv0144068376 .yiv0144068376bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv0144068376 .yiv0144068376bold a {
text-decoration:none;}

#yiv0144068376 dd.yiv0144068376last p a {
font-family:Verdana;font-weight:700;}

#yiv0144068376 dd.yiv0144068376last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv0144068376 dd.yiv0144068376last p
span.yiv0144068376yshortcuts {
margin-right:0;}

#yiv0144068376 div.yiv0144068376attach-table div div a {
text-decoration:none;}

#yiv0144068376 div.yiv0144068376attach-table {
width:400px;}

#yiv0144068376 div.yiv0144068376file-title a, #yiv0144068376
div.yiv0144068376file-title a:active, #yiv0144068376
div.yiv0144068376file-title a:hover, #yiv0144068376
div.yiv0144068376file-title a:visited {
text-decoration:none;}

#yiv0144068376 div.yiv0144068376photo-title a,
#yiv0144068376 div.yiv0144068376photo-title a:active,
#yiv0144068376 div.yiv0144068376photo-title a:hover,
#yiv0144068376 div.yiv0144068376photo-title a:visited {
text-decoration:none;}

#yiv0144068376 div#yiv0144068376ygrp-mlmsg
#yiv0144068376ygrp-msg p a span.yiv0144068376yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv0144068376 .yiv0144068376green {
color:#628c2a;}

#yiv0144068376 .yiv0144068376MsoNormal {
margin:0 0 0 0;}

#yiv0144068376 o {
font-size:0;}

#yiv0144068376 #yiv0144068376photos div {
float:left;width:72px;}

#yiv0144068376 #yiv0144068376photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv0144068376 #yiv0144068376photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv0144068376 #yiv0144068376reco-category {
font-size:77%;}

#yiv0144068376 #yiv0144068376reco-desc {
font-size:77%;}

#yiv0144068376 .yiv0144068376replbq {
margin:4px;}

#yiv0144068376 #yiv0144068376ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg select,
#yiv0144068376 input, #yiv0144068376 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg pre, #yiv0144068376
code {
font:115% monospace;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg * {
line-height:1.22em;}

#yiv0144068376 #yiv0144068376ygrp-mlmsg #yiv0144068376logo {
padding-bottom:10px;}


#yiv0144068376 #yiv0144068376ygrp-msg p a {
font-family:Verdana;}

#yiv0144068376 #yiv0144068376ygrp-msg
p#yiv0144068376attach-count span {
color:#1E66AE;font-weight:700;}

#yiv0144068376 #yiv0144068376ygrp-reco
#yiv0144068376reco-head {
color:#ff7900;font-weight:700;}

#yiv0144068376 #yiv0144068376ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
li a {
font-size:130%;text-decoration:none;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv0144068376 #yiv0144068376ygrp-sponsor #yiv0144068376ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv0144068376 #yiv0144068376ygrp-text {
font-family:Georgia;}

#yiv0144068376 #yiv0144068376ygrp-text p {
margin:0 0 1em 0;}

#yiv0144068376 #yiv0144068376ygrp-text tt {
font-size:120%;}

#yiv0144068376 #yiv0144068376ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv0144068376
#yiv4213188812 #yiv4213188812 -- #yiv4213188812ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4213188812 #yiv4213188812ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4213188812 #yiv4213188812ygrp-mkp #yiv4213188812hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4213188812 #yiv4213188812ygrp-mkp #yiv4213188812ads {margin-bottom:10px;}#yiv4213188812 #yiv4213188812ygrp-mkp .yiv4213188812ad {padding:0 0;}#yiv4213188812 #yiv4213188812ygrp-mkp .yiv4213188812ad p {margin:0;}#yiv4213188812 #yiv4213188812ygrp-mkp .yiv4213188812ad a {color:#0000ff;text-decoration:none;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ygrp-lc {font-family:Arial;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ygrp-lc #yiv4213188812hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ygrp-lc .yiv4213188812ad {margin-bottom:10px;padding:0 0;}#yiv4213188812 #yiv4213188812actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4213188812 #yiv4213188812activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4213188812 #yiv4213188812activity span {font-weight:700;}#yiv4213188812 #yiv4213188812activity span:first-child {text-transform:uppercase;}#yiv4213188812 #yiv4213188812activity span a {color:#5085b6;text-decoration:none;}#yiv4213188812 #yiv4213188812activity span span {color:#ff7900;}#yiv4213188812 #yiv4213188812activity span .yiv4213188812underline {text-decoration:underline;}#yiv4213188812 .yiv4213188812attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4213188812 .yiv4213188812attach div a {text-decoration:none;}#yiv4213188812 .yiv4213188812attach img {border:none;padding-right:5px;}#yiv4213188812 .yiv4213188812attach label {display:block;margin-bottom:5px;}#yiv4213188812 .yiv4213188812attach label a {text-decoration:none;}#yiv4213188812 blockquote {margin:0 0 0 4px;}#yiv4213188812 .yiv4213188812bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4213188812 .yiv4213188812bold a {text-decoration:none;}#yiv4213188812 dd.yiv4213188812last p a {font-family:Verdana;font-weight:700;}#yiv4213188812 dd.yiv4213188812last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4213188812 dd.yiv4213188812last p span.yiv4213188812yshortcuts {margin-right:0;}#yiv4213188812 div.yiv4213188812attach-table div div a {text-decoration:none;}#yiv4213188812 div.yiv4213188812attach-table {width:400px;}#yiv4213188812 div.yiv4213188812file-title a, #yiv4213188812 div.yiv4213188812file-title a:active, #yiv4213188812 div.yiv4213188812file-title a:hover, #yiv4213188812 div.yiv4213188812file-title a:visited {text-decoration:none;}#yiv4213188812 div.yiv4213188812photo-title a, #yiv4213188812 div.yiv4213188812photo-title a:active, #yiv4213188812 div.yiv4213188812photo-title a:hover, #yiv4213188812 div.yiv4213188812photo-title a:visited {text-decoration:none;}#yiv4213188812 div#yiv4213188812ygrp-mlmsg #yiv4213188812ygrp-msg p a span.yiv4213188812yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4213188812 .yiv4213188812green {color:#628c2a;}#yiv4213188812 .yiv4213188812MsoNormal {margin:0 0 0 0;}#yiv4213188812 o {font-size:0;}#yiv4213188812 #yiv4213188812photos div {float:left;width:72px;}#yiv4213188812 #yiv4213188812photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4213188812 #yiv4213188812photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4213188812 #yiv4213188812reco-category {font-size:77%;}#yiv4213188812 #yiv4213188812reco-desc {font-size:77%;}#yiv4213188812 .yiv4213188812replbq {margin:4px;}#yiv4213188812 #yiv4213188812ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4213188812 #yiv4213188812ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4213188812 #yiv4213188812ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4213188812 #yiv4213188812ygrp-mlmsg select, #yiv4213188812 input, #yiv4213188812 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4213188812 #yiv4213188812ygrp-mlmsg pre, #yiv4213188812 code {font:115% monospace;}#yiv4213188812 #yiv4213188812ygrp-mlmsg * {line-height:1.22em;}#yiv4213188812 #yiv4213188812ygrp-mlmsg #yiv4213188812logo {padding-bottom:10px;}#yiv4213188812 #yiv4213188812ygrp-msg p a {font-family:Verdana;}#yiv4213188812 #yiv4213188812ygrp-msg p#yiv4213188812attach-count span {color:#1E66AE;font-weight:700;}#yiv4213188812 #yiv4213188812ygrp-reco #yiv4213188812reco-head {color:#ff7900;font-weight:700;}#yiv4213188812 #yiv4213188812ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ov li a {font-size:130%;text-decoration:none;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4213188812 #yiv4213188812ygrp-sponsor #yiv4213188812ov ul {margin:0;padding:0 0 0 8px;}#yiv4213188812 #yiv4213188812ygrp-text {font-family:Georgia;}#yiv4213188812 #yiv4213188812ygrp-text p {margin:0 0 1em 0;}#yiv4213188812 #yiv4213188812ygrp-text tt {font-size:120%;}#yiv4213188812 #yiv4213188812ygrp-vital ul li:last-child {border-right:none !important;}#yiv4213188812

Fri Feb 12, 2016 2:06 am (PST) . Posted by:

"Susilo -"

Dear Mr Kid

Terima kasih sekali atas bantuan dan rumusnya.
Ternyata memang harus di trace dengan tanggal berjalan dan dicek apakah
hari ini masih ada sisa hari kerja atau tidak (kolom J)

Saya masih belum berpikir ke array, ini sudah cukup untuk komputasi saya
Sekali lagi terima kasih

Susilo

Pada 12 Februari 2016 16.11, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com> menulis:

>
>
> Hai Susilo,
>
> File terlampir menggunakan 1 (satu) tabel bantu sebagai sarana untuk
> memudahkan penelusuran alur komputasi.
> Data referensi yang dibutuhkan adalah daftar hari libur nasional. Pada
> file terlampir, daftar hari libur nasional membentuk 1 (satu) tabel
> referensi. Formula yang ada di area report maupun summary bisa diubah
> menjadi sebuah array formula tanpa tabel bantu. Silakan Anda coba untuk
> mengubahnya menjadi array formula bila kurang berkenan dengan kehadiran
> tabel bantu.
>
> Untuk kasus data seperti report yang berisi data dalam rentang 10 tahun
> (pada file terlampir, area report baru berisi data dalam rentang 1 bulan),
> tabel bantu yang disusun untuk memenuhi kebutuhan rentang 10 tahun
> (maksimal 10 * 366 = 3660 baris) masih sangat cepat dikomputasi oleh Excel.
>
> Wassalam,
> Kid
>
>
>
> 2016-02-12 14:00 GMT+07:00 Susilo - susilo.ib@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>>
>>
>> Dear rekan-rekan
>>
>> Berikut saya punya hitungan hari kerja, sisa hari kerja. Saya menggunakan
>> sisa hari kerja sebagai pembagi untuk target produksi harian.
>>
>> sebenarnya rumusannya mudah namun hitungan saya masih salah secara logika
>> harian. File berikut untuk memperjelas permasalahan saya
>>
>> Mohon bantuannya
>>
>> Terima kasih
>> Susilo
>>
>>
>
>

Fri Feb 12, 2016 7:21 pm (PST) . Posted by:

idz.iman

Dear Suhu,


Assalammualaikum,
selamat Pagi !


Suhu, saya ada kendala nih, mohon bantuannya.
saya ingin paste data grafik namun tidak bisa (ada notif seperti terlampir)


mohon bantuannya.


salam
Iman DZ




Fri Feb 12, 2016 8:36 pm (PST) . Posted by:

"odong nando"

yoo eko / mona ,
terlampir file yg bisa di pelajari lebih lanjut br,

odong nando


Pada Jumat, 12 Februari 2016 16:15, "Septian Eko Saputro monnalissa0809@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  dear master

mohon bantuan untuk dapat memberikan solusi dari permasalahan berikut (terlampir), asumsi inputan random, apa rumus yang harsu dimasukkan atau kah harus dengan tambahan bantuan sheet untuk dapat mendapatkan kode tersebut, (kode diharapkan seperti yang adaa di kolom blok kuning)

mohon pencerahannya

salam,
monnalissa0809
#yiv0334469827 #yiv0334469827 -- #yiv0334469827ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0334469827 #yiv0334469827ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0334469827 #yiv0334469827ygrp-mkp #yiv0334469827hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0334469827 #yiv0334469827ygrp-mkp #yiv0334469827ads {margin-bottom:10px;}#yiv0334469827 #yiv0334469827ygrp-mkp .yiv0334469827ad {padding:0 0;}#yiv0334469827 #yiv0334469827ygrp-mkp .yiv0334469827ad p {margin:0;}#yiv0334469827 #yiv0334469827ygrp-mkp .yiv0334469827ad a {color:#0000ff;text-decoration:none;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ygrp-lc {font-family:Arial;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ygrp-lc #yiv0334469827hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ygrp-lc .yiv0334469827ad {margin-bottom:10px;padding:0 0;}#yiv0334469827 #yiv0334469827actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0334469827 #yiv0334469827activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0334469827 #yiv0334469827activity span {font-weight:700;}#yiv0334469827 #yiv0334469827activity span:first-child {text-transform:uppercase;}#yiv0334469827 #yiv0334469827activity span a {color:#5085b6;text-decoration:none;}#yiv0334469827 #yiv0334469827activity span span {color:#ff7900;}#yiv0334469827 #yiv0334469827activity span .yiv0334469827underline {text-decoration:underline;}#yiv0334469827 .yiv0334469827attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0334469827 .yiv0334469827attach div a {text-decoration:none;}#yiv0334469827 .yiv0334469827attach img {border:none;padding-right:5px;}#yiv0334469827 .yiv0334469827attach label {display:block;margin-bottom:5px;}#yiv0334469827 .yiv0334469827attach label a {text-decoration:none;}#yiv0334469827 blockquote {margin:0 0 0 4px;}#yiv0334469827 .yiv0334469827bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0334469827 .yiv0334469827bold a {text-decoration:none;}#yiv0334469827 dd.yiv0334469827last p a {font-family:Verdana;font-weight:700;}#yiv0334469827 dd.yiv0334469827last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0334469827 dd.yiv0334469827last p span.yiv0334469827yshortcuts {margin-right:0;}#yiv0334469827 div.yiv0334469827attach-table div div a {text-decoration:none;}#yiv0334469827 div.yiv0334469827attach-table {width:400px;}#yiv0334469827 div.yiv0334469827file-title a, #yiv0334469827 div.yiv0334469827file-title a:active, #yiv0334469827 div.yiv0334469827file-title a:hover, #yiv0334469827 div.yiv0334469827file-title a:visited {text-decoration:none;}#yiv0334469827 div.yiv0334469827photo-title a, #yiv0334469827 div.yiv0334469827photo-title a:active, #yiv0334469827 div.yiv0334469827photo-title a:hover, #yiv0334469827 div.yiv0334469827photo-title a:visited {text-decoration:none;}#yiv0334469827 div#yiv0334469827ygrp-mlmsg #yiv0334469827ygrp-msg p a span.yiv0334469827yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0334469827 .yiv0334469827green {color:#628c2a;}#yiv0334469827 .yiv0334469827MsoNormal {margin:0 0 0 0;}#yiv0334469827 o {font-size:0;}#yiv0334469827 #yiv0334469827photos div {float:left;width:72px;}#yiv0334469827 #yiv0334469827photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0334469827 #yiv0334469827photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0334469827 #yiv0334469827reco-category {font-size:77%;}#yiv0334469827 #yiv0334469827reco-desc {font-size:77%;}#yiv0334469827 .yiv0334469827replbq {margin:4px;}#yiv0334469827 #yiv0334469827ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0334469827 #yiv0334469827ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0334469827 #yiv0334469827ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0334469827 #yiv0334469827ygrp-mlmsg select, #yiv0334469827 input, #yiv0334469827 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0334469827 #yiv0334469827ygrp-mlmsg pre, #yiv0334469827 code {font:115% monospace;}#yiv0334469827 #yiv0334469827ygrp-mlmsg * {line-height:1.22em;}#yiv0334469827 #yiv0334469827ygrp-mlmsg #yiv0334469827logo {padding-bottom:10px;}#yiv0334469827 #yiv0334469827ygrp-msg p a {font-family:Verdana;}#yiv0334469827 #yiv0334469827ygrp-msg p#yiv0334469827attach-count span {color:#1E66AE;font-weight:700;}#yiv0334469827 #yiv0334469827ygrp-reco #yiv0334469827reco-head {color:#ff7900;font-weight:700;}#yiv0334469827 #yiv0334469827ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ov li a {font-size:130%;text-decoration:none;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0334469827 #yiv0334469827ygrp-sponsor #yiv0334469827ov ul {margin:0;padding:0 0 0 8px;}#yiv0334469827 #yiv0334469827ygrp-text {font-family:Georgia;}#yiv0334469827 #yiv0334469827ygrp-text p {margin:0 0 1em 0;}#yiv0334469827 #yiv0334469827ygrp-text tt {font-size:120%;}#yiv0334469827 #yiv0334469827ygrp-vital ul li:last-child {border-right:none !important;}#yiv0334469827

============================================================
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