Selamat sore ..
silakan dicoba pakai PIVOT TABLE ..
terlebih dahulu tabel data (sumber data) diset EXCEL TABLE ..lalu buat PIVOT
TABLE berdasar sumber data tadi ..
On Thursday, November 1, 2018, 2:40:25 PM GMT+7, [email protected]
[belajar-excel] <[email protected]> wrote:
mhn bantuannya...formula untuk mengambil data yg sama gimana ya? (sulit
jelasinnya ) file terlampir
#yiv9258158189 #yiv9258158189 -- #yiv9258158189ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9258158189
#yiv9258158189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9258158189
#yiv9258158189ygrp-mkp #yiv9258158189hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9258158189 #yiv9258158189ygrp-mkp #yiv9258158189ads
{margin-bottom:10px;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad
{padding:0 0;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad p
{margin:0;}#yiv9258158189 #yiv9258158189ygrp-mkp .yiv9258158189ad a
{color:#0000ff;text-decoration:none;}#yiv9258158189 #yiv9258158189ygrp-sponsor
#yiv9258158189ygrp-lc {font-family:Arial;}#yiv9258158189
#yiv9258158189ygrp-sponsor #yiv9258158189ygrp-lc #yiv9258158189hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9258158189
#yiv9258158189ygrp-sponsor #yiv9258158189ygrp-lc .yiv9258158189ad
{margin-bottom:10px;padding:0 0;}#yiv9258158189 #yiv9258158189actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9258158189
#yiv9258158189activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9258158189
#yiv9258158189activity span {font-weight:700;}#yiv9258158189
#yiv9258158189activity span:first-child
{text-transform:uppercase;}#yiv9258158189 #yiv9258158189activity span a
{color:#5085b6;text-decoration:none;}#yiv9258158189 #yiv9258158189activity span
span {color:#ff7900;}#yiv9258158189 #yiv9258158189activity span
.yiv9258158189underline {text-decoration:underline;}#yiv9258158189
.yiv9258158189attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9258158189 .yiv9258158189attach div a
{text-decoration:none;}#yiv9258158189 .yiv9258158189attach img
{border:none;padding-right:5px;}#yiv9258158189 .yiv9258158189attach label
{display:block;margin-bottom:5px;}#yiv9258158189 .yiv9258158189attach label a
{text-decoration:none;}#yiv9258158189 blockquote {margin:0 0 0
4px;}#yiv9258158189 .yiv9258158189bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9258158189
.yiv9258158189bold a {text-decoration:none;}#yiv9258158189 dd.yiv9258158189last
p a {font-family:Verdana;font-weight:700;}#yiv9258158189 dd.yiv9258158189last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9258158189
dd.yiv9258158189last p span.yiv9258158189yshortcuts
{margin-right:0;}#yiv9258158189 div.yiv9258158189attach-table div div a
{text-decoration:none;}#yiv9258158189 div.yiv9258158189attach-table
{width:400px;}#yiv9258158189 div.yiv9258158189file-title a, #yiv9258158189
div.yiv9258158189file-title a:active, #yiv9258158189
div.yiv9258158189file-title a:hover, #yiv9258158189 div.yiv9258158189file-title
a:visited {text-decoration:none;}#yiv9258158189 div.yiv9258158189photo-title a,
#yiv9258158189 div.yiv9258158189photo-title a:active, #yiv9258158189
div.yiv9258158189photo-title a:hover, #yiv9258158189
div.yiv9258158189photo-title a:visited {text-decoration:none;}#yiv9258158189
div#yiv9258158189ygrp-mlmsg #yiv9258158189ygrp-msg p a
span.yiv9258158189yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9258158189
.yiv9258158189green {color:#628c2a;}#yiv9258158189 .yiv9258158189MsoNormal
{margin:0 0 0 0;}#yiv9258158189 o {font-size:0;}#yiv9258158189
#yiv9258158189photos div {float:left;width:72px;}#yiv9258158189
#yiv9258158189photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9258158189
#yiv9258158189photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9258158189
#yiv9258158189reco-category {font-size:77%;}#yiv9258158189
#yiv9258158189reco-desc {font-size:77%;}#yiv9258158189 .yiv9258158189replbq
{margin:4px;}#yiv9258158189 #yiv9258158189ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9258158189 #yiv9258158189ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9258158189
#yiv9258158189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9258158189
#yiv9258158189ygrp-mlmsg select, #yiv9258158189 input, #yiv9258158189 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9258158189
#yiv9258158189ygrp-mlmsg pre, #yiv9258158189 code {font:115%
monospace;}#yiv9258158189 #yiv9258158189ygrp-mlmsg *
{line-height:1.22em;}#yiv9258158189 #yiv9258158189ygrp-mlmsg #yiv9258158189logo
{padding-bottom:10px;}#yiv9258158189 #yiv9258158189ygrp-msg p a
{font-family:Verdana;}#yiv9258158189 #yiv9258158189ygrp-msg
p#yiv9258158189attach-count span {color:#1E66AE;font-weight:700;}#yiv9258158189
#yiv9258158189ygrp-reco #yiv9258158189reco-head
{color:#ff7900;font-weight:700;}#yiv9258158189 #yiv9258158189ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9258158189 #yiv9258158189ygrp-sponsor
#yiv9258158189ov li a {font-size:130%;text-decoration:none;}#yiv9258158189
#yiv9258158189ygrp-sponsor #yiv9258158189ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9258158189
#yiv9258158189ygrp-sponsor #yiv9258158189ov ul {margin:0;padding:0 0 0
8px;}#yiv9258158189 #yiv9258158189ygrp-text
{font-family:Georgia;}#yiv9258158189 #yiv9258158189ygrp-text p {margin:0 0 1em
0;}#yiv9258158189 #yiv9258158189ygrp-text tt {font-size:120%;}#yiv9258158189
#yiv9258158189ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9258158189
