[belajar-excel] Cara Menampilkan Banyak Data Dengan 1 Primary [1 Attachment]

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

[belajar-excel] Cara Menampilkan Banyak Data Dengan 1 Primary [1 Attachment]

Milis Belajar Excel mailing list
Dear Master-Master,


Mohon bantuannya, bagaimana menampilkan banyak data dengan 1 primary,  sebagai contoh disini saya ingin menampilkan pengeluaran barang, yang diinginkan adalah, ketika kita memasukkan kode barang, maka akan muncul semua barang yang pernah keluar dengan kode barang yang sama...


Demikian disampaikan lebih jelasnya lampiran excel terlampir...


Salam,
Marco

CARA MENAMPILKAN BANYAK DATA DENGAN 1 PRIMARY DI EXCEL.xlsx (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [belajar-excel] Cara Menampilkan Banyak Data Dengan 1 Primary [1 Attachment]

Milis Belajar Excel mailing list
Yth. Rekan Be-Exceler
nyoba menjawab yaa ..
file terlampir .. 


    On Wednesday, June 7, 2017 2:58 PM, "Marco Slx [hidden email] [belajar-excel]" <[hidden email]> wrote:



     Dear Master-Master,


Mohon bantuannya, bagaimana menampilkan banyak data dengan 1 primary, sebagai contoh disini saya ingin menampilkan pengeluaran barang, yang diinginkan adalah, ketika kita memasukkan kode barang, maka akan muncul semua barang yang pernah keluar dengan kode barang yang sama...


Demikian disampaikan lebih jelasnya lampiran excel terlampir...


Salam,
Marco  #yiv0669714191 #yiv0669714191 -- #yiv0669714191ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0669714191 #yiv0669714191ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0669714191 #yiv0669714191ygrp-mkp #yiv0669714191hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0669714191 #yiv0669714191ygrp-mkp #yiv0669714191ads {margin-bottom:10px;}#yiv0669714191 #yiv0669714191ygrp-mkp .yiv0669714191ad {padding:0 0;}#yiv0669714191 #yiv0669714191ygrp-mkp .yiv0669714191ad p {margin:0;}#yiv0669714191 #yiv0669714191ygrp-mkp .yiv0669714191ad a {color:#0000ff;text-decoration:none;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ygrp-lc {font-family:Arial;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ygrp-lc #yiv0669714191hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ygrp-lc .yiv0669714191ad {margin-bottom:10px;padding:0 0;}#yiv0669714191 #yiv0669714191actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0669714191 #yiv0669714191activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0669714191 #yiv0669714191activity span {font-weight:700;}#yiv0669714191 #yiv0669714191activity span:first-child {text-transform:uppercase;}#yiv0669714191 #yiv0669714191activity span a {color:#5085b6;text-decoration:none;}#yiv0669714191 #yiv0669714191activity span span {color:#ff7900;}#yiv0669714191 #yiv0669714191activity span .yiv0669714191underline {text-decoration:underline;}#yiv0669714191 .yiv0669714191attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0669714191 .yiv0669714191attach div a {text-decoration:none;}#yiv0669714191 .yiv0669714191attach img {border:none;padding-right:5px;}#yiv0669714191 .yiv0669714191attach label {display:block;margin-bottom:5px;}#yiv0669714191 .yiv0669714191attach label a {text-decoration:none;}#yiv0669714191 blockquote {margin:0 0 0 4px;}#yiv0669714191 .yiv0669714191bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0669714191 .yiv0669714191bold a {text-decoration:none;}#yiv0669714191 dd.yiv0669714191last p a {font-family:Verdana;font-weight:700;}#yiv0669714191 dd.yiv0669714191last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0669714191 dd.yiv0669714191last p span.yiv0669714191yshortcuts {margin-right:0;}#yiv0669714191 div.yiv0669714191attach-table div div a {text-decoration:none;}#yiv0669714191 div.yiv0669714191attach-table {width:400px;}#yiv0669714191 div.yiv0669714191file-title a, #yiv0669714191 div.yiv0669714191file-title a:active, #yiv0669714191 div.yiv0669714191file-title a:hover, #yiv0669714191 div.yiv0669714191file-title a:visited {text-decoration:none;}#yiv0669714191 div.yiv0669714191photo-title a, #yiv0669714191 div.yiv0669714191photo-title a:active, #yiv0669714191 div.yiv0669714191photo-title a:hover, #yiv0669714191 div.yiv0669714191photo-title a:visited {text-decoration:none;}#yiv0669714191 div#yiv0669714191ygrp-mlmsg #yiv0669714191ygrp-msg p a span.yiv0669714191yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0669714191 .yiv0669714191green {color:#628c2a;}#yiv0669714191 .yiv0669714191MsoNormal {margin:0 0 0 0;}#yiv0669714191 o {font-size:0;}#yiv0669714191 #yiv0669714191photos div {float:left;width:72px;}#yiv0669714191 #yiv0669714191photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0669714191 #yiv0669714191photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0669714191 #yiv0669714191reco-category {font-size:77%;}#yiv0669714191 #yiv0669714191reco-desc {font-size:77%;}#yiv0669714191 .yiv0669714191replbq {margin:4px;}#yiv0669714191 #yiv0669714191ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0669714191 #yiv0669714191ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0669714191 #yiv0669714191ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0669714191 #yiv0669714191ygrp-mlmsg select, #yiv0669714191 input, #yiv0669714191 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0669714191 #yiv0669714191ygrp-mlmsg pre, #yiv0669714191 code {font:115% monospace;}#yiv0669714191 #yiv0669714191ygrp-mlmsg * {line-height:1.22em;}#yiv0669714191 #yiv0669714191ygrp-mlmsg #yiv0669714191logo {padding-bottom:10px;}#yiv0669714191 #yiv0669714191ygrp-msg p a {font-family:Verdana;}#yiv0669714191 #yiv0669714191ygrp-msg p#yiv0669714191attach-count span {color:#1E66AE;font-weight:700;}#yiv0669714191 #yiv0669714191ygrp-reco #yiv0669714191reco-head {color:#ff7900;font-weight:700;}#yiv0669714191 #yiv0669714191ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ov li a {font-size:130%;text-decoration:none;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0669714191 #yiv0669714191ygrp-sponsor #yiv0669714191ov ul {margin:0;padding:0 0 0 8px;}#yiv0669714191 #yiv0669714191ygrp-text {font-family:Georgia;}#yiv0669714191 #yiv0669714191ygrp-text p {margin:0 0 1em 0;}#yiv0669714191 #yiv0669714191ygrp-text tt {font-size:120%;}#yiv0669714191 #yiv0669714191ygrp-vital ul li:last-child {border-right:none !important;}#yiv0669714191



re eira - CARA MENAMPILKAN BANYAK DATA DENGAN 1 PRIMARY DI EXCEL.xlsx (24K) Download Attachment
Loading...