Dear Mr Kid.
Terima kasih atas tanggapannya, untuk case yang diberikan maka secara manual
semua invoice nomor 1-6 akan masuk dalam list, artinya semua faktur tersebut
memungkinkan untuk kombinasi nya. Selanjutnya untuk manual nya bisa di filter
lagi sesuai kode outlet, umur piutang, dll. Paling tidak dengan adanya rumus
bisa memperkecil kemungkinan kombinasi, untuk selanjutnya bisa di filter lagi
dengan parameter yang ada, karena pasti ada invoice yang nilai sama dan invoice
yang bisa masuk beberapa kombinasi seperti yang dicontohkan di atas. Trims
Pada Kamis, 19 Oktober 2017 13:51, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Sugandi,
Andai ada data seperti ini :
Inv tgl nilai
1 1 1000
2 2 2000
3 3 3000
4 4 4000
5 5 5000
6 6 6000
Lalu tanggal 9 ada rekening koran sebesar 10000 (10 ribu), secara manual dengan
cara Anda, hasilnya seperti apa ? Invoice nomor berapa saja ?
Regards,
Kid
2017-10-19 12:55 GMT+07:00 Sugandani Ajuniawan sugandani.g...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Dear PakCiLukman,
Sebelumnya terima kasih atas jawaban dan bantuannya, di perusahaan sudah
melakukan hal tersebut yang Bapak sarankan. Namun ada hal yang tidak bisa kami
kerjakan dluar kemampuan kami contohnya invoice ada ratusan ribu, untuk
mencocokkan satu persatu tidak mungkin & berita transferan di rekening koran
juga tidak ada, contohnya cuma "setoran tunai" dll, dan bank pun tidak bisa
kasih penjelasan itu dari daerah atau cabang mana kalau setoran kliring atau
setoran antar bank.
#yiv4783143559 #yiv4783143559 -- #yiv4783143559ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4783143559
#yiv4783143559ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4783143559
#yiv4783143559ygrp-mkp #yiv4783143559hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4783143559 #yiv4783143559ygrp-mkp #yiv4783143559ads
{margin-bottom:10px;}#yiv4783143559 #yiv4783143559ygrp-mkp .yiv4783143559ad
{padding:0 0;}#yiv4783143559 #yiv4783143559ygrp-mkp .yiv4783143559ad p
{margin:0;}#yiv4783143559 #yiv4783143559ygrp-mkp .yiv4783143559ad a
{color:#0000ff;text-decoration:none;}#yiv4783143559 #yiv4783143559ygrp-sponsor
#yiv4783143559ygrp-lc {font-family:Arial;}#yiv4783143559
#yiv4783143559ygrp-sponsor #yiv4783143559ygrp-lc #yiv4783143559hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4783143559
#yiv4783143559ygrp-sponsor #yiv4783143559ygrp-lc .yiv4783143559ad
{margin-bottom:10px;padding:0 0;}#yiv4783143559 #yiv4783143559actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4783143559
#yiv4783143559activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4783143559
#yiv4783143559activity span {font-weight:700;}#yiv4783143559
#yiv4783143559activity span:first-child
{text-transform:uppercase;}#yiv4783143559 #yiv4783143559activity span a
{color:#5085b6;text-decoration:none;}#yiv4783143559 #yiv4783143559activity span
span {color:#ff7900;}#yiv4783143559 #yiv4783143559activity span
.yiv4783143559underline {text-decoration:underline;}#yiv4783143559
.yiv4783143559attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4783143559 .yiv4783143559attach div a
{text-decoration:none;}#yiv4783143559 .yiv4783143559attach img
{border:none;padding-right:5px;}#yiv4783143559 .yiv4783143559attach label
{display:block;margin-bottom:5px;}#yiv4783143559 .yiv4783143559attach label a
{text-decoration:none;}#yiv4783143559 blockquote {margin:0 0 0
4px;}#yiv4783143559 .yiv4783143559bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4783143559
.yiv4783143559bold a {text-decoration:none;}#yiv4783143559 dd.yiv4783143559last
p a {font-family:Verdana;font-weight:700;}#yiv4783143559 dd.yiv4783143559last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4783143559
dd.yiv4783143559last p span.yiv4783143559yshortcuts
{margin-right:0;}#yiv4783143559 div.yiv4783143559attach-table div div a
{text-decoration:none;}#yiv4783143559 div.yiv4783143559attach-table
{width:400px;}#yiv4783143559 div.yiv4783143559file-title a, #yiv4783143559
div.yiv4783143559file-title a:active, #yiv4783143559
div.yiv4783143559file-title a:hover, #yiv4783143559 div.yiv4783143559file-title
a:visited {text-decoration:none;}#yiv4783143559 div.yiv4783143559photo-title a,
#yiv4783143559 div.yiv4783143559photo-title a:active, #yiv4783143559
div.yiv4783143559photo-title a:hover, #yiv4783143559
div.yiv4783143559photo-title a:visited {text-decoration:none;}#yiv4783143559
div#yiv4783143559ygrp-mlmsg #yiv4783143559ygrp-msg p a
span.yiv4783143559yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4783143559
.yiv4783143559green {color:#628c2a;}#yiv4783143559 .yiv4783143559MsoNormal
{margin:0 0 0 0;}#yiv4783143559 o {font-size:0;}#yiv4783143559
#yiv4783143559photos div {float:left;width:72px;}#yiv4783143559
#yiv4783143559photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv4783143559
#yiv4783143559photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4783143559
#yiv4783143559reco-category {font-size:77%;}#yiv4783143559
#yiv4783143559reco-desc {font-size:77%;}#yiv4783143559 .yiv4783143559replbq
{margin:4px;}#yiv4783143559 #yiv4783143559ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4783143559 #yiv4783143559ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4783143559
#yiv4783143559ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4783143559
#yiv4783143559ygrp-mlmsg select, #yiv4783143559 input, #yiv4783143559 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4783143559
#yiv4783143559ygrp-mlmsg pre, #yiv4783143559 code {font:115%
monospace;}#yiv4783143559 #yiv4783143559ygrp-mlmsg *
{line-height:1.22em;}#yiv4783143559 #yiv4783143559ygrp-mlmsg #yiv4783143559logo
{padding-bottom:10px;}#yiv4783143559 #yiv4783143559ygrp-msg p a
{font-family:Verdana;}#yiv4783143559 #yiv4783143559ygrp-msg
p#yiv4783143559attach-count span {color:#1E66AE;font-weight:700;}#yiv4783143559
#yiv4783143559ygrp-reco #yiv4783143559reco-head
{color:#ff7900;font-weight:700;}#yiv4783143559 #yiv4783143559ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4783143559 #yiv4783143559ygrp-sponsor
#yiv4783143559ov li a {font-size:130%;text-decoration:none;}#yiv4783143559
#yiv4783143559ygrp-sponsor #yiv4783143559ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4783143559
#yiv4783143559ygrp-sponsor #yiv4783143559ov ul {margin:0;padding:0 0 0
8px;}#yiv4783143559 #yiv4783143559ygrp-text
{font-family:Georgia;}#yiv4783143559 #yiv4783143559ygrp-text p {margin:0 0 1em
0;}#yiv4783143559 #yiv4783143559ygrp-text tt {font-size:120%;}#yiv4783143559
#yiv4783143559ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4783143559
