hai kana,
ini saran saja, utk kedepannya mungkin bisa memperhalus lagi bahasa dalam email 
yang di tulis kemilis, jgn sampai ada tulisan yang "mendesak" utk di respon, 
saya pernah kok 1 bln lebih bertanya ke milis baru ada yang jawab...
oiya, balik lagi ke masalah yang di hadapi, coba di buatkan dulu / coba anda 
gabungkan dulu setiap tabel yang ada, dari tabel pembelian, penjualan, retur 
itu anda buatkan dulu menjadi 1 tabel...
mungkin setelah tabelnya di gabungkan, banyak yang merespon... br,

odong nando


      Dari: "[email protected] [belajar-excel]" 
<[email protected]>
 Kepada: [email protected] 
 Dikirim: Rabu, 21 Maret 2018 13:06
 Judul: [belajar-excel] Re: average cost/unit
   
    Kepada master semuanya,

Dengan ini saya lampirkan file excel saya yang sudah saya sederhanakan sehingga 
memudahkan untuk 
memahaminya. Mohon untuk membantu saya memecahkan masalah ini. Walaupun sampai 
sekarang belum
ada respon apapun dari para master excel.



Terima Kasih

Kana
   #yiv3156568442 #yiv3156568442 -- #yiv3156568442ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3156568442 
#yiv3156568442ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3156568442 
#yiv3156568442ygrp-mkp #yiv3156568442hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3156568442 #yiv3156568442ygrp-mkp #yiv3156568442ads 
{margin-bottom:10px;}#yiv3156568442 #yiv3156568442ygrp-mkp .yiv3156568442ad 
{padding:0 0;}#yiv3156568442 #yiv3156568442ygrp-mkp .yiv3156568442ad p 
{margin:0;}#yiv3156568442 #yiv3156568442ygrp-mkp .yiv3156568442ad a 
{color:#0000ff;text-decoration:none;}#yiv3156568442 #yiv3156568442ygrp-sponsor 
#yiv3156568442ygrp-lc {font-family:Arial;}#yiv3156568442 
#yiv3156568442ygrp-sponsor #yiv3156568442ygrp-lc #yiv3156568442hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3156568442 
#yiv3156568442ygrp-sponsor #yiv3156568442ygrp-lc .yiv3156568442ad 
{margin-bottom:10px;padding:0 0;}#yiv3156568442 #yiv3156568442actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3156568442 
#yiv3156568442activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3156568442
 #yiv3156568442activity span {font-weight:700;}#yiv3156568442 
#yiv3156568442activity span:first-child 
{text-transform:uppercase;}#yiv3156568442 #yiv3156568442activity span a 
{color:#5085b6;text-decoration:none;}#yiv3156568442 #yiv3156568442activity span 
span {color:#ff7900;}#yiv3156568442 #yiv3156568442activity span 
.yiv3156568442underline {text-decoration:underline;}#yiv3156568442 
.yiv3156568442attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3156568442 ..yiv3156568442attach div a 
{text-decoration:none;}#yiv3156568442 .yiv3156568442attach img 
{border:none;padding-right:5px;}#yiv3156568442 .yiv3156568442attach label 
{display:block;margin-bottom:5px;}#yiv3156568442 .yiv3156568442attach label a 
{text-decoration:none;}#yiv3156568442 blockquote {margin:0 0 0 
4px;}#yiv3156568442 .yiv3156568442bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3156568442 
.yiv3156568442bold a {text-decoration:none;}#yiv3156568442 dd.yiv3156568442last 
p a {font-family:Verdana;font-weight:700;}#yiv3156568442 dd.yiv3156568442last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3156568442 
dd.yiv3156568442last p span.yiv3156568442yshortcuts 
{margin-right:0;}#yiv3156568442 div.yiv3156568442attach-table div div a 
{text-decoration:none;}#yiv3156568442 div.yiv3156568442attach-table 
{width:400px;}#yiv3156568442 div.yiv3156568442file-title a, #yiv3156568442 
div.yiv3156568442file-title a:active, #yiv3156568442 
div.yiv3156568442file-title a:hover, #yiv3156568442 div.yiv3156568442file-title 
a:visited {text-decoration:none;}#yiv3156568442 div.yiv3156568442photo-title a, 
#yiv3156568442 div.yiv3156568442photo-title a:active, #yiv3156568442 
div.yiv3156568442photo-title a:hover, #yiv3156568442 
div.yiv3156568442photo-title a:visited {text-decoration:none;}#yiv3156568442 
div#yiv3156568442ygrp-mlmsg #yiv3156568442ygrp-msg p a 
span.yiv3156568442yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3156568442 
.yiv3156568442green {color:#628c2a;}#yiv3156568442 .yiv3156568442MsoNormal 
{margin:0 0 0 0;}#yiv3156568442 o {font-size:0;}#yiv3156568442 
#yiv3156568442photos div {float:left;width:72px;}#yiv3156568442 
#yiv3156568442photos div div {border:1px solid 
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3156568442 
#yiv3156568442photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3156568442
 #yiv3156568442reco-category {font-size:77%;}#yiv3156568442 
#yiv3156568442reco-desc {font-size:77%;}#yiv3156568442 .yiv3156568442replbq 
{margin:4px;}#yiv3156568442 #yiv3156568442ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3156568442 #yiv3156568442ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3156568442 
#yiv3156568442ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3156568442 
#yiv3156568442ygrp-mlmsg select, #yiv3156568442 input, #yiv3156568442 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3156568442 
#yiv3156568442ygrp-mlmsg pre, #yiv3156568442 code {font:115% 
monospace;}#yiv3156568442 #yiv3156568442ygrp-mlmsg * 
{line-height:1.22em;}#yiv3156568442 #yiv3156568442ygrp-mlmsg #yiv3156568442logo 
{padding-bottom:10px;}#yiv3156568442 #yiv3156568442ygrp-msg p a 
{font-family:Verdana;}#yiv3156568442 #yiv3156568442ygrp-msg 
p#yiv3156568442attach-count span {color:#1E66AE;font-weight:700;}#yiv3156568442 
#yiv3156568442ygrp-reco #yiv3156568442reco-head 
{color:#ff7900;font-weight:700;}#yiv3156568442 #yiv3156568442ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv3156568442 #yiv3156568442ygrp-sponsor 
#yiv3156568442ov li a {font-size:130%;text-decoration:none;}#yiv3156568442 
#yiv3156568442ygrp-sponsor #yiv3156568442ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3156568442 
#yiv3156568442ygrp-sponsor #yiv3156568442ov ul {margin:0;padding:0 0 0 
8px;}#yiv3156568442 #yiv3156568442ygrp-text 
{font-family:Georgia;}#yiv3156568442 #yiv3156568442ygrp-text p {margin:0 0 1em 
0;}#yiv3156568442 #yiv3156568442ygrp-text tt {font-size:120%;}#yiv3156568442 
#yiv3156568442ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv3156568442 

   

Kirim email ke