dear boz kid,
formula bos kid sudah saya terapkan dan berhasil, trimakasih bos kid....namun
ada yang mengganjal, mengapa pada formula bos kid tersebut tidak menunjukan
nila 1 atau TRUE, pada [range lookupnya]...? br,
odong nando
Pada Senin, 29 Februari 2016 11:53, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Odong,
fungsi vlookup dengan match type approximate (TRUE) bisa dimanfaatkan bila
tabel sumber terurut ascending berdasar kolom lookupnya
Wassalam,
Kid
2016-02-26 17:43 GMT+07:00 odong nando [email protected] [belajar-excel]
<[email protected]>:
dear all,
lg bingung mencari nilai lookup sebuah tanggal yang tidak ada di data,
saya punya sederetan tanggal dan nilai, setiap tanggal tidak selalu ada saat
dicari, bagaimana caranya agar nilai tanggal sebelumnya dari nilai yang dicari
menjadi hasil pencarian dari nilai tanggal yang tidak ada.
br,
odong nando
#yiv6246941896 #yiv6246941896 -- #yiv6246941896ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6246941896
#yiv6246941896ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6246941896
#yiv6246941896ygrp-mkp #yiv6246941896hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6246941896 #yiv6246941896ygrp-mkp #yiv6246941896ads
{margin-bottom:10px;}#yiv6246941896 #yiv6246941896ygrp-mkp .yiv6246941896ad
{padding:0 0;}#yiv6246941896 #yiv6246941896ygrp-mkp .yiv6246941896ad p
{margin:0;}#yiv6246941896 #yiv6246941896ygrp-mkp .yiv6246941896ad a
{color:#0000ff;text-decoration:none;}#yiv6246941896 #yiv6246941896ygrp-sponsor
#yiv6246941896ygrp-lc {font-family:Arial;}#yiv6246941896
#yiv6246941896ygrp-sponsor #yiv6246941896ygrp-lc #yiv6246941896hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6246941896
#yiv6246941896ygrp-sponsor #yiv6246941896ygrp-lc .yiv6246941896ad
{margin-bottom:10px;padding:0 0;}#yiv6246941896 #yiv6246941896actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6246941896
#yiv6246941896activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6246941896
#yiv6246941896activity span {font-weight:700;}#yiv6246941896
#yiv6246941896activity span:first-child
{text-transform:uppercase;}#yiv6246941896 #yiv6246941896activity span a
{color:#5085b6;text-decoration:none;}#yiv6246941896 #yiv6246941896activity span
span {color:#ff7900;}#yiv6246941896 #yiv6246941896activity span
.yiv6246941896underline {text-decoration:underline;}#yiv6246941896
.yiv6246941896attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6246941896 .yiv6246941896attach div a
{text-decoration:none;}#yiv6246941896 .yiv6246941896attach img
{border:none;padding-right:5px;}#yiv6246941896 .yiv6246941896attach label
{display:block;margin-bottom:5px;}#yiv6246941896 .yiv6246941896attach label a
{text-decoration:none;}#yiv6246941896 blockquote {margin:0 0 0
4px;}#yiv6246941896 .yiv6246941896bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6246941896
.yiv6246941896bold a {text-decoration:none;}#yiv6246941896 dd.yiv6246941896last
p a {font-family:Verdana;font-weight:700;}#yiv6246941896 dd.yiv6246941896last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6246941896
dd.yiv6246941896last p span.yiv6246941896yshortcuts
{margin-right:0;}#yiv6246941896 div.yiv6246941896attach-table div div a
{text-decoration:none;}#yiv6246941896 div.yiv6246941896attach-table
{width:400px;}#yiv6246941896 div.yiv6246941896file-title a, #yiv6246941896
div.yiv6246941896file-title a:active, #yiv6246941896
div.yiv6246941896file-title a:hover, #yiv6246941896 div.yiv6246941896file-title
a:visited {text-decoration:none;}#yiv6246941896 div.yiv6246941896photo-title a,
#yiv6246941896 div.yiv6246941896photo-title a:active, #yiv6246941896
div.yiv6246941896photo-title a:hover, #yiv6246941896
div.yiv6246941896photo-title a:visited {text-decoration:none;}#yiv6246941896
div#yiv6246941896ygrp-mlmsg #yiv6246941896ygrp-msg p a
span.yiv6246941896yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6246941896
.yiv6246941896green {color:#628c2a;}#yiv6246941896 .yiv6246941896MsoNormal
{margin:0 0 0 0;}#yiv6246941896 o {font-size:0;}#yiv6246941896
#yiv6246941896photos div {float:left;width:72px;}#yiv6246941896
#yiv6246941896photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6246941896
#yiv6246941896photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6246941896
#yiv6246941896reco-category {font-size:77%;}#yiv6246941896
#yiv6246941896reco-desc {font-size:77%;}#yiv6246941896 .yiv6246941896replbq
{margin:4px;}#yiv6246941896 #yiv6246941896ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6246941896 #yiv6246941896ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6246941896
#yiv6246941896ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6246941896
#yiv6246941896ygrp-mlmsg select, #yiv6246941896 input, #yiv6246941896 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6246941896
#yiv6246941896ygrp-mlmsg pre, #yiv6246941896 code {font:115%
monospace;}#yiv6246941896 #yiv6246941896ygrp-mlmsg *
{line-height:1.22em;}#yiv6246941896 #yiv6246941896ygrp-mlmsg #yiv6246941896logo
{padding-bottom:10px;}#yiv6246941896 #yiv6246941896ygrp-msg p a
{font-family:Verdana;}#yiv6246941896 #yiv6246941896ygrp-msg
p#yiv6246941896attach-count span {color:#1E66AE;font-weight:700;}#yiv6246941896
#yiv6246941896ygrp-reco #yiv6246941896reco-head
{color:#ff7900;font-weight:700;}#yiv6246941896 #yiv6246941896ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6246941896 #yiv6246941896ygrp-sponsor
#yiv6246941896ov li a {font-size:130%;text-decoration:none;}#yiv6246941896
#yiv6246941896ygrp-sponsor #yiv6246941896ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6246941896
#yiv6246941896ygrp-sponsor #yiv6246941896ov ul {margin:0;padding:0 0 0
8px;}#yiv6246941896 #yiv6246941896ygrp-text
{font-family:Georgia;}#yiv6246941896 #yiv6246941896ygrp-text p {margin:0 0 1em
0;}#yiv6246941896 #yiv6246941896ygrp-text tt {font-size:120%;}#yiv6246941896
#yiv6246941896ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6246941896
