Re: [belajar-excel] Remove duplikat sesuai tanggal

Rudi Anto [email protected] [belajar-excel] Tue, 10 Feb 2015 11:10:26 -0800

Terima kasih respon dan sarannya master,
berhubung output reportnya dah baku, kayaknya saya kepingin yang pakai formula.
mungkin ada yang lebih simple pakai formula.



++Rudi


--------------------------------------------
On Tue, 2/10/15, 'Heri Pamungkas ( Gmail )' [email protected] 
[belajar-excel] <[email protected]> wrote:


 Subject: Re: [belajar-excel] Remove duplikat sesuai tanggal
 To: [email protected]
 Date: Tuesday, February 10, 2015, 7:43 AM


  








   





       السَّلَامُ
 عَلَيْكُمْ وَرَحْمَةُ اللهِ
 وَبَرَكَاتُهُ
 Semangat pagi,.

 Hehehe, kalo cara Pake Hemat nya saya lebih menyarankan
 menggunakan Pivot. Mudah, Jelas dan Cepat.



 وَالسَّلَامُ عَلَيْكُمْ
 وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ

 Warm Regards,
       On 09/02/2015 17:43, Rudi Anto [email protected]
       [belajar-excel] wrote:



  



             Dear suhu belajar Excel,

              

               Wah dah lama ga nanya nih, cuman ngikuti di
               nabble.belajarexcel,

               hari ini saya punya sedikit kesulitan mengenai
 kasus
               report yang ingin saya tampilkan

               datanya, dimana data tidak boleh
 ganda/duplikat ketika
               saya tampilkan sesuai tanggal.

               mungkin contoh attachment bisa sedikit
 memberikan
               permasalahan yang saya hadapi.


               Sebelumnya saya ucapkan banyak terima
 kasih,karena milis

               ini sangat membantu pekerjaan saya.



               Salam,

               Rudi Anto


     
















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

 #yiv2885385793 #yiv2885385793ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv2885385793 #yiv2885385793ygrp-mkp #yiv2885385793hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv2885385793 #yiv2885385793ygrp-mkp #yiv2885385793ads {
 margin-bottom:10px;}

 #yiv2885385793 #yiv2885385793ygrp-mkp .yiv2885385793ad {
 padding:0 0;}

 #yiv2885385793 #yiv2885385793ygrp-mkp .yiv2885385793ad p {
 margin:0;}

 #yiv2885385793 #yiv2885385793ygrp-mkp .yiv2885385793ad a {
 color:#0000ff;text-decoration:none;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor
 #yiv2885385793ygrp-lc {
 font-family:Arial;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor
 #yiv2885385793ygrp-lc #yiv2885385793hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor
 #yiv2885385793ygrp-lc .yiv2885385793ad {
 margin-bottom:10px;padding:0 0;}

 #yiv2885385793 #yiv2885385793actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

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

 #yiv2885385793 #yiv2885385793activity span {
 font-weight:700;}

 #yiv2885385793 #yiv2885385793activity span:first-child {
 text-transform:uppercase;}

 #yiv2885385793 #yiv2885385793activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv2885385793 #yiv2885385793activity span span {
 color:#ff7900;}

 #yiv2885385793 #yiv2885385793activity span
 .yiv2885385793underline {

 text-decoration:underline;}

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

 #yiv2885385793 .yiv2885385793attach div a {
 text-decoration:none;}

 #yiv2885385793 .yiv2885385793attach img {
 border:none;padding-right:5px;}

 #yiv2885385793 .yiv2885385793attach label {
 display:block;margin-bottom:5px;}

 #yiv2885385793 .yiv2885385793attach label a {
 text-decoration:none;}

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

 #yiv2885385793 .yiv2885385793bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv2885385793 .yiv2885385793bold a {
 text-decoration:none;}

 #yiv2885385793 dd.yiv2885385793last p a {
 font-family:Verdana;font-weight:700;}

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

 #yiv2885385793 dd.yiv2885385793last p

 span.yiv2885385793yshortcuts {
 margin-right:0;}

 #yiv2885385793 div.yiv2885385793attach-table div div a {
 text-decoration:none;}

 #yiv2885385793 div.yiv2885385793attach-table {
 width:400px;}

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

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


 #yiv2885385793 div#yiv2885385793ygrp-mlmsg
 #yiv2885385793ygrp-msg p a span.yiv2885385793yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv2885385793 .yiv2885385793green {
 color:#628c2a;}

 #yiv2885385793 .yiv2885385793MsoNormal {
 margin:0 0 0 0;}

 #yiv2885385793 o {
 font-size:0;}

 #yiv2885385793 #yiv2885385793photos div {
 float:left;width:72px;}

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

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

 #yiv2885385793 #yiv2885385793reco-category {
 font-size:77%;}

 #yiv2885385793 #yiv2885385793reco-desc {
 font-size:77%;}

 #yiv2885385793 .yiv2885385793replbq {
 margin:4px;}

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

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

 #yiv2885385793 #yiv2885385793ygrp-mlmsg table {
 font-size:inherit;font:100%;}

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

 #yiv2885385793 #yiv2885385793ygrp-mlmsg pre, #yiv2885385793
 code {
 font:115% monospace;}

 #yiv2885385793 #yiv2885385793ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv2885385793 #yiv2885385793ygrp-mlmsg #yiv2885385793logo {
 padding-bottom:10px;}


 #yiv2885385793 #yiv2885385793ygrp-msg p a {
 font-family:Verdana;}

 #yiv2885385793 #yiv2885385793ygrp-msg
 p#yiv2885385793attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv2885385793 #yiv2885385793ygrp-reco
 #yiv2885385793reco-head {
 color:#ff7900;font-weight:700;}

 #yiv2885385793 #yiv2885385793ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor #yiv2885385793ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor #yiv2885385793ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv2885385793 #yiv2885385793ygrp-sponsor #yiv2885385793ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv2885385793 #yiv2885385793ygrp-text {
 font-family:Georgia;}

 #yiv2885385793 #yiv2885385793ygrp-text p {
 margin:0 0 1em 0;}

 #yiv2885385793 #yiv2885385793ygrp-text tt {
 font-size:120%;}

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

Re: [belajar-excel] Remove duplikat sesuai tanggal

Kirim email ke