AssalamualaikumPak Kid
Terimakasih banyak, Baik Pak
Wassalamualaikum
Pada Minggu, 26 Maret 2017 23:16, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa'alaikumussalam wr wb
Pak Hairul,
Coba dicek lagi penulisan formulanya.
fyi,
Kedua formula memiliki bunyi yang sama. Perbedaannya adalah kolom yang harus
diambil menjadi hasil formula.
Jadi, jika hasil formula ada yang tidak tepat, maka max date dan nilai pasti
menghasilkan nilai yang tidak tepat secara serentak.
Wassalamu'alaikum wr wb
Kid
On Sun, Mar 26, 2017 at 9:54 PM, HAIRUL ALAM [email protected]
[belajar-excel] <[email protected]> wrote:
AssalamualaikumPak Kid
Sudah saya coba dengan formula :Max Date : =LOOKUP(9^9,INDEX($C$6:$E$15,
0,MATCH($G5,$C$5:$E$5,0)),$B$ 6:$B$15)
hasil dari formula tersebut 06-jan-00 yang seharusnya pada data di tanggal
06-dec-11dan untuk formula nilai Nilai : =LOOKUP(9^9,INDEX($C$6:$E$15,
0,MATCH($G5,$C$5:$E$5,0))) hasil sudah sesuai data.
Maaf Pak, Saya sudah mengganggu waktunya, Terimakasih banyak pencerahannya
WassalamualaikumHairul Alam
Pada Minggu, 26 Maret 2017 21:40, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected] > menulis:
Wa'alaikumussalam wr wb
Hai Hairul,
Fungsi LookUp bisa dimanfaatkan pada kasus ini.
Max Date : =LOOKUP(9^9,INDEX($C$6:$E$15, 0,MATCH($G5,$C$5:$E$5,0)),$B$ 6:$B$15)
Nilai : =LOOKUP(9^9,INDEX($C$6:$E$15, 0,MATCH($G5,$C$5:$E$5,0)))
Wassalamu'alaikum wr wb
Kid
2017-03-26 14:30 GMT+07:00 HAIRUL ALAM [email protected] [belajar-excel]
<[email protected] >:
AssalamualaikumPara Master
Mohon Pencerahannya
Terlampir contoh data, Saya hendak menentukan tanggal terakhir dari beberapa
kode, bagaimanakah formulanya ?
WassalamualaikumHairul Alam
#yiv6401475785 #yiv6401475785 -- #yiv6401475785ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6401475785
#yiv6401475785ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6401475785
#yiv6401475785ygrp-mkp #yiv6401475785hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6401475785 #yiv6401475785ygrp-mkp #yiv6401475785ads
{margin-bottom:10px;}#yiv6401475785 #yiv6401475785ygrp-mkp .yiv6401475785ad
{padding:0 0;}#yiv6401475785 #yiv6401475785ygrp-mkp .yiv6401475785ad p
{margin:0;}#yiv6401475785 #yiv6401475785ygrp-mkp .yiv6401475785ad a
{color:#0000ff;text-decoration:none;}#yiv6401475785 #yiv6401475785ygrp-sponsor
#yiv6401475785ygrp-lc {font-family:Arial;}#yiv6401475785
#yiv6401475785ygrp-sponsor #yiv6401475785ygrp-lc #yiv6401475785hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6401475785
#yiv6401475785ygrp-sponsor #yiv6401475785ygrp-lc .yiv6401475785ad
{margin-bottom:10px;padding:0 0;}#yiv6401475785 #yiv6401475785actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6401475785
#yiv6401475785activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6401475785
#yiv6401475785activity span {font-weight:700;}#yiv6401475785
#yiv6401475785activity span:first-child
{text-transform:uppercase;}#yiv6401475785 #yiv6401475785activity span a
{color:#5085b6;text-decoration:none;}#yiv6401475785 #yiv6401475785activity span
span {color:#ff7900;}#yiv6401475785 #yiv6401475785activity span
.yiv6401475785underline {text-decoration:underline;}#yiv6401475785
.yiv6401475785attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6401475785 .yiv6401475785attach div a
{text-decoration:none;}#yiv6401475785 .yiv6401475785attach img
{border:none;padding-right:5px;}#yiv6401475785 .yiv6401475785attach label
{display:block;margin-bottom:5px;}#yiv6401475785 .yiv6401475785attach label a
{text-decoration:none;}#yiv6401475785 blockquote {margin:0 0 0
4px;}#yiv6401475785 .yiv6401475785bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6401475785
.yiv6401475785bold a {text-decoration:none;}#yiv6401475785 dd.yiv6401475785last
p a {font-family:Verdana;font-weight:700;}#yiv6401475785 dd.yiv6401475785last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6401475785
dd.yiv6401475785last p span.yiv6401475785yshortcuts
{margin-right:0;}#yiv6401475785 div.yiv6401475785attach-table div div a
{text-decoration:none;}#yiv6401475785 div.yiv6401475785attach-table
{width:400px;}#yiv6401475785 div.yiv6401475785file-title a, #yiv6401475785
div.yiv6401475785file-title a:active, #yiv6401475785
div.yiv6401475785file-title a:hover, #yiv6401475785 div.yiv6401475785file-title
a:visited {text-decoration:none;}#yiv6401475785 div.yiv6401475785photo-title a,
#yiv6401475785 div.yiv6401475785photo-title a:active, #yiv6401475785
div.yiv6401475785photo-title a:hover, #yiv6401475785
div.yiv6401475785photo-title a:visited {text-decoration:none;}#yiv6401475785
div#yiv6401475785ygrp-mlmsg #yiv6401475785ygrp-msg p a
span.yiv6401475785yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6401475785
.yiv6401475785green {color:#628c2a;}#yiv6401475785 .yiv6401475785MsoNormal
{margin:0 0 0 0;}#yiv6401475785 o {font-size:0;}#yiv6401475785
#yiv6401475785photos div {float:left;width:72px;}#yiv6401475785
#yiv6401475785photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6401475785
#yiv6401475785photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6401475785
#yiv6401475785reco-category {font-size:77%;}#yiv6401475785
#yiv6401475785reco-desc {font-size:77%;}#yiv6401475785 .yiv6401475785replbq
{margin:4px;}#yiv6401475785 #yiv6401475785ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6401475785 #yiv6401475785ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6401475785
#yiv6401475785ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6401475785
#yiv6401475785ygrp-mlmsg select, #yiv6401475785 input, #yiv6401475785 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6401475785
#yiv6401475785ygrp-mlmsg pre, #yiv6401475785 code {font:115%
monospace;}#yiv6401475785 #yiv6401475785ygrp-mlmsg *
{line-height:1.22em;}#yiv6401475785 #yiv6401475785ygrp-mlmsg #yiv6401475785logo
{padding-bottom:10px;}#yiv6401475785 #yiv6401475785ygrp-msg p a
{font-family:Verdana;}#yiv6401475785 #yiv6401475785ygrp-msg
p#yiv6401475785attach-count span {color:#1E66AE;font-weight:700;}#yiv6401475785
#yiv6401475785ygrp-reco #yiv6401475785reco-head
{color:#ff7900;font-weight:700;}#yiv6401475785 #yiv6401475785ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6401475785 #yiv6401475785ygrp-sponsor
#yiv6401475785ov li a {font-size:130%;text-decoration:none;}#yiv6401475785
#yiv6401475785ygrp-sponsor #yiv6401475785ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6401475785
#yiv6401475785ygrp-sponsor #yiv6401475785ov ul {margin:0;padding:0 0 0
8px;}#yiv6401475785 #yiv6401475785ygrp-text
{font-family:Georgia;}#yiv6401475785 #yiv6401475785ygrp-text p {margin:0 0 1em
0;}#yiv6401475785 #yiv6401475785ygrp-text tt {font-size:120%;}#yiv6401475785
#yiv6401475785ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6401475785
