trimakasih mas susilo...jadi variatif sekali ya, banyak yang memberikan
solusi.... :) br,
odong nando
Pada Senin, 29 Februari 2016 12:24, "Susilo - [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Odong
Saya menggunakan fungsi max yang di arraySemoga sesuai dengan harapan
Silakan merujuk pada file berikutTerima kasih
Pada 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
#yiv1736312620 #yiv1736312620 -- #yiv1736312620ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1736312620
#yiv1736312620ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1736312620
#yiv1736312620ygrp-mkp #yiv1736312620hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1736312620 #yiv1736312620ygrp-mkp #yiv1736312620ads
{margin-bottom:10px;}#yiv1736312620 #yiv1736312620ygrp-mkp .yiv1736312620ad
{padding:0 0;}#yiv1736312620 #yiv1736312620ygrp-mkp .yiv1736312620ad p
{margin:0;}#yiv1736312620 #yiv1736312620ygrp-mkp .yiv1736312620ad a
{color:#0000ff;text-decoration:none;}#yiv1736312620 #yiv1736312620ygrp-sponsor
#yiv1736312620ygrp-lc {font-family:Arial;}#yiv1736312620
#yiv1736312620ygrp-sponsor #yiv1736312620ygrp-lc #yiv1736312620hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1736312620
#yiv1736312620ygrp-sponsor #yiv1736312620ygrp-lc .yiv1736312620ad
{margin-bottom:10px;padding:0 0;}#yiv1736312620 #yiv1736312620actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1736312620
#yiv1736312620activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1736312620
#yiv1736312620activity span {font-weight:700;}#yiv1736312620
#yiv1736312620activity span:first-child
{text-transform:uppercase;}#yiv1736312620 #yiv1736312620activity span a
{color:#5085b6;text-decoration:none;}#yiv1736312620 #yiv1736312620activity span
span {color:#ff7900;}#yiv1736312620 #yiv1736312620activity span
.yiv1736312620underline {text-decoration:underline;}#yiv1736312620
.yiv1736312620attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1736312620 .yiv1736312620attach div a
{text-decoration:none;}#yiv1736312620 .yiv1736312620attach img
{border:none;padding-right:5px;}#yiv1736312620 .yiv1736312620attach label
{display:block;margin-bottom:5px;}#yiv1736312620 .yiv1736312620attach label a
{text-decoration:none;}#yiv1736312620 blockquote {margin:0 0 0
4px;}#yiv1736312620 .yiv1736312620bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1736312620
.yiv1736312620bold a {text-decoration:none;}#yiv1736312620 dd.yiv1736312620last
p a {font-family:Verdana;font-weight:700;}#yiv1736312620 dd.yiv1736312620last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1736312620
dd.yiv1736312620last p span.yiv1736312620yshortcuts
{margin-right:0;}#yiv1736312620 div.yiv1736312620attach-table div div a
{text-decoration:none;}#yiv1736312620 div.yiv1736312620attach-table
{width:400px;}#yiv1736312620 div.yiv1736312620file-title a, #yiv1736312620
div.yiv1736312620file-title a:active, #yiv1736312620
div.yiv1736312620file-title a:hover, #yiv1736312620 div.yiv1736312620file-title
a:visited {text-decoration:none;}#yiv1736312620 div.yiv1736312620photo-title a,
#yiv1736312620 div.yiv1736312620photo-title a:active, #yiv1736312620
div.yiv1736312620photo-title a:hover, #yiv1736312620
div.yiv1736312620photo-title a:visited {text-decoration:none;}#yiv1736312620
div#yiv1736312620ygrp-mlmsg #yiv1736312620ygrp-msg p a
span.yiv1736312620yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1736312620
.yiv1736312620green {color:#628c2a;}#yiv1736312620 .yiv1736312620MsoNormal
{margin:0 0 0 0;}#yiv1736312620 o {font-size:0;}#yiv1736312620
#yiv1736312620photos div {float:left;width:72px;}#yiv1736312620
#yiv1736312620photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1736312620
#yiv1736312620photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1736312620
#yiv1736312620reco-category {font-size:77%;}#yiv1736312620
#yiv1736312620reco-desc {font-size:77%;}#yiv1736312620 .yiv1736312620replbq
{margin:4px;}#yiv1736312620 #yiv1736312620ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1736312620 #yiv1736312620ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1736312620
#yiv1736312620ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1736312620
#yiv1736312620ygrp-mlmsg select, #yiv1736312620 input, #yiv1736312620 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1736312620
#yiv1736312620ygrp-mlmsg pre, #yiv1736312620 code {font:115%
monospace;}#yiv1736312620 #yiv1736312620ygrp-mlmsg *
{line-height:1.22em;}#yiv1736312620 #yiv1736312620ygrp-mlmsg #yiv1736312620logo
{padding-bottom:10px;}#yiv1736312620 #yiv1736312620ygrp-msg p a
{font-family:Verdana;}#yiv1736312620 #yiv1736312620ygrp-msg
p#yiv1736312620attach-count span {color:#1E66AE;font-weight:700;}#yiv1736312620
#yiv1736312620ygrp-reco #yiv1736312620reco-head
{color:#ff7900;font-weight:700;}#yiv1736312620 #yiv1736312620ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1736312620 #yiv1736312620ygrp-sponsor
#yiv1736312620ov li a {font-size:130%;text-decoration:none;}#yiv1736312620
#yiv1736312620ygrp-sponsor #yiv1736312620ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1736312620
#yiv1736312620ygrp-sponsor #yiv1736312620ov ul {margin:0;padding:0 0 0
8px;}#yiv1736312620 #yiv1736312620ygrp-text
{font-family:Georgia;}#yiv1736312620 #yiv1736312620ygrp-text p {margin:0 0 1em
0;}#yiv1736312620 #yiv1736312620ygrp-text tt {font-size:120%;}#yiv1736312620
#yiv1736312620ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1736312620
