Re: [belajar-excel] 2 Kriteria dengan hasil lebih dari 1

Tue, 26 Jan 2016 20:08:31 -0800 

Dear Mr. Kid,


Terima kasih atas solusinya...sangat membantu sekali..


Salam,
Aris




--------------------------------------------
Pada Rab, 20/1/16, 'Mr. Kid' [email protected] [belajar-excel] 
<[email protected]> menulis:


 Judul: Re: [belajar-excel] 2 Kriteria dengan hasil lebih dari 1 [1 Attachment]
 Kepada: "BeExcel" <[email protected]>
 Tanggal: Rabu, 20 Januari, 2016, 4:52 PM


  








 
       Hai Aris,

 File terlampir
 menggunakan konsep array formula penyusun unique list (bisa
 dilihat disini).
 Array formula tersebut digunakan dalam
 kondisi tertentu (diletakkan di dalam IF).
 Kondisi tertentu yang dimaksud
 adalah ketika seluruh record dari sebuah item yang sama
 sudah termuat di output seluruhnya, barulah mengambil item
 berikutnya.

 Wassalam,
 Kid




 2016-01-20 11:35 GMT+07:00
 Aris Cumi [email protected]
 [belajar-excel] <[email protected]>:










 





  









       Salam excel,
 



 Mohon bantuannya suhu, saya lagi ada masalah dengan
 pekerjaan saya (file terlampir).



 Terima kasih.



 Salam

 Aris



 
























     




 #yiv1132309951 #yiv1132309951 --
   #yiv1132309951ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}

 #yiv1132309951 #yiv1132309951ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv1132309951 #yiv1132309951ygrp-mkp #yiv1132309951hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv1132309951 #yiv1132309951ygrp-mkp #yiv1132309951ads {
 margin-bottom:10px;}

 #yiv1132309951 #yiv1132309951ygrp-mkp .yiv1132309951ad {
 padding:0 0;}

 #yiv1132309951 #yiv1132309951ygrp-mkp .yiv1132309951ad p {
 margin:0;}

 #yiv1132309951 #yiv1132309951ygrp-mkp .yiv1132309951ad a {
 color:#0000ff;text-decoration:none;}
 #yiv1132309951 #yiv1132309951ygrp-sponsor
 #yiv1132309951ygrp-lc {
 font-family:Arial;}

 #yiv1132309951 #yiv1132309951ygrp-sponsor
 #yiv1132309951ygrp-lc #yiv1132309951hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv1132309951 #yiv1132309951ygrp-sponsor
 #yiv1132309951ygrp-lc .yiv1132309951ad {
 margin-bottom:10px;padding:0 0;}

 #yiv1132309951 #yiv1132309951actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

 #yiv1132309951 #yiv1132309951activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

 #yiv1132309951 #yiv1132309951activity span {
 font-weight:700;}

 #yiv1132309951 #yiv1132309951activity span:first-child {
 text-transform:uppercase;}

 #yiv1132309951 #yiv1132309951activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv1132309951 #yiv1132309951activity span span {
 color:#ff7900;}

 #yiv1132309951 #yiv1132309951activity span
 .yiv1132309951underline {
 text-decoration:underline;}

 #yiv1132309951 .yiv1132309951attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}

 #yiv1132309951 .yiv1132309951attach div a {
 text-decoration:none;}

 #yiv1132309951 .yiv1132309951attach img {
 border:none;padding-right:5px;}

 #yiv1132309951 .yiv1132309951attach label {
 display:block;margin-bottom:5px;}

 #yiv1132309951 .yiv1132309951attach label a {
 text-decoration:none;}

 #yiv1132309951 blockquote {
 margin:0 0 0 4px;}

 #yiv1132309951 .yiv1132309951bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv1132309951 .yiv1132309951bold a {
 text-decoration:none;}

 #yiv1132309951 dd.yiv1132309951last p a {
 font-family:Verdana;font-weight:700;}

 #yiv1132309951 dd.yiv1132309951last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}

 #yiv1132309951 dd.yiv1132309951last p
 span.yiv1132309951yshortcuts {
 margin-right:0;}

 #yiv1132309951 div.yiv1132309951attach-table div div a {
 text-decoration:none;}
 

 #yiv1132309951 div.yiv1132309951attach-table {
 width:400px;}

 #yiv1132309951 div.yiv1132309951file-title a, #yiv1132309951
 div.yiv1132309951file-title a:active, #yiv1132309951
 div.yiv1132309951file-title a:hover, #yiv1132309951
 div.yiv1132309951file-title a:visited {
 text-decoration:none;}

 #yiv1132309951 div.yiv1132309951photo-title a,
 #yiv1132309951 div.yiv1132309951photo-title a:active,
 #yiv1132309951 div.yiv1132309951photo-title a:hover,
 #yiv1132309951 div.yiv1132309951photo-title a:visited {
 text-decoration:none;}

 #yiv1132309951 div#yiv1132309951ygrp-mlmsg
 #yiv1132309951ygrp-msg p a span.yiv1132309951yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv1132309951 .yiv1132309951green {
 color:#628c2a;}

 #yiv1132309951 .yiv1132309951MsoNormal {
 margin:0 0 0 0;}

 #yiv1132309951 o {
 font-size:0;}

 #yiv1132309951 #yiv1132309951photos div {
 float:left;width:72px;}

 #yiv1132309951 #yiv1132309951photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}

 #yiv1132309951 #yiv1132309951photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

 #yiv1132309951 #yiv1132309951reco-category {
 font-size:77%;}

 #yiv1132309951 #yiv1132309951reco-desc {
 font-size:77%;}

 #yiv1132309951 .yiv1132309951replbq {
 margin:4px;}

 #yiv1132309951 #yiv1132309951ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg table {
 font-size:inherit;font:100%;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg select,
 #yiv1132309951 input, #yiv1132309951 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg pre, #yiv1132309951
 code {
 font:115% monospace;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv1132309951 #yiv1132309951ygrp-mlmsg #yiv1132309951logo {
 padding-bottom:10px;}


 #yiv1132309951 #yiv1132309951ygrp-msg p a {
 font-family:Verdana;}

 #yiv1132309951 #yiv1132309951ygrp-msg
 p#yiv1132309951attach-count span {
 color:#1E66AE;font-weight:700;}
 

 #yiv1132309951 #yiv1132309951ygrp-reco
 #yiv1132309951reco-head {
 color:#ff7900;font-weight:700;}

 #yiv1132309951 #yiv1132309951ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv1132309951 #yiv1132309951ygrp-sponsor #yiv1132309951ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv1132309951 #yiv1132309951ygrp-sponsor #yiv1132309951ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv1132309951 #yiv1132309951ygrp-sponsor #yiv1132309951ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv1132309951 #yiv1132309951ygrp-text {
 font-family:Georgia;}

 #yiv1132309951 #yiv1132309951ygrp-text p {
 margin:0 0 1em 0;}

 #yiv1132309951 #yiv1132309951ygrp-text tt {
 font-size:120%;}

 #yiv1132309951 #yiv1132309951ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv1132309951

Kirim email ke