Waalaikum salam Wr.Wb.
hai rian,
klo di lihat, pakai Hlookup bisa tuu... klo tau penggunaan VLOOKUP, coba deh
buat sendiri pake formula HLOOKUP di kasus anda ini, pada bagian "row index"
isi dengan row()-3....
selamat mencoba br,
odong nando
Dari: "Rian Sutarsa riansuta...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Rabu, 28 Maret 2018 17:50
Judul: [belajar-excel] Mengambil data per-bulan [1 Attachment]
Assalamualaikum Wr.Wb.Dear BeExceller mohon bantuannya mengenai formula
mengambil data ke bawah tergantung kriteria headernya.Untuk lebih jelasnya saya
sertakan file nya. Terimakasih Wassalamualaikum Wr.Wb. #yiv7189034596
#yiv7189034596 -- #yiv7189034596ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7189034596
#yiv7189034596ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7189034596
#yiv7189034596ygrp-mkp #yiv7189034596hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7189034596 #yiv7189034596ygrp-mkp #yiv7189034596ads
{margin-bottom:10px;}#yiv7189034596 #yiv7189034596ygrp-mkp .yiv7189034596ad
{padding:0 0;}#yiv7189034596 #yiv7189034596ygrp-mkp .yiv7189034596ad p
{margin:0;}#yiv7189034596 #yiv7189034596ygrp-mkp .yiv7189034596ad a
{color:#0000ff;text-decoration:none;}#yiv7189034596 #yiv7189034596ygrp-sponsor
#yiv7189034596ygrp-lc {font-family:Arial;}#yiv7189034596
#yiv7189034596ygrp-sponsor #yiv7189034596ygrp-lc #yiv7189034596hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7189034596
#yiv7189034596ygrp-sponsor #yiv7189034596ygrp-lc .yiv7189034596ad
{margin-bottom:10px;padding:0 0;}#yiv7189034596 #yiv7189034596actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7189034596
#yiv7189034596activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7189034596
#yiv7189034596activity span {font-weight:700;}#yiv7189034596
#yiv7189034596activity span:first-child
{text-transform:uppercase;}#yiv7189034596 #yiv7189034596activity span a
{color:#5085b6;text-decoration:none;}#yiv7189034596 #yiv7189034596activity span
span {color:#ff7900;}#yiv7189034596 #yiv7189034596activity span
.yiv7189034596underline {text-decoration:underline;}#yiv7189034596
.yiv7189034596attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7189034596 .yiv7189034596attach div a
{text-decoration:none;}#yiv7189034596 .yiv7189034596attach img
{border:none;padding-right:5px;}#yiv7189034596 .yiv7189034596attach label
{display:block;margin-bottom:5px;}#yiv7189034596 .yiv7189034596attach label a
{text-decoration:none;}#yiv7189034596 blockquote {margin:0 0 0
4px;}#yiv7189034596 .yiv7189034596bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7189034596
.yiv7189034596bold a {text-decoration:none;}#yiv7189034596 dd.yiv7189034596last
p a {font-family:Verdana;font-weight:700;}#yiv7189034596 dd.yiv7189034596last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7189034596
dd.yiv7189034596last p span.yiv7189034596yshortcuts
{margin-right:0;}#yiv7189034596 div.yiv7189034596attach-table div div a
{text-decoration:none;}#yiv7189034596 div.yiv7189034596attach-table
{width:400px;}#yiv7189034596 div.yiv7189034596file-title a, #yiv7189034596
div.yiv7189034596file-title a:active, #yiv7189034596
div.yiv7189034596file-title a:hover, #yiv7189034596 div.yiv7189034596file-title
a:visited {text-decoration:none;}#yiv7189034596 div.yiv7189034596photo-title a,
#yiv7189034596 div.yiv7189034596photo-title a:active, #yiv7189034596
div.yiv7189034596photo-title a:hover, #yiv7189034596
div.yiv7189034596photo-title a:visited {text-decoration:none;}#yiv7189034596
div#yiv7189034596ygrp-mlmsg #yiv7189034596ygrp-msg p a
span.yiv7189034596yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7189034596
.yiv7189034596green {color:#628c2a;}#yiv7189034596 .yiv7189034596MsoNormal
{margin:0 0 0 0;}#yiv7189034596 o {font-size:0;}#yiv7189034596
#yiv7189034596photos div {float:left;width:72px;}#yiv7189034596
#yiv7189034596photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7189034596
#yiv7189034596photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7189034596
#yiv7189034596reco-category {font-size:77%;}#yiv7189034596
#yiv7189034596reco-desc {font-size:77%;}#yiv7189034596 .yiv7189034596replbq
{margin:4px;}#yiv7189034596 #yiv7189034596ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7189034596 #yiv7189034596ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7189034596
#yiv7189034596ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7189034596
#yiv7189034596ygrp-mlmsg select, #yiv7189034596 input, #yiv7189034596 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7189034596
#yiv7189034596ygrp-mlmsg pre, #yiv7189034596 code {font:115%
monospace;}#yiv7189034596 #yiv7189034596ygrp-mlmsg *
{line-height:1.22em;}#yiv7189034596 #yiv7189034596ygrp-mlmsg #yiv7189034596logo
{padding-bottom:10px;}#yiv7189034596 #yiv7189034596ygrp-msg p a
{font-family:Verdana;}#yiv7189034596 #yiv7189034596ygrp-msg
p#yiv7189034596attach-count span {color:#1E66AE;font-weight:700;}#yiv7189034596
#yiv7189034596ygrp-reco #yiv7189034596reco-head
{color:#ff7900;font-weight:700;}#yiv7189034596 #yiv7189034596ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7189034596 #yiv7189034596ygrp-sponsor
#yiv7189034596ov li a {font-size:130%;text-decoration:none;}#yiv7189034596
#yiv7189034596ygrp-sponsor #yiv7189034596ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7189034596
#yiv7189034596ygrp-sponsor #yiv7189034596ov ul {margin:0;padding:0 0 0
8px;}#yiv7189034596 #yiv7189034596ygrp-text
{font-family:Georgia;}#yiv7189034596 #yiv7189034596ygrp-text p {margin:0 0 1em
0;}#yiv7189034596 #yiv7189034596ygrp-text tt {font-size:120%;}#yiv7189034596
#yiv7189034596ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7189034596
