assalamu'alaikum wr.wb Pak MARCO SLX coba baca-baca di blog mr kid biar bisa lebih ber inovasi. dengan kata kunci formula filter data.file terlampir dengan persyaratan mempunyai 2 tabel berbeda (seperti tabel rujukan rumus) tidak bisa dijadikan 1 tabel karna pengetahuan saya, mngkin master lain bisa membantu
mudah2an membantu.
wassalamu'alaikum wr.wb fahmi
Pada Sabtu, 6 Mei 2017 14:24, "Marco Slx [email protected]
[belajar-excel]" <[email protected]> menulis:
Mohon bantuannya master, saya ingin membuat suatu tabel yang akan
menampilkan data dari 2 tabel, namun berurutan dari tanggal muda hingga ke tua,
ma'f saya kurang pandai dalam menjelaskan detailnya, namun file terlampir
semoga saja bisa master" mengerti maksud saya.
Lampiran file excel terlampir,
Demikian saya sampaikan,
Terima kasih,
Salam,
MARCO SLX #yiv1140965742 -- #yiv1140965742ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1140965742
#yiv1140965742ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1140965742
#yiv1140965742ygrp-mkp #yiv1140965742hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1140965742 #yiv1140965742ygrp-mkp #yiv1140965742ads
{margin-bottom:10px;}#yiv1140965742 #yiv1140965742ygrp-mkp .yiv1140965742ad
{padding:0 0;}#yiv1140965742 #yiv1140965742ygrp-mkp .yiv1140965742ad p
{margin:0;}#yiv1140965742 #yiv1140965742ygrp-mkp .yiv1140965742ad a
{color:#0000ff;text-decoration:none;}#yiv1140965742 #yiv1140965742ygrp-sponsor
#yiv1140965742ygrp-lc {font-family:Arial;}#yiv1140965742
#yiv1140965742ygrp-sponsor #yiv1140965742ygrp-lc #yiv1140965742hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1140965742
#yiv1140965742ygrp-sponsor #yiv1140965742ygrp-lc .yiv1140965742ad
{margin-bottom:10px;padding:0 0;}#yiv1140965742 #yiv1140965742actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1140965742
#yiv1140965742activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1140965742
#yiv1140965742activity span {font-weight:700;}#yiv1140965742
#yiv1140965742activity span:first-child
{text-transform:uppercase;}#yiv1140965742 #yiv1140965742activity span a
{color:#5085b6;text-decoration:none;}#yiv1140965742 #yiv1140965742activity span
span {color:#ff7900;}#yiv1140965742 #yiv1140965742activity span
.yiv1140965742underline {text-decoration:underline;}#yiv1140965742
.yiv1140965742attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1140965742 .yiv1140965742attach div a
{text-decoration:none;}#yiv1140965742 .yiv1140965742attach img
{border:none;padding-right:5px;}#yiv1140965742 .yiv1140965742attach label
{display:block;margin-bottom:5px;}#yiv1140965742 .yiv1140965742attach label a
{text-decoration:none;}#yiv1140965742 blockquote {margin:0 0 0
4px;}#yiv1140965742 .yiv1140965742bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1140965742
.yiv1140965742bold a {text-decoration:none;}#yiv1140965742 dd.yiv1140965742last
p a {font-family:Verdana;font-weight:700;}#yiv1140965742 dd.yiv1140965742last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1140965742
dd.yiv1140965742last p span.yiv1140965742yshortcuts
{margin-right:0;}#yiv1140965742 div.yiv1140965742attach-table div div a
{text-decoration:none;}#yiv1140965742 div.yiv1140965742attach-table
{width:400px;}#yiv1140965742 div.yiv1140965742file-title a, #yiv1140965742
div.yiv1140965742file-title a:active, #yiv1140965742
div.yiv1140965742file-title a:hover, #yiv1140965742 div.yiv1140965742file-title
a:visited {text-decoration:none;}#yiv1140965742 div.yiv1140965742photo-title a,
#yiv1140965742 div.yiv1140965742photo-title a:active, #yiv1140965742
div.yiv1140965742photo-title a:hover, #yiv1140965742
div.yiv1140965742photo-title a:visited {text-decoration:none;}#yiv1140965742
div#yiv1140965742ygrp-mlmsg #yiv1140965742ygrp-msg p a
span.yiv1140965742yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1140965742
.yiv1140965742green {color:#628c2a;}#yiv1140965742 .yiv1140965742MsoNormal
{margin:0 0 0 0;}#yiv1140965742 o {font-size:0;}#yiv1140965742
#yiv1140965742photos div {float:left;width:72px;}#yiv1140965742
#yiv1140965742photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1140965742
#yiv1140965742photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1140965742
#yiv1140965742reco-category {font-size:77%;}#yiv1140965742
#yiv1140965742reco-desc {font-size:77%;}#yiv1140965742 .yiv1140965742replbq
{margin:4px;}#yiv1140965742 #yiv1140965742ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1140965742 #yiv1140965742ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1140965742
#yiv1140965742ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1140965742
#yiv1140965742ygrp-mlmsg select, #yiv1140965742 input, #yiv1140965742 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1140965742
#yiv1140965742ygrp-mlmsg pre, #yiv1140965742 code {font:115%
monospace;}#yiv1140965742 #yiv1140965742ygrp-mlmsg *
{line-height:1.22em;}#yiv1140965742 #yiv1140965742ygrp-mlmsg #yiv1140965742logo
{padding-bottom:10px;}#yiv1140965742 #yiv1140965742ygrp-msg p a
{font-family:Verdana;}#yiv1140965742 #yiv1140965742ygrp-msg
p#yiv1140965742attach-count span {color:#1E66AE;font-weight:700;}#yiv1140965742
#yiv1140965742ygrp-reco #yiv1140965742reco-head
{color:#ff7900;font-weight:700;}#yiv1140965742 #yiv1140965742ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1140965742 #yiv1140965742ygrp-sponsor
#yiv1140965742ov li a {font-size:130%;text-decoration:none;}#yiv1140965742
#yiv1140965742ygrp-sponsor #yiv1140965742ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1140965742
#yiv1140965742ygrp-sponsor #yiv1140965742ov ul {margin:0;padding:0 0 0
8px;}#yiv1140965742 #yiv1140965742ygrp-text
{font-family:Georgia;}#yiv1140965742 #yiv1140965742ygrp-text p {margin:0 0 1em
0;}#yiv1140965742 #yiv1140965742ygrp-text tt {font-size:120%;}#yiv1140965742
#yiv1140965742ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1140965742
Mengurutkan data berdasarkan tanggal dari 2 tabel.xlsx
Description: MS-Excel 2007 spreadsheet
