Bls: [belajar-excel] Help Formula filter [1 Attachment]

Toby kenzo [email protected] [belajar-excel] Thu, 03 Mar 2016 09:13:46 -0800

Hai Ahmad,

Data dengan tabel Horisontal memang kelihatan "Bagus", tap jika untuk 
pengelolahan data akan sulit jadinya, alangkah baiknya jika masih dalam 
pengelolahan data gunakan tabal vertical, jika sudah merupakan Result/Summary 
data bisa menggunakan tabal dalam bentuk Horisontal.


Berikut contoh dari case yang anda hadapi, di sini saya ubah menjadi tabel 
Vertical untuk memudahkan dalam pengelolahan datanya.


TerimaKasih.



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

 Judul: Bls: [belajar-excel] Help Formula filter [1 Attachment]
 Kepada: [email protected]
 Tanggal: Kamis, 3 Maret, 2016, 5:01 PM
 
 
  
 
 
 
   
 
 
     
       
       
       terima
 kasih atas responnya bro...
 terlampir
 file yang sudah di create ulang.
 atas
 bantuannya terima kasih Regard,Ahmad
 H 
 
 
    Pada Kamis, 3 Maret
 2016 14:44, "Toby kenzo [email protected]
 [belajar-excel]" <[email protected]>
 menulis:
   
 
  
  
 
 
 
 
 
   
 
 
 
 
     
       
       
       
 
 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 
 
 
 
 
     
      
 
 
     
     
 
 
 
 
 
 
   
   
 
     
      
 
     
     
 
 
 
 #yiv3968333443 #yiv3968333443 --
   #yiv3968333443ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp #yiv3968333443ads {
 margin-bottom:10px;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad {
 padding:0 0;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad p {
 margin:0;}
 
 #yiv3968333443 #yiv3968333443ygrp-mkp .yiv3968333443ad a {
 color:#0000ff;text-decoration:none;}
 #yiv3968333443 #yiv3968333443ygrp-sponsor
 #yiv3968333443ygrp-lc {
 font-family:Arial;}
 
 #yiv3968333443 #yiv3968333443ygrp-sponsor
 #yiv3968333443ygrp-lc #yiv3968333443hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv3968333443 #yiv3968333443ygrp-sponsor
 #yiv3968333443ygrp-lc .yiv3968333443ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv3968333443 #yiv3968333443actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv3968333443 #yiv3968333443activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv3968333443 #yiv3968333443activity span {
 font-weight:700;}
 
 #yiv3968333443 #yiv3968333443activity span:first-child {
 text-transform:uppercase;}
 
 #yiv3968333443 #yiv3968333443activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv3968333443 #yiv3968333443activity span span {
 color:#ff7900;}
 
 #yiv3968333443 #yiv3968333443activity span
 .yiv3968333443underline {
 text-decoration:underline;}
 
 #yiv3968333443 .yiv3968333443attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv3968333443 .yiv3968333443attach div a {
 text-decoration:none;}
 
 #yiv3968333443 .yiv3968333443attach img {
 border:none;padding-right:5px;}
 
 #yiv3968333443 .yiv3968333443attach label {
 display:block;margin-bottom:5px;}
 
 #yiv3968333443 .yiv3968333443attach label a {
 text-decoration:none;}
 
 #yiv3968333443 blockquote {
 margin:0 0 0 4px;}
 
 #yiv3968333443 .yiv3968333443bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv3968333443 .yiv3968333443bold a {
 text-decoration:none;}
 
 #yiv3968333443 dd.yiv3968333443last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv3968333443 dd.yiv3968333443last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv3968333443 dd.yiv3968333443last p
 span.yiv3968333443yshortcuts {
 margin-right:0;}
 
 #yiv3968333443 div.yiv3968333443attach-table div div a {
 text-decoration:none;}
 
 #yiv3968333443 div.yiv3968333443attach-table {
 width:400px;}
 
 #yiv3968333443 div.yiv3968333443file-title a, #yiv3968333443
 div.yiv3968333443file-title a:active, #yiv3968333443
 div.yiv3968333443file-title a:hover, #yiv3968333443
 div.yiv3968333443file-title a:visited {
 text-decoration:none;}
 
 #yiv3968333443 div.yiv3968333443photo-title a,
 #yiv3968333443 div.yiv3968333443photo-title a:active,
 #yiv3968333443 div.yiv3968333443photo-title a:hover,
 #yiv3968333443 div.yiv3968333443photo-title a:visited {
 text-decoration:none;}
 
 #yiv3968333443 div#yiv3968333443ygrp-mlmsg
 #yiv3968333443ygrp-msg p a span.yiv3968333443yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv3968333443 .yiv3968333443green {
 color:#628c2a;}
 
 #yiv3968333443 .yiv3968333443MsoNormal {
 margin:0 0 0 0;}
 
 #yiv3968333443 o {
 font-size:0;}
 
 #yiv3968333443 #yiv3968333443photos div {
 float:left;width:72px;}
 
 #yiv3968333443 #yiv3968333443photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv3968333443 #yiv3968333443photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv3968333443 #yiv3968333443reco-category {
 font-size:77%;}
 
 #yiv3968333443 #yiv3968333443reco-desc {
 font-size:77%;}
 
 #yiv3968333443 .yiv3968333443replbq {
 margin:4px;}
 
 #yiv3968333443 #yiv3968333443ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg select,
 #yiv3968333443 input, #yiv3968333443 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg pre, #yiv3968333443
 code {
 font:115% monospace;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv3968333443 #yiv3968333443ygrp-mlmsg #yiv3968333443logo {
 padding-bottom:10px;}
 
 
 #yiv3968333443 #yiv3968333443ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv3968333443 #yiv3968333443ygrp-msg
 p#yiv3968333443attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv3968333443 #yiv3968333443ygrp-reco
 #yiv3968333443reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv3968333443 #yiv3968333443ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv3968333443 #yiv3968333443ygrp-sponsor #yiv3968333443ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv3968333443 #yiv3968333443ygrp-text {
 font-family:Georgia;}
 
 #yiv3968333443 #yiv3968333443ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv3968333443 #yiv3968333443ygrp-text tt {
 font-size:120%;}
 
 #yiv3968333443 #yiv3968333443ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv3968333443

Ask Formula 2_toby.xlsx
Description: MS-Excel 2007 spreadsheet

Bls: [belajar-excel] Help Formula filter [1 Attachment]

Kirim email ke