Dear Pak Samsudin,
Mantab Pak., sepertinya formula ini sudah OK untuk saya terapkan di laporan
yang saya punya..
terima kasih banyak atas solusinya.. Regards,
Teguh
Pada Sabtu, 16 April 2016 17:51, "Samsudin Sam [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pak Teguh,
Sambil menunggu master yang lain dari saya hanya bisa seperti ini, dengan
menggunakan formula sumproduct.
hormat saya,Samsudin
Pada Sabtu, 16 April 2016 15:39, "teguh indrawanto
[email protected] [belajar-excel]" <[email protected]>
menulis:
Dear Pakar Excel,
Mohon pencerahannya untuk mengkombinasikan fungsi excel dengan tanggal.seperi
file terlampir.
Terima Kasih.... Regards,
Teguh
#yiv2650803773 #yiv2650803773 -- #yiv2650803773ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2650803773
#yiv2650803773ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2650803773
#yiv2650803773ygrp-mkp #yiv2650803773hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2650803773 #yiv2650803773ygrp-mkp #yiv2650803773ads
{margin-bottom:10px;}#yiv2650803773 #yiv2650803773ygrp-mkp .yiv2650803773ad
{padding:0 0;}#yiv2650803773 #yiv2650803773ygrp-mkp .yiv2650803773ad p
{margin:0;}#yiv2650803773 #yiv2650803773ygrp-mkp .yiv2650803773ad a
{color:#0000ff;text-decoration:none;}#yiv2650803773 #yiv2650803773ygrp-sponsor
#yiv2650803773ygrp-lc {font-family:Arial;}#yiv2650803773
#yiv2650803773ygrp-sponsor #yiv2650803773ygrp-lc #yiv2650803773hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2650803773
#yiv2650803773ygrp-sponsor #yiv2650803773ygrp-lc .yiv2650803773ad
{margin-bottom:10px;padding:0 0;}#yiv2650803773 #yiv2650803773actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2650803773
#yiv2650803773activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2650803773
#yiv2650803773activity span {font-weight:700;}#yiv2650803773
#yiv2650803773activity span:first-child
{text-transform:uppercase;}#yiv2650803773 #yiv2650803773activity span a
{color:#5085b6;text-decoration:none;}#yiv2650803773 #yiv2650803773activity span
span {color:#ff7900;}#yiv2650803773 #yiv2650803773activity span
.yiv2650803773underline {text-decoration:underline;}#yiv2650803773
.yiv2650803773attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2650803773 .yiv2650803773attach div a
{text-decoration:none;}#yiv2650803773 .yiv2650803773attach img
{border:none;padding-right:5px;}#yiv2650803773 .yiv2650803773attach label
{display:block;margin-bottom:5px;}#yiv2650803773 .yiv2650803773attach label a
{text-decoration:none;}#yiv2650803773 blockquote {margin:0 0 0
4px;}#yiv2650803773 .yiv2650803773bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2650803773
.yiv2650803773bold a {text-decoration:none;}#yiv2650803773 dd.yiv2650803773last
p a {font-family:Verdana;font-weight:700;}#yiv2650803773 dd.yiv2650803773last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2650803773
dd.yiv2650803773last p span.yiv2650803773yshortcuts
{margin-right:0;}#yiv2650803773 div.yiv2650803773attach-table div div a
{text-decoration:none;}#yiv2650803773 div.yiv2650803773attach-table
{width:400px;}#yiv2650803773 div.yiv2650803773file-title a, #yiv2650803773
div.yiv2650803773file-title a:active, #yiv2650803773
div.yiv2650803773file-title a:hover, #yiv2650803773 div.yiv2650803773file-title
a:visited {text-decoration:none;}#yiv2650803773 div.yiv2650803773photo-title a,
#yiv2650803773 div.yiv2650803773photo-title a:active, #yiv2650803773
div.yiv2650803773photo-title a:hover, #yiv2650803773
div.yiv2650803773photo-title a:visited {text-decoration:none;}#yiv2650803773
div#yiv2650803773ygrp-mlmsg #yiv2650803773ygrp-msg p a
span.yiv2650803773yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2650803773
.yiv2650803773green {color:#628c2a;}#yiv2650803773 .yiv2650803773MsoNormal
{margin:0 0 0 0;}#yiv2650803773 o {font-size:0;}#yiv2650803773
#yiv2650803773photos div {float:left;width:72px;}#yiv2650803773
#yiv2650803773photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2650803773
#yiv2650803773photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2650803773
#yiv2650803773reco-category {font-size:77%;}#yiv2650803773
#yiv2650803773reco-desc {font-size:77%;}#yiv2650803773 .yiv2650803773replbq
{margin:4px;}#yiv2650803773 #yiv2650803773ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2650803773 #yiv2650803773ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2650803773
#yiv2650803773ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2650803773
#yiv2650803773ygrp-mlmsg select, #yiv2650803773 input, #yiv2650803773 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2650803773
#yiv2650803773ygrp-mlmsg pre, #yiv2650803773 code {font:115%
monospace;}#yiv2650803773 #yiv2650803773ygrp-mlmsg *
{line-height:1.22em;}#yiv2650803773 #yiv2650803773ygrp-mlmsg #yiv2650803773logo
{padding-bottom:10px;}#yiv2650803773 #yiv2650803773ygrp-msg p a
{font-family:Verdana;}#yiv2650803773 #yiv2650803773ygrp-msg
p#yiv2650803773attach-count span {color:#1E66AE;font-weight:700;}#yiv2650803773
#yiv2650803773ygrp-reco #yiv2650803773reco-head
{color:#ff7900;font-weight:700;}#yiv2650803773 #yiv2650803773ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2650803773 #yiv2650803773ygrp-sponsor
#yiv2650803773ov li a {font-size:130%;text-decoration:none;}#yiv2650803773
#yiv2650803773ygrp-sponsor #yiv2650803773ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2650803773
#yiv2650803773ygrp-sponsor #yiv2650803773ov ul {margin:0;padding:0 0 0
8px;}#yiv2650803773 #yiv2650803773ygrp-text
{font-family:Georgia;}#yiv2650803773 #yiv2650803773ygrp-text p {margin:0 0 1em
0;}#yiv2650803773 #yiv2650803773ygrp-text tt {font-size:120%;}#yiv2650803773
#yiv2650803773ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2650803773
