Dear Toni,
Terus terang saya masih gagal paham dari case anda.begini aja, coba kamu buat 
simulasi terlebih dahulu dari case yang ada tanpa ada formula apapun, artinya 
apa yang ingin kamu inginkan,contoh misalnya, jika A maka akan....., jika B 
maka akan.... dst.....kalau bisa jangan menggunakan kata2 yang "bolak-balik" 
biar mudah untuk memahaminya.Mungkin teman2 yang lain bisa membantu dari case 
anda ini.
TerimaKasih. 

    Pada Minggu, 13 November 2016 15:22, "toni jalamento 
[email protected] [belajar-excel]" <[email protected]> 
menulis:
 

     Dear All, Mohon bantuannya, untuk persoalan seperti pada file yang 
terlampir,terima kash.

Salam,
Toni---------- Pesan terusan ----------
Dari: "toni jalamento" <[email protected]>
Tanggal: 13 Nov 2016 13:04
Subjek: 
Kepada: <[email protected]>
Cc: 

Dear All, Mohon bantuannya, untuk persoalan seperti pada file yang 
terlampir,terima kash.

Salam,
Toni
  #yiv0343412291 #yiv0343412291 -- #yiv0343412291ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0343412291 
#yiv0343412291ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0343412291 
#yiv0343412291ygrp-mkp #yiv0343412291hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0343412291 #yiv0343412291ygrp-mkp #yiv0343412291ads 
{margin-bottom:10px;}#yiv0343412291 #yiv0343412291ygrp-mkp .yiv0343412291ad 
{padding:0 0;}#yiv0343412291 #yiv0343412291ygrp-mkp .yiv0343412291ad p 
{margin:0;}#yiv0343412291 #yiv0343412291ygrp-mkp .yiv0343412291ad a 
{color:#0000ff;text-decoration:none;}#yiv0343412291 #yiv0343412291ygrp-sponsor 
#yiv0343412291ygrp-lc {font-family:Arial;}#yiv0343412291 
#yiv0343412291ygrp-sponsor #yiv0343412291ygrp-lc #yiv0343412291hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0343412291 
#yiv0343412291ygrp-sponsor #yiv0343412291ygrp-lc .yiv0343412291ad 
{margin-bottom:10px;padding:0 0;}#yiv0343412291 #yiv0343412291actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0343412291 
#yiv0343412291activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0343412291
 #yiv0343412291activity span {font-weight:700;}#yiv0343412291 
#yiv0343412291activity span:first-child 
{text-transform:uppercase;}#yiv0343412291 #yiv0343412291activity span a 
{color:#5085b6;text-decoration:none;}#yiv0343412291 #yiv0343412291activity span 
span {color:#ff7900;}#yiv0343412291 #yiv0343412291activity span 
.yiv0343412291underline {text-decoration:underline;}#yiv0343412291 
.yiv0343412291attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0343412291 .yiv0343412291attach div a 
{text-decoration:none;}#yiv0343412291 .yiv0343412291attach img 
{border:none;padding-right:5px;}#yiv0343412291 .yiv0343412291attach label 
{display:block;margin-bottom:5px;}#yiv0343412291 .yiv0343412291attach label a 
{text-decoration:none;}#yiv0343412291 blockquote {margin:0 0 0 
4px;}#yiv0343412291 .yiv0343412291bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0343412291 
.yiv0343412291bold a {text-decoration:none;}#yiv0343412291 dd.yiv0343412291last 
p a {font-family:Verdana;font-weight:700;}#yiv0343412291 dd.yiv0343412291last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0343412291 
dd.yiv0343412291last p span.yiv0343412291yshortcuts 
{margin-right:0;}#yiv0343412291 div.yiv0343412291attach-table div div a 
{text-decoration:none;}#yiv0343412291 div.yiv0343412291attach-table 
{width:400px;}#yiv0343412291 div.yiv0343412291file-title a, #yiv0343412291 
div.yiv0343412291file-title a:active, #yiv0343412291 
div.yiv0343412291file-title a:hover, #yiv0343412291 div.yiv0343412291file-title 
a:visited {text-decoration:none;}#yiv0343412291 div.yiv0343412291photo-title a, 
#yiv0343412291 div.yiv0343412291photo-title a:active, #yiv0343412291 
div.yiv0343412291photo-title a:hover, #yiv0343412291 
div.yiv0343412291photo-title a:visited {text-decoration:none;}#yiv0343412291 
div#yiv0343412291ygrp-mlmsg #yiv0343412291ygrp-msg p a 
span.yiv0343412291yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0343412291 
.yiv0343412291green {color:#628c2a;}#yiv0343412291 .yiv0343412291MsoNormal 
{margin:0 0 0 0;}#yiv0343412291 o {font-size:0;}#yiv0343412291 
#yiv0343412291photos div {float:left;width:72px;}#yiv0343412291 
#yiv0343412291photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv0343412291 
#yiv0343412291photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0343412291
 #yiv0343412291reco-category {font-size:77%;}#yiv0343412291 
#yiv0343412291reco-desc {font-size:77%;}#yiv0343412291 .yiv0343412291replbq 
{margin:4px;}#yiv0343412291 #yiv0343412291ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0343412291 #yiv0343412291ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0343412291 
#yiv0343412291ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0343412291 
#yiv0343412291ygrp-mlmsg select, #yiv0343412291 input, #yiv0343412291 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0343412291 
#yiv0343412291ygrp-mlmsg pre, #yiv0343412291 code {font:115% 
monospace;}#yiv0343412291 #yiv0343412291ygrp-mlmsg * 
{line-height:1.22em;}#yiv0343412291 #yiv0343412291ygrp-mlmsg #yiv0343412291logo 
{padding-bottom:10px;}#yiv0343412291 #yiv0343412291ygrp-msg p a 
{font-family:Verdana;}#yiv0343412291 #yiv0343412291ygrp-msg 
p#yiv0343412291attach-count span {color:#1E66AE;font-weight:700;}#yiv0343412291 
#yiv0343412291ygrp-reco #yiv0343412291reco-head 
{color:#ff7900;font-weight:700;}#yiv0343412291 #yiv0343412291ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0343412291 #yiv0343412291ygrp-sponsor 
#yiv0343412291ov li a {font-size:130%;text-decoration:none;}#yiv0343412291 
#yiv0343412291ygrp-sponsor #yiv0343412291ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0343412291 
#yiv0343412291ygrp-sponsor #yiv0343412291ov ul {margin:0;padding:0 0 0 
8px;}#yiv0343412291 #yiv0343412291ygrp-text 
{font-family:Georgia;}#yiv0343412291 #yiv0343412291ygrp-text p {margin:0 0 1em 
0;}#yiv0343412291 #yiv0343412291ygrp-text tt {font-size:120%;}#yiv0343412291 
#yiv0343412291ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0343412291 

   

Kirim email ke