Kamis, 05 Maret 2015

[belajar-excel] Digest Number 3328

5 Messages

Digest #3328

Messages

Thu Mar 5, 2015 1:01 am (PST) . Posted by:

"omeza" icat_omez@ymail.com

Dear Master milis
macro advacedfilter.ketika sya shared koq dia tidak bisa di gunakan..
Mohon bantuanya ..
Terima kasih

wasalam omez
Untitled.jpg
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729387/Untitled.jpg>

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/Macro-Advacefilter-Ketika-Di-share-Koq-tidak-bisa-digunakan-tp5729387.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.

Thu Mar 5, 2015 1:01 am (PST) . Posted by:

"omeza" icat_omez@ymail.com

Tolong Dijelaskan bagaimana caranya.Warm Regards...

Terima kasih

wasalam

omez

--
View this message in context: http://milis-belajar-excel.1048464.n5.nabble.com/ctrl-S-otomatis-tp5729296p5729393.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.

Thu Mar 5, 2015 1:05 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear mas Rudi, Mungkin file ini seperti yang mas Rudi harapkan. TerimaKasih,

Pada Kamis, 5 Maret 2015 14:47, "SUYONO reza.suyono@lge.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Sore Pak Rudi. Coba menggunakan tool calendar..tetapi untuk menampilkannya datake listbox menggunakan looping, Kekurangannya kalau datanya banyak proses agak lama.   From:belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, March 05, 2015 10:11 AM
To: belajar-excel@yahoogroups.com
Subject: Re: Bls: [belajar-excel] Menampilkan isi Listbox sesuai tanggal( dtpicker )     Terima kasih tanggapannya mas marthen,

mungkin saya dibantu sedikit contoh berupa file untuk yang pakai monthview,
sedikit tambahan, dari data yang saya filter pertanggal, jika ada data yangsalah, data tersebut bisa saya ubah.
Kalo saya pindah ke sheet lain.. bisa nggak data yang disheet pertama ikutberubah ?

Mohon masukannya rekan-rekan, terima kasih.

Salam,
Rudi Anto

--------------------------------------------
On Thu, 3/5/15, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:

Subject: Bls: [belajar-excel] Menampilkan isi Listbox sesuai tanggal ( dtpicker)
To: "belajar-excel@yahoogroups.com"<belajar-excel@yahoogroups.com>
Date: Thursday, March 5, 2015, 9:00 AM

 

Dear
mas Rudi, Lebih
mudah menggunakan MonthView pak di banding dengan
dtpicker.Untuk
memfilter dalam sheet dan di munculkan dalam Listbox pasti
akan ikut semua data yang tidak terfilter karena di ambil
dalam salah satu sheet, untuk mengantisipasinya, data yang
sudah terfilter di copy ke sheet lain kemudian di tampilkan
kembali di dalam Listbox tanpa menggunakan Module ataupun
class Module,hati-hati dalam menggunakan Module ataupun
Class module. Kalau ada
cara yang lebih mudah, mungkin rekan-rekan ada masukannya
lagi. TerimaKasih,marthen

Pada Kamis, 5 Maret
2015 2:40, "Rudi Anto rudi.excel@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:

 

Dear all Be-Exceller,

Langsung aja ya, bagaimana cara mengisi listbox sesuai
dengan tanggal ( dtpicker ) yang dipilih,

File pendukung kami lampirkan,

Sebelumnya kami mengucapkan terima kasih yang
sebesar-besarnya.

Salam,

Rudi Anto

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

#yiv7876755601 #yiv7876755601ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7876755601 #yiv7876755601ygrp-mkp #yiv7876755601hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7876755601 #yiv7876755601ygrp-mkp #yiv7876755601ads {
margin-bottom:10px;}

#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad {
padding:0 0;}

#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad p {
margin:0;}

#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad a {
color:#0000ff;text-decoration:none;}
#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ygrp-lc {
font-family:Arial;}

#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ygrp-lc #yiv7876755601hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ygrp-lc .yiv7876755601ad {
margin-bottom:10px;padding:0 0;}

#yiv7876755601 #yiv7876755601actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv7876755601 #yiv7876755601activity span {
font-weight:700;}

#yiv7876755601 #yiv7876755601activity span:first-child {
text-transform:uppercase;}

#yiv7876755601 #yiv7876755601activity span a {
color:#5085b6;text-decoration:none;}

#yiv7876755601 #yiv7876755601activity span span {
color:#ff7900;}

#yiv7876755601 #yiv7876755601activity span
.yiv7876755601underline {
text-decoration:underline;}

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

#yiv7876755601 .yiv7876755601attach div a {
text-decoration:none;}

#yiv7876755601 .yiv7876755601attach img {
border:none;padding-right:5px;}

#yiv7876755601 .yiv7876755601attach label {
display:block;margin-bottom:5px;}

#yiv7876755601 .yiv7876755601attach label a {
text-decoration:none;}

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

#yiv7876755601 .yiv7876755601bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7876755601 .yiv7876755601bold a {
text-decoration:none;}

#yiv7876755601 dd.yiv7876755601last p a {
font-family:Verdana;font-weight:700;}

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

#yiv7876755601 dd.yiv7876755601last p
span.yiv7876755601yshortcuts {
margin-right:0;}

#yiv7876755601 div.yiv7876755601attach-table div div a {
text-decoration:none;}

#yiv7876755601 div.yiv7876755601attach-table {
width:400px;}

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

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

#yiv7876755601 div#yiv7876755601ygrp-mlmsg
#yiv7876755601ygrp-msg p a span.yiv7876755601yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7876755601 .yiv7876755601green {
color:#628c2a;}

#yiv7876755601 .yiv7876755601MsoNormal {
margin:0 0 0 0;}

#yiv7876755601 o {
font-size:0;}

#yiv7876755601 #yiv7876755601photos div {
float:left;width:72px;}

#yiv7876755601 #yiv7876755601photos div div {

border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

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

#yiv7876755601 #yiv7876755601reco-category {
font-size:77%;}

#yiv7876755601 #yiv7876755601reco-desc {
font-size:77%;}

#yiv7876755601 .yiv7876755601replbq {
margin:4px;}

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

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

#yiv7876755601 #yiv7876755601ygrp-mlmsg table {
font-size:inherit;font:100%;}

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

#yiv7876755601 #yiv7876755601ygrp-mlmsg pre, #yiv7876755601
code {
font:115% monospace;}

#yiv7876755601 #yiv7876755601ygrp-mlmsg * {
line-height:1.22em;}

#yiv7876755601 #yiv7876755601ygrp-mlmsg #yiv7876755601logo {
padding-bottom:10px;}

#yiv7876755601 #yiv7876755601ygrp-msg p a {
font-family:Verdana;}

#yiv7876755601 #yiv7876755601ygrp-msg
p#yiv7876755601attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7876755601 #yiv7876755601ygrp-reco
#yiv7876755601reco-head {
color:#ff7900;font-weight:700;}

#yiv7876755601 #yiv7876755601ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7876755601 #yiv7876755601ygrp-sponsor #yiv7876755601ov
li a {
font-size:130%;text-decoration:none;}

#yiv7876755601 #yiv7876755601ygrp-sponsor #yiv7876755601ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7876755601 #yiv7876755601ygrp-sponsor #yiv7876755601ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7876755601 #yiv7876755601ygrp-text {
font-family:Georgia;}

#yiv7876755601 #yiv7876755601ygrp-text p {
margin:0 0 1em 0;}

#yiv7876755601 #yiv7876755601ygrp-text tt {
font-size:120%;}

#yiv7876755601 #yiv7876755601ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7876755601 #yiv1868003712 #yiv1868003712 -- #yiv1868003712ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1868003712 #yiv1868003712ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1868003712 #yiv1868003712ygrp-mkp #yiv1868003712hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1868003712 #yiv1868003712ygrp-mkp #yiv1868003712ads {margin-bottom:10px;}#yiv1868003712 #yiv1868003712ygrp-mkp .yiv1868003712ad {padding:0 0;}#yiv1868003712 #yiv1868003712ygrp-mkp .yiv1868003712ad p {margin:0;}#yiv1868003712 #yiv1868003712ygrp-mkp .yiv1868003712ad a {color:#0000ff;text-decoration:none;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ygrp-lc {font-family:Arial;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ygrp-lc #yiv1868003712hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ygrp-lc .yiv1868003712ad {margin-bottom:10px;padding:0 0;}#yiv1868003712 #yiv1868003712actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1868003712 #yiv1868003712activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1868003712 #yiv1868003712activity span {font-weight:700;}#yiv1868003712 #yiv1868003712activity span:first-child {text-transform:uppercase;}#yiv1868003712 #yiv1868003712activity span a {color:#5085b6;text-decoration:none;}#yiv1868003712 #yiv1868003712activity span span {color:#ff7900;}#yiv1868003712 #yiv1868003712activity span .yiv1868003712underline {text-decoration:underline;}#yiv1868003712 .yiv1868003712attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1868003712 .yiv1868003712attach div a {text-decoration:none;}#yiv1868003712 .yiv1868003712attach img {border:none;padding-right:5px;}#yiv1868003712 .yiv1868003712attach label {display:block;margin-bottom:5px;}#yiv1868003712 .yiv1868003712attach label a {text-decoration:none;}#yiv1868003712 blockquote {margin:0 0 0 4px;}#yiv1868003712 .yiv1868003712bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1868003712 .yiv1868003712bold a {text-decoration:none;}#yiv1868003712 dd.yiv1868003712last p a {font-family:Verdana;font-weight:700;}#yiv1868003712 dd.yiv1868003712last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1868003712 dd.yiv1868003712last p span.yiv1868003712yshortcuts {margin-right:0;}#yiv1868003712 div.yiv1868003712attach-table div div a {text-decoration:none;}#yiv1868003712 div.yiv1868003712attach-table {width:400px;}#yiv1868003712 div.yiv1868003712file-title a, #yiv1868003712 div.yiv1868003712file-title a:active, #yiv1868003712 div.yiv1868003712file-title a:hover, #yiv1868003712 div.yiv1868003712file-title a:visited {text-decoration:none;}#yiv1868003712 div.yiv1868003712photo-title a, #yiv1868003712 div.yiv1868003712photo-title a:active, #yiv1868003712 div.yiv1868003712photo-title a:hover, #yiv1868003712 div.yiv1868003712photo-title a:visited {text-decoration:none;}#yiv1868003712 div#yiv1868003712ygrp-mlmsg #yiv1868003712ygrp-msg p a span.yiv1868003712yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1868003712 .yiv1868003712green {color:#628c2a;}#yiv1868003712 .yiv1868003712MsoNormal {margin:0 0 0 0;}#yiv1868003712 o {font-size:0;}#yiv1868003712 #yiv1868003712photos div {float:left;width:72px;}#yiv1868003712 #yiv1868003712photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1868003712 #yiv1868003712photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1868003712 #yiv1868003712reco-category {font-size:77%;}#yiv1868003712 #yiv1868003712reco-desc {font-size:77%;}#yiv1868003712 .yiv1868003712replbq {margin:4px;}#yiv1868003712 #yiv1868003712ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1868003712 #yiv1868003712ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1868003712 #yiv1868003712ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1868003712 #yiv1868003712ygrp-mlmsg select, #yiv1868003712 input, #yiv1868003712 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1868003712 #yiv1868003712ygrp-mlmsg pre, #yiv1868003712 code {font:115% monospace;}#yiv1868003712 #yiv1868003712ygrp-mlmsg * {line-height:1.22em;}#yiv1868003712 #yiv1868003712ygrp-mlmsg #yiv1868003712logo {padding-bottom:10px;}#yiv1868003712 #yiv1868003712ygrp-msg p a {font-family:Verdana;}#yiv1868003712 #yiv1868003712ygrp-msg p#yiv1868003712attach-count span {color:#1E66AE;font-weight:700;}#yiv1868003712 #yiv1868003712ygrp-reco #yiv1868003712reco-head {color:#ff7900;font-weight:700;}#yiv1868003712 #yiv1868003712ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ov li a {font-size:130%;text-decoration:none;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1868003712 #yiv1868003712ygrp-sponsor #yiv1868003712ov ul {margin:0;padding:0 0 0 8px;}#yiv1868003712 #yiv1868003712ygrp-text {font-family:Georgia;}#yiv1868003712 #yiv1868003712ygrp-text p {margin:0 0 1em 0;}#yiv1868003712 #yiv1868003712ygrp-text tt {font-size:120%;}#yiv1868003712 #yiv1868003712ygrp-vital ul li:last-child {border-right:none !important;}#yiv1868003712

Thu Mar 5, 2015 2:15 am (PST) . Posted by:

"Rudi Anto" rudi.excel

Terima kasih mas tobi,
untuk file yang mas tobi lampirkan, Data filter by date.xlsm , setelah kami coba buka ada semacam error,
Couldn't load.... machine , apa memang disertakan semacam control ocx.
yang kedua, kami ingin lihat codenya, ternyata diproteksi ya.

Terima kasih.

Salam,
Rudi Anto

--------------------------------------------
On Thu, 3/5/15, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

Subject: Bls: Bls: [belajar-excel] Menampilkan isi Listbox sesuai tanggal ( dtpicker ) [1 Attachment]
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Date: Thursday, March 5, 2015, 4:05 PM


 




Dear mas
Rudi, Mungkin file ini seperti yang mas Rudi
harapkan. TerimaKasih,


Pada Kamis, 5 Maret
2015 14:47, "SUYONO reza.suyono@lge.com
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 

















Sore Pak
Rudi.

Coba
menggunakan tool calendar..tetapi untuk menampilkannya data
ke listbox menggunakan looping,

Kekurangannya
kalau datanya banyak proses agak lama.


 





From:
belajar-excel@yahoogroups.com
[mailto:belajar-excel@yahoogroups.com]

Sent: Thursday, March 05, 2015 10:11 AM

To: belajar-excel@yahoogroups.com

Subject: Re: Bls: [belajar-excel] Menampilkan isi
Listbox sesuai tanggal
( dtpicker )





 

 




Terima kasih tanggapannya
mas marthen,



mungkin saya dibantu sedikit contoh berupa file untuk yang
pakai monthview,

sedikit tambahan, dari data yang saya filter pertanggal,
jika ada data yang
salah, data tersebut bisa saya ubah.

Kalo saya pindah ke sheet lain.. bisa nggak data yang
disheet pertama ikut
berubah ?



Mohon masukannya rekan-rekan, terima kasih.



Salam,

Rudi Anto



--------------------------------------------

On Thu, 3/5/15, Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]
<belajar-excel@yahoogroups.com> wrote:



Subject: Bls: [belajar-excel] Menampilkan isi Listbox sesuai
tanggal ( dtpicker
)

To: "belajar-excel@yahoogroups.com"
<belajar-excel@yahoogroups.com>

Date: Thursday, March 5, 2015, 9:00 AM





 












Dear

mas Rudi, Lebih

mudah menggunakan MonthView pak di banding dengan

dtpicker.Untuk

memfilter dalam sheet dan di munculkan dalam Listbox
pasti

akan ikut semua data yang tidak terfilter karena di ambil

dalam salah satu sheet, untuk mengantisipasinya, data
yang

sudah terfilter di copy ke sheet lain kemudian di
tampilkan

kembali di dalam Listbox tanpa menggunakan Module ataupun

class Module,hati-hati dalam menggunakan Module ataupun

Class module. Kalau ada

cara yang lebih mudah, mungkin rekan-rekan ada masukannya

lagi. TerimaKasih,marthen





Pada Kamis, 5 Maret

2015 2:40, "Rudi Anto rudi.excel@yahoo.com

[belajar-excel]"
<belajar-excel@yahoogroups.com>

menulis:







 



Dear all Be-Exceller,







Langsung aja ya, bagaimana cara mengisi listbox sesuai

dengan tanggal ( dtpicker ) yang dipilih,



File pendukung kami lampirkan,



Sebelumnya kami mengucapkan terima kasih yang

sebesar-besarnya.







Salam,



Rudi Anto











































#yiv7876755601 #yiv7876755601 --

#yiv7876755601ygrp-mkp {

border:1px solid #d8d8d8;font-family:Arial;margin:10px

0;padding:0 10px;}



#yiv7876755601 #yiv7876755601ygrp-mkp hr {

border:1px solid #d8d8d8;}



#yiv7876755601 #yiv7876755601ygrp-mkp #yiv7876755601hd {

color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px

0;}



#yiv7876755601 #yiv7876755601ygrp-mkp #yiv7876755601ads {

margin-bottom:10px;}



#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad {

padding:0 0;}



#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad p
{

margin:0;}



#yiv7876755601 #yiv7876755601ygrp-mkp .yiv7876755601ad a
{

color:#0000ff;text-decoration:none;}

#yiv7876755601 #yiv7876755601ygrp-sponsor

#yiv7876755601ygrp-lc {

font-family:Arial;}



#yiv7876755601 #yiv7876755601ygrp-sponsor

#yiv7876755601ygrp-lc #yiv7876755601hd {

margin:10px

0px;font-weight:700;font-size:78%;line-height:122%;}



#yiv7876755601 #yiv7876755601ygrp-sponsor

#yiv7876755601ygrp-lc .yiv7876755601ad {

margin-bottom:10px;padding:0 0;}



#yiv7876755601 #yiv7876755601actions {

font-family:Verdana;font-size:11px;padding:10px 0;}



#yiv7876755601 #yiv7876755601activity {

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



#yiv7876755601 #yiv7876755601activity span {

font-weight:700;}



#yiv7876755601 #yiv7876755601activity span:first-child {

text-transform:uppercase;}



#yiv7876755601 #yiv7876755601activity span a {

color:#5085b6;text-decoration:none;}


#yiv7876755601 #yiv7876755601activity span span {

color:#ff7900;}



#yiv7876755601 #yiv7876755601activity span

.yiv7876755601underline {

text-decoration:underline;}



#yiv7876755601 .yiv7876755601attach {

clear:both;display:table;font-family:Arial;font-size:12px;padding:10px

0;width:400px;}



#yiv7876755601 .yiv7876755601attach div a {


text-decoration:none;}



#yiv7876755601 .yiv7876755601attach img {


border:none;padding-right:5px;}



#yiv7876755601 .yiv7876755601attach label {

display:block;margin-bottom:5px;}



#yiv7876755601 .yiv7876755601attach label a {

text-decoration:none;}



#yiv7876755601 blockquote {

margin:0 0 0 4px;}



#yiv7876755601 .yiv7876755601bold {

font-family:Arial;font-size:13px;font-weight:700;}



#yiv7876755601 .yiv7876755601bold a {

text-decoration:none;}



#yiv7876755601 dd.yiv7876755601last p a {

font-family:Verdana;font-weight:700;}



#yiv7876755601 dd.yiv7876755601last p span {

margin-right:10px;font-family:Verdana;font-weight:700;}



#yiv7876755601 dd.yiv7876755601last p

span.yiv7876755601yshortcuts {

margin-right:0;}



#yiv7876755601 div.yiv7876755601attach-table div div a {

text-decoration:none;}



#yiv7876755601 div.yiv7876755601attach-table {

width:400px;}



#yiv7876755601 div.yiv7876755601file-title a,
#yiv7876755601

div.yiv7876755601file-title a:active, #yiv7876755601

div.yiv7876755601file-title a:hover, #yiv7876755601

div.yiv7876755601file-title a:visited {

text-decoration:none;}





#yiv7876755601 div.yiv7876755601photo-title a,

#yiv7876755601 div.yiv7876755601photo-title a:active,

#yiv7876755601 div.yiv7876755601photo-title a:hover,

#yiv7876755601 div.yiv7876755601photo-title a:visited {

text-decoration:none;}



#yiv7876755601 div#yiv7876755601ygrp-mlmsg

#yiv7876755601ygrp-msg p a span.yiv7876755601yshortcuts {

font-family:Verdana;font-size:10px;font-weight:normal;}



#yiv7876755601 .yiv7876755601green {

color:#628c2a;}



#yiv7876755601 .yiv7876755601MsoNormal {

margin:0 0 0 0;}



#yiv7876755601 o {

font-size:0;}



#yiv7876755601 #yiv7876755601photos div {

float:left;width:72px;}



#yiv7876755601 #yiv7876755601photos div div {



border:1px solid

#666666;height:62px;overflow:hidden;width:62px;}



#yiv7876755601 #yiv7876755601photos div label {

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



#yiv7876755601 #yiv7876755601reco-category {

font-size:77%;}



#yiv7876755601 #yiv7876755601reco-desc {

font-size:77%;}



#yiv7876755601 .yiv7876755601replbq {

margin:4px;}



#yiv7876755601 #yiv7876755601ygrp-actbar div a:first-child
{

margin-right:2px;padding-right:5px;}



#yiv7876755601 #yiv7876755601ygrp-mlmsg {

font-size:13px;font-family:Arial, helvetica, clean,

sans-serif;}



#yiv7876755601 #yiv7876755601ygrp-mlmsg table {

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



#yiv7876755601 #yiv7876755601ygrp-mlmsg select,

#yiv7876755601 input, #yiv7876755601 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}



#yiv7876755601 #yiv7876755601ygrp-mlmsg pre,
#yiv7876755601

code {

font:115% monospace;}



#yiv7876755601 #yiv7876755601ygrp-mlmsg * {

line-height:1.22em;}



#yiv7876755601 #yiv7876755601ygrp-mlmsg #yiv7876755601logo
{

padding-bottom:10px;}





#yiv7876755601 #yiv7876755601ygrp-msg p a {

font-family:Verdana;}



#yiv7876755601 #yiv7876755601ygrp-msg

p#yiv7876755601attach-count span {

color:#1E66AE;font-weight:700;}



#yiv7876755601 #yiv7876755601ygrp-reco

#yiv7876755601reco-head {

color:#ff7900;font-weight:700;}



#yiv7876755601 #yiv7876755601ygrp-reco {

margin-bottom:20px;padding:0px;}



#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ov

li a {

font-size:130%;text-decoration:none;}



#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ov

li {

font-size:77%;list-style-type:square;padding:6px 0;}



#yiv7876755601 #yiv7876755601ygrp-sponsor
#yiv7876755601ov

ul {

margin:0;padding:0 0 0 8px;}



#yiv7876755601 #yiv7876755601ygrp-text {

font-family:Georgia;}



#yiv7876755601 #yiv7876755601ygrp-text p {

margin:0 0 1em 0;}



#yiv7876755601 #yiv7876755601ygrp-text tt {

font-size:120%;}



#yiv7876755601 #yiv7876755601ygrp-vital ul li:last-child
{

border-right:none !important;

}

#yiv7876755601




































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

#yiv1434778053 #yiv1434778053ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1434778053 #yiv1434778053ygrp-mkp #yiv1434778053hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1434778053 #yiv1434778053ygrp-mkp #yiv1434778053ads {

margin-bottom:10px;}

#yiv1434778053 #yiv1434778053ygrp-mkp .yiv1434778053ad {
padding:0 0;}

#yiv1434778053 #yiv1434778053ygrp-mkp .yiv1434778053ad p {
margin:0;}

#yiv1434778053 #yiv1434778053ygrp-mkp .yiv1434778053ad a {
color:#0000ff;text-decoration:none;}
#yiv1434778053 #yiv1434778053ygrp-sponsor
#yiv1434778053ygrp-lc {
font-family:Arial;}

#yiv1434778053 #yiv1434778053ygrp-sponsor
#yiv1434778053ygrp-lc #yiv1434778053hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1434778053 #yiv1434778053ygrp-sponsor
#yiv1434778053ygrp-lc .yiv1434778053ad {
margin-bottom:10px;padding:0 0;}

#yiv1434778053 #yiv1434778053actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

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

#yiv1434778053 #yiv1434778053activity span {
font-weight:700;}

#yiv1434778053 #yiv1434778053activity span:first-child {
text-transform:uppercase;}

#yiv1434778053 #yiv1434778053activity span a {
color:#5085b6;text-decoration:none;}

#yiv1434778053 #yiv1434778053activity span span {
color:#ff7900;}

#yiv1434778053 #yiv1434778053activity span
.yiv1434778053underline {
text-decoration:underline;}

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

#yiv1434778053 .yiv1434778053attach div a {
text-decoration:none;}

#yiv1434778053 .yiv1434778053attach img {
border:none;padding-right:5px;}

#yiv1434778053 .yiv1434778053attach label {
display:block;margin-bottom:5px;}

#yiv1434778053 .yiv1434778053attach label a {
text-decoration:none;}

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

#yiv1434778053 .yiv1434778053bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1434778053 .yiv1434778053bold a {
text-decoration:none;}

#yiv1434778053 dd.yiv1434778053last p a {
font-family:Verdana;font-weight:700;}

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

#yiv1434778053 dd.yiv1434778053last p
span.yiv1434778053yshortcuts {
margin-right:0;}

#yiv1434778053 div.yiv1434778053attach-table div div a {
text-decoration:none;}

#yiv1434778053 div.yiv1434778053attach-table {
width:400px;}

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

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

#yiv1434778053 div#yiv1434778053ygrp-mlmsg
#yiv1434778053ygrp-msg p a span.yiv1434778053yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1434778053 .yiv1434778053green {
color:#628c2a;}

#yiv1434778053 .yiv1434778053MsoNormal {
margin:0 0 0 0;}

#yiv1434778053 o {
font-size:0;}

#yiv1434778053 #yiv1434778053photos div {
float:left;width:72px;}

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

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

#yiv1434778053 #yiv1434778053reco-category {
font-size:77%;}

#yiv1434778053 #yiv1434778053reco-desc {
font-size:77%;}

#yiv1434778053 .yiv1434778053replbq {
margin:4px;}

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

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

#yiv1434778053 #yiv1434778053ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv1434778053 #yiv1434778053ygrp-mlmsg select,
#yiv1434778053 input, #yiv1434778053 textarea {

font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1434778053 #yiv1434778053ygrp-mlmsg pre, #yiv1434778053
code {
font:115% monospace;}

#yiv1434778053 #yiv1434778053ygrp-mlmsg * {
line-height:1.22em;}

#yiv1434778053 #yiv1434778053ygrp-mlmsg #yiv1434778053logo {
padding-bottom:10px;}


#yiv1434778053 #yiv1434778053ygrp-msg p a {
font-family:Verdana;}

#yiv1434778053 #yiv1434778053ygrp-msg
p#yiv1434778053attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1434778053 #yiv1434778053ygrp-reco
#yiv1434778053reco-head {
color:#ff7900;font-weight:700;}

#yiv1434778053 #yiv1434778053ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1434778053 #yiv1434778053ygrp-sponsor #yiv1434778053ov
li a {
font-size:130%;text-decoration:none;}

#yiv1434778053 #yiv1434778053ygrp-sponsor #yiv1434778053ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1434778053 #yiv1434778053ygrp-sponsor #yiv1434778053ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1434778053 #yiv1434778053ygrp-text {
font-family:Georgia;}

#yiv1434778053 #yiv1434778053ygrp-text p {
margin:0 0 1em 0;}

#yiv1434778053 #yiv1434778053ygrp-text tt {
font-size:120%;}

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


Thu Mar 5, 2015 1:32 am (PST) . Posted by:

"Vicky Andhika" kuyabliss

Dear all,

Mohon bantuannya, saya perlu formula untuk mengambil data unik dari sebuah
tabel.

dari file terlampir ada 2 sheet, yaitu:
Minggu 1 (ini berisi rekapitulasi dari sheet data)
Data (ini adalah hasil copy paste dari mesin absen).

nah di sheet data ini ada duplicate value karena diambil dari 2 mesin
berbeda. (misal user1 tanggal 9 ada 2 data, tapi isi kolom lainnya berbeda)
sehingga data yang di sheet minggu1 ada data yang salah (saya beri warna
kuning cellnya).

saya buat formula di sheet Minggu1 (kolom Masuk, keluar, telat, Plng Awal,
jam ijin, status) untuk mengambil value dari sheet data.
formulanya hasil browsing tapi saya lupa source nya hehe..

yang diperlukan adalah:
- merubah formula sehingga bisa mengambil data yang ada isinya (contoh
adalah data user1 dan user 2)
- merubah tampilan pada kolom status pada sheet Minggu 1 agar tidak
menampilkan data bila memang datanya kosong (saat ini menampilkan 0:00)
- bila memungkinkan, mempersingkat/modifikasi formula agar lebih ringan
loadnya.

Terima kasih sebelumnya.

Salam,

Vicky
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar