Wow Subhanallah, terima kasih banyak mas bagus atas formula yang luar biasa
On Wednesday, November 5, 2014 8:07 AM, "'Bagus' ba...@kingjim.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Pak Haris; Sila lihat file terlampir...Semoga sesuai harapan
Wassalam
~ Bagus ~
----- Original Message ----- From: ris ha har1sn.ex...@yahoo.com
[belajar-excel] To: belajar-excel@yahoogroups.com Sent: Tuesday, November 04,
2014 2:13 PM Subject: [***SPAM*** Score/Req: 05.20/5.0] [belajar-excel]
Menampilkan Multiple data secara vertikal dengan kriteria [1 Attachment]
Assalamu'alaikum para master yang saya hormati
Siang ini, saya ada masalah, yaitu Cara Menampilkan Multiple data secara
vertikal dengan kriteria (File terlampir). Mohon para master dapat berkenan
memberikan solusi atas permasalahan saya.
Saya ucapkan terima kasih atas solusi yang diberikan. Semoga para master selalu
dimudahkan segala urusan oleh Allah Swt. Amin
Salam
Haris
<!--#yiv5281012921 #yiv5281012921ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5281012921
#yiv5281012921ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5281012921
#yiv5281012921ygrp-mkp #yiv5281012921hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5281012921 #yiv5281012921ygrp-mkp #yiv5281012921ads
{margin-bottom:10px;}#yiv5281012921 #yiv5281012921ygrp-mkp .yiv5281012921ad
{padding:0 0;}#yiv5281012921 #yiv5281012921ygrp-mkp .yiv5281012921ad p
{margin:0;}#yiv5281012921 #yiv5281012921ygrp-mkp .yiv5281012921ad a
{color:#0000ff;text-decoration:none;}#yiv5281012921 #yiv5281012921ygrp-sponsor
#yiv5281012921ygrp-lc {font-family:Arial;}#yiv5281012921
#yiv5281012921ygrp-sponsor #yiv5281012921ygrp-lc #yiv5281012921hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5281012921
#yiv5281012921ygrp-sponsor #yiv5281012921ygrp-lc .yiv5281012921ad
{margin-bottom:10px;padding:0 0;}#yiv5281012921 #yiv5281012921actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5281012921
#yiv5281012921activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5281012921
#yiv5281012921activity span {font-weight:700;}#yiv5281012921
#yiv5281012921activity span:first-child
{text-transform:uppercase;}#yiv5281012921 #yiv5281012921activity span a
{color:#5085b6;text-decoration:none;}#yiv5281012921 #yiv5281012921activity span
span {color:#ff7900;}#yiv5281012921 #yiv5281012921activity span
.yiv5281012921underline {text-decoration:underline;}#yiv5281012921
.yiv5281012921attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5281012921 .yiv5281012921attach div a
{text-decoration:none;}#yiv5281012921 .yiv5281012921attach img
{border:none;padding-right:5px;}#yiv5281012921 .yiv5281012921attach label
{display:block;margin-bottom:5px;}#yiv5281012921 .yiv5281012921attach label a
{text-decoration:none;}#yiv5281012921 blockquote {margin:0 0 0
4px;}#yiv5281012921 .yiv5281012921bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5281012921
.yiv5281012921bold a {text-decoration:none;}#yiv5281012921 dd.yiv5281012921last
p a {font-family:Verdana;font-weight:700;}#yiv5281012921 dd.yiv5281012921last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5281012921
dd.yiv5281012921last p span.yiv5281012921yshortcuts
{margin-right:0;}#yiv5281012921 div.yiv5281012921attach-table div div a
{text-decoration:none;}#yiv5281012921 div.yiv5281012921attach-table
{width:400px;}#yiv5281012921 div.yiv5281012921file-title a, #yiv5281012921
div.yiv5281012921file-title a:active, #yiv5281012921
div.yiv5281012921file-title a:hover, #yiv5281012921 div.yiv5281012921file-title
a:visited {text-decoration:none;}#yiv5281012921 div.yiv5281012921photo-title a,
#yiv5281012921 div.yiv5281012921photo-title a:active, #yiv5281012921
div.yiv5281012921photo-title a:hover, #yiv5281012921
div.yiv5281012921photo-title a:visited {text-decoration:none;}#yiv5281012921
div#yiv5281012921ygrp-mlmsg #yiv5281012921ygrp-msg p a
span.yiv5281012921yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5281012921
.yiv5281012921green {color:#628c2a;}#yiv5281012921 .yiv5281012921MsoNormal
{margin:0 0 0 0;}#yiv5281012921 o {font-size:0;}#yiv5281012921
#yiv5281012921photos div {float:left;width:72px;}#yiv5281012921
#yiv5281012921photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5281012921
#yiv5281012921photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5281012921
#yiv5281012921reco-category {font-size:77%;}#yiv5281012921
#yiv5281012921reco-desc {font-size:77%;}#yiv5281012921 .yiv5281012921replbq
{margin:4px;}#yiv5281012921 #yiv5281012921ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5281012921 #yiv5281012921ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5281012921
#yiv5281012921ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5281012921
#yiv5281012921ygrp-mlmsg select, #yiv5281012921 input, #yiv5281012921 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5281012921
#yiv5281012921ygrp-mlmsg pre, #yiv5281012921 code {font:115%
monospace;}#yiv5281012921 #yiv5281012921ygrp-mlmsg *
{line-height:1.22em;}#yiv5281012921 #yiv5281012921ygrp-mlmsg #yiv5281012921logo
{padding-bottom:10px;}#yiv5281012921 #yiv5281012921ygrp-msg p a
{font-family:Verdana;}#yiv5281012921 #yiv5281012921ygrp-msg
p#yiv5281012921attach-count span {color:#1E66AE;font-weight:700;}#yiv5281012921
#yiv5281012921ygrp-reco #yiv5281012921reco-head
{color:#ff7900;font-weight:700;}#yiv5281012921 #yiv5281012921ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5281012921 #yiv5281012921ygrp-sponsor
#yiv5281012921ov li a {font-size:130%;text-decoration:none;}#yiv5281012921
#yiv5281012921ygrp-sponsor #yiv5281012921ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5281012921
#yiv5281012921ygrp-sponsor #yiv5281012921ov ul {margin:0;padding:0 0 0
8px;}#yiv5281012921 #yiv5281012921ygrp-text
{font-family:Georgia;}#yiv5281012921 #yiv5281012921ygrp-text p {margin:0 0 1em
0;}#yiv5281012921 #yiv5281012921ygrp-text tt {font-size:120%;}#yiv5281012921
#yiv5281012921ygrp-vital ul li:last-child {border-right:none !important;}-->
