yoo p bambang,
klo menurut saya klo pake advanced filter kayaknya berlebihan, bisa dicoba pake
menggunakan filter biasa aja pak,block data yang akan di filter => plih data
filter =>custom filter => ganti equal menjadi kriteria yang kita mau, dalam hal
ini "is after or equal to "=> isi dengan nilai 1992-01-01
br,
odong nando
Pada Kamis, 12 November 2015 10:38, "Bambang Setiawan
[email protected] [belajar-excel]" <[email protected]> menulis:
Dear All Suhu,
Mohon bantuan tips-nya, bagaimana caranya memasukan criteria pada advanced
filter
jika criteria range nya bertipe tanggal dan tanpa harus melakukan format cells
dulu menjadi number.
Misalnya jika saya ingin melakuan filter mengambil data yang tanggal lahirnya
lebih besar sama dengan 1992-01-01
| Birth Place
| Birth date
|
|
| >=1992-01-01
|
|
|
|
| Birth Place
| Birth date
|
| Bogor
| 1992-12-31
|
| Jakarta
| 1994-11-28
|
| Jakarta
| 1992-10-03
|
| Jakarta
| 1993-01-01
|
| Medan
| 1993-02-05
|
|
|
|
Atas bantuannya diucapkan terima kasih.
Salam,
#yiv5543111726 #yiv5543111726 -- #yiv5543111726ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5543111726
#yiv5543111726ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5543111726
#yiv5543111726ygrp-mkp #yiv5543111726hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5543111726 #yiv5543111726ygrp-mkp #yiv5543111726ads
{margin-bottom:10px;}#yiv5543111726 #yiv5543111726ygrp-mkp .yiv5543111726ad
{padding:0 0;}#yiv5543111726 #yiv5543111726ygrp-mkp .yiv5543111726ad p
{margin:0;}#yiv5543111726 #yiv5543111726ygrp-mkp .yiv5543111726ad a
{color:#0000ff;text-decoration:none;}#yiv5543111726 #yiv5543111726ygrp-sponsor
#yiv5543111726ygrp-lc {font-family:Arial;}#yiv5543111726
#yiv5543111726ygrp-sponsor #yiv5543111726ygrp-lc #yiv5543111726hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5543111726
#yiv5543111726ygrp-sponsor #yiv5543111726ygrp-lc .yiv5543111726ad
{margin-bottom:10px;padding:0 0;}#yiv5543111726 #yiv5543111726actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5543111726
#yiv5543111726activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5543111726
#yiv5543111726activity span {font-weight:700;}#yiv5543111726
#yiv5543111726activity span:first-child
{text-transform:uppercase;}#yiv5543111726 #yiv5543111726activity span a
{color:#5085b6;text-decoration:none;}#yiv5543111726 #yiv5543111726activity span
span {color:#ff7900;}#yiv5543111726 #yiv5543111726activity span
.yiv5543111726underline {text-decoration:underline;}#yiv5543111726
.yiv5543111726attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5543111726 .yiv5543111726attach div a
{text-decoration:none;}#yiv5543111726 .yiv5543111726attach img
{border:none;padding-right:5px;}#yiv5543111726 .yiv5543111726attach label
{display:block;margin-bottom:5px;}#yiv5543111726 .yiv5543111726attach label a
{text-decoration:none;}#yiv5543111726 blockquote {margin:0 0 0
4px;}#yiv5543111726 .yiv5543111726bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5543111726
.yiv5543111726bold a {text-decoration:none;}#yiv5543111726 dd.yiv5543111726last
p a {font-family:Verdana;font-weight:700;}#yiv5543111726 dd.yiv5543111726last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5543111726
dd.yiv5543111726last p span.yiv5543111726yshortcuts
{margin-right:0;}#yiv5543111726 div.yiv5543111726attach-table div div a
{text-decoration:none;}#yiv5543111726 div.yiv5543111726attach-table
{width:400px;}#yiv5543111726 div.yiv5543111726file-title a, #yiv5543111726
div.yiv5543111726file-title a:active, #yiv5543111726
div.yiv5543111726file-title a:hover, #yiv5543111726 div.yiv5543111726file-title
a:visited {text-decoration:none;}#yiv5543111726 div.yiv5543111726photo-title a,
#yiv5543111726 div.yiv5543111726photo-title a:active, #yiv5543111726
div.yiv5543111726photo-title a:hover, #yiv5543111726
div.yiv5543111726photo-title a:visited {text-decoration:none;}#yiv5543111726
div#yiv5543111726ygrp-mlmsg #yiv5543111726ygrp-msg p a
span.yiv5543111726yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5543111726
.yiv5543111726green {color:#628c2a;}#yiv5543111726 .yiv5543111726MsoNormal
{margin:0 0 0 0;}#yiv5543111726 o {font-size:0;}#yiv5543111726
#yiv5543111726photos div {float:left;width:72px;}#yiv5543111726
#yiv5543111726photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5543111726
#yiv5543111726photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5543111726
#yiv5543111726reco-category {font-size:77%;}#yiv5543111726
#yiv5543111726reco-desc {font-size:77%;}#yiv5543111726 .yiv5543111726replbq
{margin:4px;}#yiv5543111726 #yiv5543111726ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5543111726 #yiv5543111726ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5543111726
#yiv5543111726ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5543111726
#yiv5543111726ygrp-mlmsg select, #yiv5543111726 input, #yiv5543111726 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5543111726
#yiv5543111726ygrp-mlmsg pre, #yiv5543111726 code {font:115%
monospace;}#yiv5543111726 #yiv5543111726ygrp-mlmsg *
{line-height:1.22em;}#yiv5543111726 #yiv5543111726ygrp-mlmsg #yiv5543111726logo
{padding-bottom:10px;}#yiv5543111726 #yiv5543111726ygrp-msg p a
{font-family:Verdana;}#yiv5543111726 #yiv5543111726ygrp-msg
p#yiv5543111726attach-count span {color:#1E66AE;font-weight:700;}#yiv5543111726
#yiv5543111726ygrp-reco #yiv5543111726reco-head
{color:#ff7900;font-weight:700;}#yiv5543111726 #yiv5543111726ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5543111726 #yiv5543111726ygrp-sponsor
#yiv5543111726ov li a {font-size:130%;text-decoration:none;}#yiv5543111726
#yiv5543111726ygrp-sponsor #yiv5543111726ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5543111726
#yiv5543111726ygrp-sponsor #yiv5543111726ov ul {margin:0;padding:0 0 0
8px;}#yiv5543111726 #yiv5543111726ygrp-text
{font-family:Georgia;}#yiv5543111726 #yiv5543111726ygrp-text p {margin:0 0 1em
0;}#yiv5543111726 #yiv5543111726ygrp-text tt {font-size:120%;}#yiv5543111726
#yiv5543111726ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5543111726
