terima kasih sebelumnya pak Susilo atas perhatian dan responnya..tapi untuk
menyesuaikan dengan bulan laporan yang dipilih kayaknya masih belum bisa
pak..misalnya untuk laporan bulan Juni s.d Agustus ..siapa2 saja dan jumlah
pembayarannya berapa...terima kasih..
On Thursday, October 6, 2016 9:33 AM, "Susilo - [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Adrian
File berikut semoga bisa membantu
Terima kasihSusilo
Pada 5 Oktober 2016 10.25, adrian piter [email protected] [belajar-excel]
<[email protected]> menulis:
Dear para Master Excel,
saya mohon bantuan bagaimana membuat formula excel untuk buat laporan tentang
jumlah pembayarn dan nama-nama pembayar sesuai bulan laporan yang dipilih.
Untuk lebih jelasnya bisa dilihat di aatachment
Terima kasih atas perhatian dan bantuannya.
#yiv3877390035 #yiv3877390035 -- #yiv3877390035ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3877390035
#yiv3877390035ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3877390035
#yiv3877390035ygrp-mkp #yiv3877390035hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3877390035 #yiv3877390035ygrp-mkp #yiv3877390035ads
{margin-bottom:10px;}#yiv3877390035 #yiv3877390035ygrp-mkp .yiv3877390035ad
{padding:0 0;}#yiv3877390035 #yiv3877390035ygrp-mkp .yiv3877390035ad p
{margin:0;}#yiv3877390035 #yiv3877390035ygrp-mkp .yiv3877390035ad a
{color:#0000ff;text-decoration:none;}#yiv3877390035 #yiv3877390035ygrp-sponsor
#yiv3877390035ygrp-lc {font-family:Arial;}#yiv3877390035
#yiv3877390035ygrp-sponsor #yiv3877390035ygrp-lc #yiv3877390035hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3877390035
#yiv3877390035ygrp-sponsor #yiv3877390035ygrp-lc .yiv3877390035ad
{margin-bottom:10px;padding:0 0;}#yiv3877390035 #yiv3877390035actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3877390035
#yiv3877390035activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3877390035
#yiv3877390035activity span {font-weight:700;}#yiv3877390035
#yiv3877390035activity span:first-child
{text-transform:uppercase;}#yiv3877390035 #yiv3877390035activity span a
{color:#5085b6;text-decoration:none;}#yiv3877390035 #yiv3877390035activity span
span {color:#ff7900;}#yiv3877390035 #yiv3877390035activity span
.yiv3877390035underline {text-decoration:underline;}#yiv3877390035
.yiv3877390035attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3877390035 .yiv3877390035attach div a
{text-decoration:none;}#yiv3877390035 .yiv3877390035attach img
{border:none;padding-right:5px;}#yiv3877390035 .yiv3877390035attach label
{display:block;margin-bottom:5px;}#yiv3877390035 .yiv3877390035attach label a
{text-decoration:none;}#yiv3877390035 blockquote {margin:0 0 0
4px;}#yiv3877390035 .yiv3877390035bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3877390035
.yiv3877390035bold a {text-decoration:none;}#yiv3877390035 dd.yiv3877390035last
p a {font-family:Verdana;font-weight:700;}#yiv3877390035 dd.yiv3877390035last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3877390035
dd.yiv3877390035last p span.yiv3877390035yshortcuts
{margin-right:0;}#yiv3877390035 div.yiv3877390035attach-table div div a
{text-decoration:none;}#yiv3877390035 div.yiv3877390035attach-table
{width:400px;}#yiv3877390035 div.yiv3877390035file-title a, #yiv3877390035
div.yiv3877390035file-title a:active, #yiv3877390035
div.yiv3877390035file-title a:hover, #yiv3877390035 div.yiv3877390035file-title
a:visited {text-decoration:none;}#yiv3877390035 div.yiv3877390035photo-title a,
#yiv3877390035 div.yiv3877390035photo-title a:active, #yiv3877390035
div.yiv3877390035photo-title a:hover, #yiv3877390035
div.yiv3877390035photo-title a:visited {text-decoration:none;}#yiv3877390035
div#yiv3877390035ygrp-mlmsg #yiv3877390035ygrp-msg p a
span.yiv3877390035yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3877390035
.yiv3877390035green {color:#628c2a;}#yiv3877390035 .yiv3877390035MsoNormal
{margin:0 0 0 0;}#yiv3877390035 o {font-size:0;}#yiv3877390035
#yiv3877390035photos div {float:left;width:72px;}#yiv3877390035
#yiv3877390035photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3877390035
#yiv3877390035photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3877390035
#yiv3877390035reco-category {font-size:77%;}#yiv3877390035
#yiv3877390035reco-desc {font-size:77%;}#yiv3877390035 .yiv3877390035replbq
{margin:4px;}#yiv3877390035 #yiv3877390035ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3877390035 #yiv3877390035ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3877390035
#yiv3877390035ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3877390035
#yiv3877390035ygrp-mlmsg select, #yiv3877390035 input, #yiv3877390035 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3877390035
#yiv3877390035ygrp-mlmsg pre, #yiv3877390035 code {font:115%
monospace;}#yiv3877390035 #yiv3877390035ygrp-mlmsg *
{line-height:1.22em;}#yiv3877390035 #yiv3877390035ygrp-mlmsg #yiv3877390035logo
{padding-bottom:10px;}#yiv3877390035 #yiv3877390035ygrp-msg p a
{font-family:Verdana;}#yiv3877390035 #yiv3877390035ygrp-msg
p#yiv3877390035attach-count span {color:#1E66AE;font-weight:700;}#yiv3877390035
#yiv3877390035ygrp-reco #yiv3877390035reco-head
{color:#ff7900;font-weight:700;}#yiv3877390035 #yiv3877390035ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3877390035 #yiv3877390035ygrp-sponsor
#yiv3877390035ov li a {font-size:130%;text-decoration:none;}#yiv3877390035
#yiv3877390035ygrp-sponsor #yiv3877390035ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3877390035
#yiv3877390035ygrp-sponsor #yiv3877390035ov ul {margin:0;padding:0 0 0
8px;}#yiv3877390035 #yiv3877390035ygrp-text
{font-family:Georgia;}#yiv3877390035 #yiv3877390035ygrp-text p {margin:0 0 1em
0;}#yiv3877390035 #yiv3877390035ygrp-text tt {font-size:120%;}#yiv3877390035
#yiv3877390035ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3877390035
