yoo supriadi,
klo mang mo pake formula, bisa kok, dengan menyiapkan kolom bantu (asumsi nya
ada di kolom Q dalam hal ini Q7 s.d Qn).
=small ( if ( _cell awal data yang akan di cari_ : _cell ahir data yang akan di
cari_ < > "" ; ROW ( _cell awal data_ : _cell ahir data ) - ROW ( _cell header_
) ) ; ROW ( 1 : 1 ))
-> tekan CSE (Ctrl Shift Enter), sebagai pengganti enter.
bila regional kompi setempat english rubah titik koma ";" menjadi koma ","
untuk pembahasan masalah filter formula bisa datang ke coretan mr.kid di sini.
br,
odong nando
Pada Senin, 7 Desember 2015 9:34, "Bayu Krisworo
[email protected] [belajar-excel]" <[email protected]>
menulis:
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
#yiv3587908911 #yiv3587908911 -- #yiv3587908911ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3587908911
#yiv3587908911ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3587908911
#yiv3587908911ygrp-mkp #yiv3587908911hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3587908911 #yiv3587908911ygrp-mkp #yiv3587908911ads
{margin-bottom:10px;}#yiv3587908911 #yiv3587908911ygrp-mkp .yiv3587908911ad
{padding:0 0;}#yiv3587908911 #yiv3587908911ygrp-mkp .yiv3587908911ad p
{margin:0;}#yiv3587908911 #yiv3587908911ygrp-mkp .yiv3587908911ad a
{color:#0000ff;text-decoration:none;}#yiv3587908911 #yiv3587908911ygrp-sponsor
#yiv3587908911ygrp-lc {font-family:Arial;}#yiv3587908911
#yiv3587908911ygrp-sponsor #yiv3587908911ygrp-lc #yiv3587908911hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3587908911
#yiv3587908911ygrp-sponsor #yiv3587908911ygrp-lc .yiv3587908911ad
{margin-bottom:10px;padding:0 0;}#yiv3587908911 #yiv3587908911actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3587908911
#yiv3587908911activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3587908911
#yiv3587908911activity span {font-weight:700;}#yiv3587908911
#yiv3587908911activity span:first-child
{text-transform:uppercase;}#yiv3587908911 #yiv3587908911activity span a
{color:#5085b6;text-decoration:none;}#yiv3587908911 #yiv3587908911activity span
span {color:#ff7900;}#yiv3587908911 #yiv3587908911activity span
.yiv3587908911underline {text-decoration:underline;}#yiv3587908911
.yiv3587908911attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3587908911 .yiv3587908911attach div a
{text-decoration:none;}#yiv3587908911 .yiv3587908911attach img
{border:none;padding-right:5px;}#yiv3587908911 .yiv3587908911attach label
{display:block;margin-bottom:5px;}#yiv3587908911 .yiv3587908911attach label a
{text-decoration:none;}#yiv3587908911 blockquote {margin:0 0 0
4px;}#yiv3587908911 .yiv3587908911bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3587908911
.yiv3587908911bold a {text-decoration:none;}#yiv3587908911 dd.yiv3587908911last
p a {font-family:Verdana;font-weight:700;}#yiv3587908911 dd.yiv3587908911last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3587908911
dd.yiv3587908911last p span.yiv3587908911yshortcuts
{margin-right:0;}#yiv3587908911 div.yiv3587908911attach-table div div a
{text-decoration:none;}#yiv3587908911 div.yiv3587908911attach-table
{width:400px;}#yiv3587908911 div.yiv3587908911file-title a, #yiv3587908911
div.yiv3587908911file-title a:active, #yiv3587908911
div.yiv3587908911file-title a:hover, #yiv3587908911 div.yiv3587908911file-title
a:visited {text-decoration:none;}#yiv3587908911 div.yiv3587908911photo-title a,
#yiv3587908911 div.yiv3587908911photo-title a:active, #yiv3587908911
div.yiv3587908911photo-title a:hover, #yiv3587908911
div.yiv3587908911photo-title a:visited {text-decoration:none;}#yiv3587908911
div#yiv3587908911ygrp-mlmsg #yiv3587908911ygrp-msg p a
span.yiv3587908911yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3587908911
.yiv3587908911green {color:#628c2a;}#yiv3587908911 .yiv3587908911MsoNormal
{margin:0 0 0 0;}#yiv3587908911 o {font-size:0;}#yiv3587908911
#yiv3587908911photos div {float:left;width:72px;}#yiv3587908911
#yiv3587908911photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3587908911
#yiv3587908911photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3587908911
#yiv3587908911reco-category {font-size:77%;}#yiv3587908911
#yiv3587908911reco-desc {font-size:77%;}#yiv3587908911 .yiv3587908911replbq
{margin:4px;}#yiv3587908911 #yiv3587908911ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3587908911 #yiv3587908911ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3587908911
#yiv3587908911ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3587908911
#yiv3587908911ygrp-mlmsg select, #yiv3587908911 input, #yiv3587908911 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3587908911
#yiv3587908911ygrp-mlmsg pre, #yiv3587908911 code {font:115%
monospace;}#yiv3587908911 #yiv3587908911ygrp-mlmsg *
{line-height:1.22em;}#yiv3587908911 #yiv3587908911ygrp-mlmsg #yiv3587908911logo
{padding-bottom:10px;}#yiv3587908911 #yiv3587908911ygrp-msg p a
{font-family:Verdana;}#yiv3587908911 #yiv3587908911ygrp-msg
p#yiv3587908911attach-count span {color:#1E66AE;font-weight:700;}#yiv3587908911
#yiv3587908911ygrp-reco #yiv3587908911reco-head
{color:#ff7900;font-weight:700;}#yiv3587908911 #yiv3587908911ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3587908911 #yiv3587908911ygrp-sponsor
#yiv3587908911ov li a {font-size:130%;text-decoration:none;}#yiv3587908911
#yiv3587908911ygrp-sponsor #yiv3587908911ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3587908911
#yiv3587908911ygrp-sponsor #yiv3587908911ov ul {margin:0;padding:0 0 0
8px;}#yiv3587908911 #yiv3587908911ygrp-text
{font-family:Georgia;}#yiv3587908911 #yiv3587908911ygrp-text p {margin:0 0 1em
0;}#yiv3587908911 #yiv3587908911ygrp-text tt {font-size:120%;}#yiv3587908911
#yiv3587908911ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3587908911
