Dear Mr Supriyadi, Dengan menggunakan Pivot Tabel...Terlampir File nya, semoga dapat membantu...
Salam,
Bayu Agung Krisworo
Dari: "Supriyadi [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 7 Desember 2015 8:45
Judul: [belajar-excel] membuat filter di excel dengan rumus [1 Attachment]
dear all,
saya dapat tugas, membuat summary dari sebuah database, dan kendalanya adalah
memindahkan hasil filter secara manual.
bisakah filter dalam excel dibuat dari rumus, karena saya ingin memindahkan
hasil dari filternya ke sheet lain secara otomatis,contoh file terlampir.
mohon saran dan bantuan dari suhu semua.
best regards,
supriyadi
#yiv7808212415 #yiv7808212415 -- #yiv7808212415ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7808212415
#yiv7808212415ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7808212415
#yiv7808212415ygrp-mkp #yiv7808212415hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7808212415 #yiv7808212415ygrp-mkp #yiv7808212415ads
{margin-bottom:10px;}#yiv7808212415 #yiv7808212415ygrp-mkp .yiv7808212415ad
{padding:0 0;}#yiv7808212415 #yiv7808212415ygrp-mkp .yiv7808212415ad p
{margin:0;}#yiv7808212415 #yiv7808212415ygrp-mkp .yiv7808212415ad a
{color:#0000ff;text-decoration:none;}#yiv7808212415 #yiv7808212415ygrp-sponsor
#yiv7808212415ygrp-lc {font-family:Arial;}#yiv7808212415
#yiv7808212415ygrp-sponsor #yiv7808212415ygrp-lc #yiv7808212415hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7808212415
#yiv7808212415ygrp-sponsor #yiv7808212415ygrp-lc .yiv7808212415ad
{margin-bottom:10px;padding:0 0;}#yiv7808212415 #yiv7808212415actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7808212415
#yiv7808212415activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7808212415
#yiv7808212415activity span {font-weight:700;}#yiv7808212415
#yiv7808212415activity span:first-child
{text-transform:uppercase;}#yiv7808212415 #yiv7808212415activity span a
{color:#5085b6;text-decoration:none;}#yiv7808212415 #yiv7808212415activity span
span {color:#ff7900;}#yiv7808212415 #yiv7808212415activity span
.yiv7808212415underline {text-decoration:underline;}#yiv7808212415
.yiv7808212415attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7808212415 .yiv7808212415attach div a
{text-decoration:none;}#yiv7808212415 .yiv7808212415attach img
{border:none;padding-right:5px;}#yiv7808212415 .yiv7808212415attach label
{display:block;margin-bottom:5px;}#yiv7808212415 .yiv7808212415attach label a
{text-decoration:none;}#yiv7808212415 blockquote {margin:0 0 0
4px;}#yiv7808212415 .yiv7808212415bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7808212415
.yiv7808212415bold a {text-decoration:none;}#yiv7808212415 dd.yiv7808212415last
p a {font-family:Verdana;font-weight:700;}#yiv7808212415 dd.yiv7808212415last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7808212415
dd.yiv7808212415last p span.yiv7808212415yshortcuts
{margin-right:0;}#yiv7808212415 div.yiv7808212415attach-table div div a
{text-decoration:none;}#yiv7808212415 div.yiv7808212415attach-table
{width:400px;}#yiv7808212415 div.yiv7808212415file-title a, #yiv7808212415
div.yiv7808212415file-title a:active, #yiv7808212415
div.yiv7808212415file-title a:hover, #yiv7808212415 div.yiv7808212415file-title
a:visited {text-decoration:none;}#yiv7808212415 div.yiv7808212415photo-title a,
#yiv7808212415 div.yiv7808212415photo-title a:active, #yiv7808212415
div.yiv7808212415photo-title a:hover, #yiv7808212415
div.yiv7808212415photo-title a:visited {text-decoration:none;}#yiv7808212415
div#yiv7808212415ygrp-mlmsg #yiv7808212415ygrp-msg p a
span.yiv7808212415yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7808212415
.yiv7808212415green {color:#628c2a;}#yiv7808212415 .yiv7808212415MsoNormal
{margin:0 0 0 0;}#yiv7808212415 o {font-size:0;}#yiv7808212415
#yiv7808212415photos div {float:left;width:72px;}#yiv7808212415
#yiv7808212415photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7808212415
#yiv7808212415photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7808212415
#yiv7808212415reco-category {font-size:77%;}#yiv7808212415
#yiv7808212415reco-desc {font-size:77%;}#yiv7808212415 .yiv7808212415replbq
{margin:4px;}#yiv7808212415 #yiv7808212415ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7808212415 #yiv7808212415ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7808212415
#yiv7808212415ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7808212415
#yiv7808212415ygrp-mlmsg select, #yiv7808212415 input, #yiv7808212415 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7808212415
#yiv7808212415ygrp-mlmsg pre, #yiv7808212415 code {font:115%
monospace;}#yiv7808212415 #yiv7808212415ygrp-mlmsg *
{line-height:1.22em;}#yiv7808212415 #yiv7808212415ygrp-mlmsg #yiv7808212415logo
{padding-bottom:10px;}#yiv7808212415 #yiv7808212415ygrp-msg p a
{font-family:Verdana;}#yiv7808212415 #yiv7808212415ygrp-msg
p#yiv7808212415attach-count span {color:#1E66AE;font-weight:700;}#yiv7808212415
#yiv7808212415ygrp-reco #yiv7808212415reco-head
{color:#ff7900;font-weight:700;}#yiv7808212415 #yiv7808212415ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7808212415 #yiv7808212415ygrp-sponsor
#yiv7808212415ov li a {font-size:130%;text-decoration:none;}#yiv7808212415
#yiv7808212415ygrp-sponsor #yiv7808212415ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7808212415
#yiv7808212415ygrp-sponsor #yiv7808212415ov ul {margin:0;padding:0 0 0
8px;}#yiv7808212415 #yiv7808212415ygrp-text
{font-family:Georgia;}#yiv7808212415 #yiv7808212415ygrp-text p {margin:0 0 1em
0;}#yiv7808212415 #yiv7808212415ygrp-text tt {font-size:120%;}#yiv7808212415
#yiv7808212415ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7808212415
history report dg PIVOT.xls
Description: MS-Excel spreadsheet
