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

Mon, 09 Feb 2015 08:55:59 -0800 

Dengan sedikit kesabaran dan searching kemana-mana, terlebih searching dimilis 
ini.. dah terpecahkan,
mungkin ada masukan atau cara yang lebih gampang, di sharing ya




Salam,
Rudi Anto




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


 Subject: [belajar-excel] Remove duplikat sesuai tanggal [1 Attachment]
 To: [email protected]
 Date: Monday, February 9, 2015, 5:43 PM


  








  
       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





  



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

 #yiv7116419066 #yiv7116419066ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv7116419066 #yiv7116419066ygrp-mkp #yiv7116419066hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv7116419066 #yiv7116419066ygrp-mkp #yiv7116419066ads {
 margin-bottom:10px;}

 #yiv7116419066 #yiv7116419066ygrp-mkp .yiv7116419066ad {
 padding:0 0;}

 #yiv7116419066 #yiv7116419066ygrp-mkp .yiv7116419066ad p {
 margin:0;}

 #yiv7116419066 #yiv7116419066ygrp-mkp .yiv7116419066ad a {
 color:#0000ff;text-decoration:none;}
 #yiv7116419066 #yiv7116419066ygrp-sponsor
 #yiv7116419066ygrp-lc {
 font-family:Arial;}

 #yiv7116419066 #yiv7116419066ygrp-sponsor
 #yiv7116419066ygrp-lc #yiv7116419066hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv7116419066 #yiv7116419066ygrp-sponsor
 #yiv7116419066ygrp-lc .yiv7116419066ad {
 margin-bottom:10px;padding:0 0;}

 #yiv7116419066 #yiv7116419066actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

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

 #yiv7116419066 #yiv7116419066activity span {
 font-weight:700;}
 

 #yiv7116419066 #yiv7116419066activity span:first-child {
 text-transform:uppercase;}

 #yiv7116419066 #yiv7116419066activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv7116419066 #yiv7116419066activity span span {
 color:#ff7900;}

 #yiv7116419066 #yiv7116419066activity span
 .yiv7116419066underline {
 text-decoration:underline;}

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

 #yiv7116419066 .yiv7116419066attach div a {
 text-decoration:none;}

 #yiv7116419066 .yiv7116419066attach img {
 border:none;padding-right:5px;}

 #yiv7116419066 .yiv7116419066attach label {
 display:block;margin-bottom:5px;}

 #yiv7116419066 .yiv7116419066attach label a {
 text-decoration:none;}

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

 #yiv7116419066 .yiv7116419066bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv7116419066 .yiv7116419066bold a {
 text-decoration:none;}

 #yiv7116419066 dd.yiv7116419066last p a {
 font-family:Verdana;font-weight:700;}

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

 #yiv7116419066 dd.yiv7116419066last p
 span.yiv7116419066yshortcuts {
 margin-right:0;}

 #yiv7116419066 div.yiv7116419066attach-table div div a {
 text-decoration:none;}

 #yiv7116419066 div.yiv7116419066attach-table {
 width:400px;}

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

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

 #yiv7116419066 div#yiv7116419066ygrp-mlmsg
 #yiv7116419066ygrp-msg p a span.yiv7116419066yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv7116419066 .yiv7116419066green {
 color:#628c2a;}

 #yiv7116419066 .yiv7116419066MsoNormal {
 margin:0 0 0 0;}
 

 #yiv7116419066 o {
 font-size:0;}

 #yiv7116419066 #yiv7116419066photos div {
 float:left;width:72px;}

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

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

 #yiv7116419066 #yiv7116419066reco-category {
 font-size:77%;}

 #yiv7116419066 #yiv7116419066reco-desc {
 font-size:77%;}

 #yiv7116419066 .yiv7116419066replbq {
 margin:4px;}

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

 #yiv7116419066 #yiv7116419066ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,

 sans-serif;}

 #yiv7116419066 #yiv7116419066ygrp-mlmsg table {
 font-size:inherit;font:100%;}

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

 #yiv7116419066 #yiv7116419066ygrp-mlmsg pre, #yiv7116419066
 code {
 font:115% monospace;}

 #yiv7116419066 #yiv7116419066ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv7116419066 #yiv7116419066ygrp-mlmsg #yiv7116419066logo {
 padding-bottom:10px;}


 #yiv7116419066 #yiv7116419066ygrp-msg p a {
 font-family:Verdana;}

 #yiv7116419066 #yiv7116419066ygrp-msg
 p#yiv7116419066attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv7116419066 #yiv7116419066ygrp-reco
 #yiv7116419066reco-head {
 color:#ff7900;font-weight:700;}

 #yiv7116419066 #yiv7116419066ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv7116419066 #yiv7116419066ygrp-sponsor #yiv7116419066ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv7116419066 #yiv7116419066ygrp-sponsor #yiv7116419066ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv7116419066 #yiv7116419066ygrp-sponsor #yiv7116419066ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv7116419066 #yiv7116419066ygrp-text {
 font-family:Georgia;}

 #yiv7116419066 #yiv7116419066ygrp-text p {
 margin:0 0 1em 0;}

 #yiv7116419066 #yiv7116419066ygrp-text tt {
 font-size:120%;}

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

Attachment: re-PENJUALAN.xlsm
Description: application/download

Kirim email ke