Yth. Rekan Be-Exceler nyoba menjawab yaa .. file terlampir ..
On Wednesday, June 7, 2017 2:58 PM, "Marco Slx slx_ma...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> 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
Description: MS-Excel 2007 spreadsheet
