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