assalamu'alaikum wr.wb
kalau begitu boleh dilampirin ajah pak Teuku agar lebih jelas dan tidak terjadi
salah paham.(bila ada data rahasia bisa di replace saja sesuai keinginan) agar
para master excel juga bakalan turun gunung :).
wassalamfahmi
Pada Kamis, 11 Agustus 2016 19:01, "Teuku Machfud aku.ma...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Bener Pak Fahmi, saya pakai exact match.
WslmTeuku
Sent from my BlackBerry 10 smartphone on the Telkomsel network.
| From: Fahmi Syaifullah fahmisyaifulla...@yahoo.com [belajar-excel]Sent:
Thursday, 11 August, 2016 10:29To: belajar-excel@yahoogroups.comReply To:
belajar-excel@yahoogroups.comSubject: Bls: [belajar-excel] fitur insert table
dan array formula |
Wa'alaikumsalam
Pak TeukuPakai jawaban newbi yak. Siapa tau bener. Hihi
boleh di jabarin rumus V lookupnya gk?.. Karna dibagian Vlookup ada yg namanya
approcimate macth dan exact match (kalo gak salah ya itu juga) di bagian
akhir.mudah2an sih bener ya. Hehe..
Wassalamtrima kasihfahmi
Dikirim dari Yahoo Mail di Android
Assalamu'alaikum wr.wb,
Rekan2, Saya ada file excel yang mengunakan fitur array formula seperti v
lookup, index, match. Tadinya saya menggunakan filter dari ribbon data, untuk
mensortir data. Saya membaca postingan mas Kid soal insert table. Singkatnya
sya ubah menjadi insert table.
Sya punya 2 sheet, salah satunya bank data yang menggunakan filter satunya lagi
"insert table" nah disini suka ngak matching pengambilan data dengan vlookup.
Apa harus seragam (sama2 insert table)?
Sekian, thanks.
WslmTeuku
Sent from my BlackBerry 10 smartphone on the Telkomsel network.
#yiv8268771712 #yiv8268771712 -- #yiv8268771712ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8268771712
#yiv8268771712ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8268771712
#yiv8268771712ygrp-mkp #yiv8268771712hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8268771712 #yiv8268771712ygrp-mkp #yiv8268771712ads
{margin-bottom:10px;}#yiv8268771712 #yiv8268771712ygrp-mkp .yiv8268771712ad
{padding:0 0;}#yiv8268771712 #yiv8268771712ygrp-mkp .yiv8268771712ad p
{margin:0;}#yiv8268771712 #yiv8268771712ygrp-mkp .yiv8268771712ad a
{color:#0000ff;text-decoration:none;}#yiv8268771712 #yiv8268771712ygrp-sponsor
#yiv8268771712ygrp-lc {font-family:Arial;}#yiv8268771712
#yiv8268771712ygrp-sponsor #yiv8268771712ygrp-lc #yiv8268771712hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8268771712
#yiv8268771712ygrp-sponsor #yiv8268771712ygrp-lc .yiv8268771712ad
{margin-bottom:10px;padding:0 0;}#yiv8268771712 #yiv8268771712actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8268771712
#yiv8268771712activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8268771712
#yiv8268771712activity span {font-weight:700;}#yiv8268771712
#yiv8268771712activity span:first-child
{text-transform:uppercase;}#yiv8268771712 #yiv8268771712activity span a
{color:#5085b6;text-decoration:none;}#yiv8268771712 #yiv8268771712activity span
span {color:#ff7900;}#yiv8268771712 #yiv8268771712activity span
.yiv8268771712underline {text-decoration:underline;}#yiv8268771712
.yiv8268771712attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8268771712 .yiv8268771712attach div a
{text-decoration:none;}#yiv8268771712 .yiv8268771712attach img
{border:none;padding-right:5px;}#yiv8268771712 .yiv8268771712attach label
{display:block;margin-bottom:5px;}#yiv8268771712 .yiv8268771712attach label a
{text-decoration:none;}#yiv8268771712 blockquote {margin:0 0 0
4px;}#yiv8268771712 .yiv8268771712bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8268771712
.yiv8268771712bold a {text-decoration:none;}#yiv8268771712 dd.yiv8268771712last
p a {font-family:Verdana;font-weight:700;}#yiv8268771712 dd.yiv8268771712last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8268771712
dd.yiv8268771712last p span.yiv8268771712yshortcuts
{margin-right:0;}#yiv8268771712 div.yiv8268771712attach-table div div a
{text-decoration:none;}#yiv8268771712 div.yiv8268771712attach-table
{width:400px;}#yiv8268771712 div.yiv8268771712file-title a, #yiv8268771712
div.yiv8268771712file-title a:active, #yiv8268771712
div.yiv8268771712file-title a:hover, #yiv8268771712 div.yiv8268771712file-title
a:visited {text-decoration:none;}#yiv8268771712 div.yiv8268771712photo-title a,
#yiv8268771712 div.yiv8268771712photo-title a:active, #yiv8268771712
div.yiv8268771712photo-title a:hover, #yiv8268771712
div.yiv8268771712photo-title a:visited {text-decoration:none;}#yiv8268771712
div#yiv8268771712ygrp-mlmsg #yiv8268771712ygrp-msg p a
span.yiv8268771712yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8268771712
.yiv8268771712green {color:#628c2a;}#yiv8268771712 .yiv8268771712MsoNormal
{margin:0 0 0 0;}#yiv8268771712 o {font-size:0;}#yiv8268771712
#yiv8268771712photos div {float:left;width:72px;}#yiv8268771712
#yiv8268771712photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8268771712
#yiv8268771712photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8268771712
#yiv8268771712reco-category {font-size:77%;}#yiv8268771712
#yiv8268771712reco-desc {font-size:77%;}#yiv8268771712 .yiv8268771712replbq
{margin:4px;}#yiv8268771712 #yiv8268771712ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8268771712 #yiv8268771712ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8268771712
#yiv8268771712ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8268771712
#yiv8268771712ygrp-mlmsg select, #yiv8268771712 input, #yiv8268771712 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8268771712
#yiv8268771712ygrp-mlmsg pre, #yiv8268771712 code {font:115%
monospace;}#yiv8268771712 #yiv8268771712ygrp-mlmsg *
{line-height:1.22em;}#yiv8268771712 #yiv8268771712ygrp-mlmsg #yiv8268771712logo
{padding-bottom:10px;}#yiv8268771712 #yiv8268771712ygrp-msg p a
{font-family:Verdana;}#yiv8268771712 #yiv8268771712ygrp-msg
p#yiv8268771712attach-count span {color:#1E66AE;font-weight:700;}#yiv8268771712
#yiv8268771712ygrp-reco #yiv8268771712reco-head
{color:#ff7900;font-weight:700;}#yiv8268771712 #yiv8268771712ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8268771712 #yiv8268771712ygrp-sponsor
#yiv8268771712ov li a {font-size:130%;text-decoration:none;}#yiv8268771712
#yiv8268771712ygrp-sponsor #yiv8268771712ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8268771712
#yiv8268771712ygrp-sponsor #yiv8268771712ov ul {margin:0;padding:0 0 0
8px;}#yiv8268771712 #yiv8268771712ygrp-text
{font-family:Georgia;}#yiv8268771712 #yiv8268771712ygrp-text p {margin:0 0 1em
0;}#yiv8268771712 #yiv8268771712ygrp-text tt {font-size:120%;}#yiv8268771712
#yiv8268771712ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8268771712
