Re: [belajar-excel] Remove duplikat sesuai tanggal

Mon, 09 Feb 2015 09:07:42 -0800 

Thanks om Toby responnya,
untuk sementara pakai formula dulu,
monggo bisa dibahas sama-sama.
mungkin ada yang lebih singkat.


Salam,
Rudi Anto




--------------------------------------------
On Mon, 2/9/15, Toby kenzo [email protected] [belajar-excel] 
<[email protected]> wrote:


 Subject: Re: [belajar-excel] Remove duplikat sesuai tanggal
 To: [email protected]
 Date: Monday, February 9, 2015, 10:15 PM


  


 







       Dear Rudi,
 Maaf sebelumnya, yg ingin anda inginkan
 mengunakan excel formula atau dgn VBA..karena yg saya lihat

 pada userformnya cuma ada 1 buah textbox.

 Jika acuanya pada sheet transaksi, berarti penyusunan
 datanya harus sesuai dgn kaidah database sehingga bisa
 menghasilkan Report yg anda inginkan.
 TerimaKasih.


 Sent
 from Yahoo Mail on Android


                    




                     

                                 From:

                             Rudi Anto [email protected]
 [belajar-excel] <[email protected]>;
 


                                 To:

                             

 <[email protected]>;
                  


                                 Subject:

                             [belajar-excel] Remove duplikat
 sesuai tanggal [1 Attachment]


                                 Sent:

                             Mon, Feb 9, 2015 10:43:14 AM





               
  













       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


























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

 #yiv1339804560 #yiv1339804560ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv1339804560 #yiv1339804560ygrp-mkp #yiv1339804560hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv1339804560 #yiv1339804560ygrp-mkp #yiv1339804560ads {
 margin-bottom:10px;}

 #yiv1339804560 #yiv1339804560ygrp-mkp .yiv1339804560ad {
 padding:0 0;}

 #yiv1339804560 #yiv1339804560ygrp-mkp .yiv1339804560ad p {
 margin:0;}

 #yiv1339804560 #yiv1339804560ygrp-mkp .yiv1339804560ad a {
 color:#0000ff;text-decoration:none;}
 #yiv1339804560 #yiv1339804560ygrp-sponsor
 #yiv1339804560ygrp-lc {
 font-family:Arial;}

 #yiv1339804560 #yiv1339804560ygrp-sponsor
 #yiv1339804560ygrp-lc #yiv1339804560hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv1339804560 #yiv1339804560ygrp-sponsor
 #yiv1339804560ygrp-lc .yiv1339804560ad {
 margin-bottom:10px;padding:0 0;}

 #yiv1339804560 #yiv1339804560actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

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

 #yiv1339804560 #yiv1339804560activity span {
 font-weight:700;}

 #yiv1339804560 #yiv1339804560activity span:first-child {
 text-transform:uppercase;}

 #yiv1339804560 #yiv1339804560activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv1339804560 #yiv1339804560activity span span {
 color:#ff7900;}

 #yiv1339804560 #yiv1339804560activity span

 .yiv1339804560underline {
 text-decoration:underline;}

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

 #yiv1339804560 .yiv1339804560attach div a {
 text-decoration:none;}

 #yiv1339804560 .yiv1339804560attach img {
 border:none;padding-right:5px;}

 #yiv1339804560 .yiv1339804560attach label {
 display:block;margin-bottom:5px;}

 #yiv1339804560 .yiv1339804560attach label a {
 text-decoration:none;}

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

 #yiv1339804560 .yiv1339804560bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv1339804560 .yiv1339804560bold a {
 text-decoration:none;}

 #yiv1339804560 dd.yiv1339804560last p a {
 font-family:Verdana;font-weight:700;}

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

 #yiv1339804560 dd.yiv1339804560last p
 span.yiv1339804560yshortcuts {
 margin-right:0;}

 #yiv1339804560 div.yiv1339804560attach-table div div a {
 text-decoration:none;}

 #yiv1339804560 div.yiv1339804560attach-table {
 width:400px;}

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

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

 #yiv1339804560 div#yiv1339804560ygrp-mlmsg
 #yiv1339804560ygrp-msg p a span.yiv1339804560yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv1339804560 .yiv1339804560green {
 color:#628c2a;}

 #yiv1339804560 .yiv1339804560MsoNormal {
 margin:0 0 0 0;}

 #yiv1339804560 o {
 font-size:0;}

 #yiv1339804560 #yiv1339804560photos div {
 float:left;width:72px;}

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

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

 #yiv1339804560 #yiv1339804560reco-category {
 font-size:77%;}

 #yiv1339804560 #yiv1339804560reco-desc {
 font-size:77%;}

 #yiv1339804560 .yiv1339804560replbq {
 margin:4px;}

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

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

 #yiv1339804560 #yiv1339804560ygrp-mlmsg table {

 font-size:inherit;font:100%;}

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

 #yiv1339804560 #yiv1339804560ygrp-mlmsg pre, #yiv1339804560
 code {
 font:115% monospace;}

 #yiv1339804560 #yiv1339804560ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv1339804560 #yiv1339804560ygrp-mlmsg #yiv1339804560logo {
 padding-bottom:10px;}


 #yiv1339804560 #yiv1339804560ygrp-msg p a {
 font-family:Verdana;}

 #yiv1339804560 #yiv1339804560ygrp-msg
 p#yiv1339804560attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv1339804560 #yiv1339804560ygrp-reco
 #yiv1339804560reco-head {
 color:#ff7900;font-weight:700;}

 #yiv1339804560 #yiv1339804560ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv1339804560 #yiv1339804560ygrp-sponsor #yiv1339804560ov
 li a {
 font-size:130%;text-decoration:none;}


 #yiv1339804560 #yiv1339804560ygrp-sponsor #yiv1339804560ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv1339804560 #yiv1339804560ygrp-sponsor #yiv1339804560ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv1339804560 #yiv1339804560ygrp-text {
 font-family:Georgia;}

 #yiv1339804560 #yiv1339804560ygrp-text p {
 margin:0 0 1em 0;}

 #yiv1339804560 #yiv1339804560ygrp-text tt {
 font-size:120%;}

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

Kirim email ke