Bls: [belajar-excel] Cara Menampilkan data dari 2 tabel secara urut berdasarkan tanggal muda ke tua [1 Attachment]

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] Cara Menampilkan data dari 2 tabel secara urut berdasarkan tanggal muda ke tua [1 Attachment]

Milis Belajar Excel mailing list


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 [hidden email] [belajar-excel]" <[hidden email]> 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 (17K) Download Attachment
Loading...