Bls: [belajar-excel] Help Formula filter

Wed, 02 Mar 2016 23:45:03 -0800 

Hai Ahmad,

Mungkin file ynag anda kirimkan kebesaran sehingga tidak Nampak untuk di 
pelajari, coba di kirim ulang lagi filenya.

TerimaKasih.




Pada Kam, 3/3/16, Ahmad Habibillah [email protected] [belajar-excel] 
<[email protected]> menulis:

 Judul: [belajar-excel] Help Formula filter
 Kepada: [email protected]
 Tanggal: Kamis, 3 Maret, 2016, 2:22 PM
 
 
  
 
 
 
   
 
 
     
       
       
       Dear
 Para Master Excel,
 mohon
 bantuan formula excel, formula seperti sumifs atau filter
 atau vlookup, atau apapun itu yang dapat mengakomodir dari
 kebutuhan data terlampir.
 atas
 bantuaannya, terima kasih banyak regards,Ahmad H
 
 
 
     
      
 
     
     
 
 
 
 #yiv8635498531 #yiv8635498531 --
   #yiv8635498531ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp #yiv8635498531ads {
 margin-bottom:10px;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad {
 padding:0 0;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad p {
 margin:0;}
 
 #yiv8635498531 #yiv8635498531ygrp-mkp .yiv8635498531ad a {
 color:#0000ff;text-decoration:none;}
 #yiv8635498531 #yiv8635498531ygrp-sponsor
 #yiv8635498531ygrp-lc {
 font-family:Arial;}
 
 #yiv8635498531 #yiv8635498531ygrp-sponsor
 #yiv8635498531ygrp-lc #yiv8635498531hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv8635498531 #yiv8635498531ygrp-sponsor
 #yiv8635498531ygrp-lc .yiv8635498531ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv8635498531 #yiv8635498531actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv8635498531 #yiv8635498531activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv8635498531 #yiv8635498531activity span {
 font-weight:700;}
 
 #yiv8635498531 #yiv8635498531activity span:first-child {
 text-transform:uppercase;}
 
 #yiv8635498531 #yiv8635498531activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv8635498531 #yiv8635498531activity span span {
 color:#ff7900;}
 
 #yiv8635498531 #yiv8635498531activity span
 .yiv8635498531underline {
 text-decoration:underline;}
 
 #yiv8635498531 .yiv8635498531attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv8635498531 .yiv8635498531attach div a {
 text-decoration:none;}
 
 #yiv8635498531 .yiv8635498531attach img {
 border:none;padding-right:5px;}
 
 #yiv8635498531 .yiv8635498531attach label {
 display:block;margin-bottom:5px;}
 
 #yiv8635498531 .yiv8635498531attach label a {
 text-decoration:none;}
 
 #yiv8635498531 blockquote {
 margin:0 0 0 4px;}
 
 #yiv8635498531 .yiv8635498531bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv8635498531 .yiv8635498531bold a {
 text-decoration:none;}
 
 #yiv8635498531 dd.yiv8635498531last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv8635498531 dd.yiv8635498531last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv8635498531 dd.yiv8635498531last p
 span.yiv8635498531yshortcuts {
 margin-right:0;}
 
 #yiv8635498531 div.yiv8635498531attach-table div div a {
 text-decoration:none;}
 
 #yiv8635498531 div.yiv8635498531attach-table {
 width:400px;}
 
 #yiv8635498531 div.yiv8635498531file-title a, #yiv8635498531
 div.yiv8635498531file-title a:active, #yiv8635498531
 div.yiv8635498531file-title a:hover, #yiv8635498531
 div.yiv8635498531file-title a:visited {
 text-decoration:none;}
 
 #yiv8635498531 div.yiv8635498531photo-title a,
 #yiv8635498531 div.yiv8635498531photo-title a:active,
 #yiv8635498531 div.yiv8635498531photo-title a:hover,
 #yiv8635498531 div.yiv8635498531photo-title a:visited {
 text-decoration:none;}
 
 #yiv8635498531 div#yiv8635498531ygrp-mlmsg
 #yiv8635498531ygrp-msg p a span.yiv8635498531yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv8635498531 .yiv8635498531green {
 color:#628c2a;}
 
 #yiv8635498531 .yiv8635498531MsoNormal {
 margin:0 0 0 0;}
 
 #yiv8635498531 o {
 font-size:0;}
 
 #yiv8635498531 #yiv8635498531photos div {
 float:left;width:72px;}
 
 #yiv8635498531 #yiv8635498531photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv8635498531 #yiv8635498531photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv8635498531 #yiv8635498531reco-category {
 font-size:77%;}
 
 #yiv8635498531 #yiv8635498531reco-desc {
 font-size:77%;}
 
 #yiv8635498531 .yiv8635498531replbq {
 margin:4px;}
 
 #yiv8635498531 #yiv8635498531ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg select,
 #yiv8635498531 input, #yiv8635498531 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg pre, #yiv8635498531
 code {
 font:115% monospace;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv8635498531 #yiv8635498531ygrp-mlmsg #yiv8635498531logo {
 padding-bottom:10px;}
 
 
 #yiv8635498531 #yiv8635498531ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv8635498531 #yiv8635498531ygrp-msg
 p#yiv8635498531attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv8635498531 #yiv8635498531ygrp-reco
 #yiv8635498531reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv8635498531 #yiv8635498531ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv8635498531 #yiv8635498531ygrp-sponsor #yiv8635498531ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv8635498531 #yiv8635498531ygrp-sponsor #yiv8635498531ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv8635498531 #yiv8635498531ygrp-sponsor #yiv8635498531ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv8635498531 #yiv8635498531ygrp-text {
 font-family:Georgia;}
 
 #yiv8635498531 #yiv8635498531ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv8635498531 #yiv8635498531ygrp-text tt {
 font-size:120%;}
 
 #yiv8635498531 #yiv8635498531ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv8635498531

Kirim email ke