ketinggalah untuk summary nya
| no frame | tgl pergantiang | lifetime |
bisa di gunakan fungsi index :
=index ( _range data yang akan di ambil_ ; _hasil dari kolom bantu (kolom Q)_ )
formula nya dapat di sesuaikan untuk no frame, tgl pergantiang dan lifetime.
:)
br,
odong nando
Pada Senin, 7 Desember 2015 10:31, odong nando <[email protected]>
menulis:
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
#yiv2299495327 -- #yiv2299495327ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2299495327
#yiv2299495327ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2299495327
#yiv2299495327ygrp-mkp #yiv2299495327hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2299495327 #yiv2299495327ygrp-mkp #yiv2299495327ads
{margin-bottom:10px;}#yiv2299495327 #yiv2299495327ygrp-mkp .yiv2299495327ad
{padding:0 0;}#yiv2299495327 #yiv2299495327ygrp-mkp .yiv2299495327ad p
{margin:0;}#yiv2299495327 #yiv2299495327ygrp-mkp .yiv2299495327ad a
{color:#0000ff;text-decoration:none;}#yiv2299495327 #yiv2299495327ygrp-sponsor
#yiv2299495327ygrp-lc {font-family:Arial;}#yiv2299495327
#yiv2299495327ygrp-sponsor #yiv2299495327ygrp-lc #yiv2299495327hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2299495327
#yiv2299495327ygrp-sponsor #yiv2299495327ygrp-lc .yiv2299495327ad
{margin-bottom:10px;padding:0 0;}#yiv2299495327 #yiv2299495327actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2299495327
#yiv2299495327activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2299495327
#yiv2299495327activity span {font-weight:700;}#yiv2299495327
#yiv2299495327activity span:first-child
{text-transform:uppercase;}#yiv2299495327 #yiv2299495327activity span a
{color:#5085b6;text-decoration:none;}#yiv2299495327 #yiv2299495327activity span
span {color:#ff7900;}#yiv2299495327 #yiv2299495327activity span
.yiv2299495327underline {text-decoration:underline;}#yiv2299495327
.yiv2299495327attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2299495327 .yiv2299495327attach div a
{text-decoration:none;}#yiv2299495327 .yiv2299495327attach img
{border:none;padding-right:5px;}#yiv2299495327 .yiv2299495327attach label
{display:block;margin-bottom:5px;}#yiv2299495327 .yiv2299495327attach label a
{text-decoration:none;}#yiv2299495327 blockquote {margin:0 0 0
4px;}#yiv2299495327 .yiv2299495327bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2299495327
.yiv2299495327bold a {text-decoration:none;}#yiv2299495327 dd.yiv2299495327last
p a {font-family:Verdana;font-weight:700;}#yiv2299495327 dd.yiv2299495327last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2299495327
dd.yiv2299495327last p span.yiv2299495327yshortcuts
{margin-right:0;}#yiv2299495327 div.yiv2299495327attach-table div div a
{text-decoration:none;}#yiv2299495327 div.yiv2299495327attach-table
{width:400px;}#yiv2299495327 div.yiv2299495327file-title a, #yiv2299495327
div.yiv2299495327file-title a:active, #yiv2299495327
div.yiv2299495327file-title a:hover, #yiv2299495327 div.yiv2299495327file-title
a:visited {text-decoration:none;}#yiv2299495327 div.yiv2299495327photo-title a,
#yiv2299495327 div.yiv2299495327photo-title a:active, #yiv2299495327
div.yiv2299495327photo-title a:hover, #yiv2299495327
div.yiv2299495327photo-title a:visited {text-decoration:none;}#yiv2299495327
div#yiv2299495327ygrp-mlmsg #yiv2299495327ygrp-msg p a
span.yiv2299495327yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2299495327
.yiv2299495327green {color:#628c2a;}#yiv2299495327 .yiv2299495327MsoNormal
{margin:0 0 0 0;}#yiv2299495327 o {font-size:0;}#yiv2299495327
#yiv2299495327photos div {float:left;width:72px;}#yiv2299495327
#yiv2299495327photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2299495327
#yiv2299495327photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2299495327
#yiv2299495327reco-category {font-size:77%;}#yiv2299495327
#yiv2299495327reco-desc {font-size:77%;}#yiv2299495327 .yiv2299495327replbq
{margin:4px;}#yiv2299495327 #yiv2299495327ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2299495327 #yiv2299495327ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2299495327
#yiv2299495327ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2299495327
#yiv2299495327ygrp-mlmsg select, #yiv2299495327 input, #yiv2299495327 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2299495327
#yiv2299495327ygrp-mlmsg pre, #yiv2299495327 code {font:115%
monospace;}#yiv2299495327 #yiv2299495327ygrp-mlmsg *
{line-height:1.22em;}#yiv2299495327 #yiv2299495327ygrp-mlmsg #yiv2299495327logo
{padding-bottom:10px;}#yiv2299495327 #yiv2299495327ygrp-msg p a
{font-family:Verdana;}#yiv2299495327 #yiv2299495327ygrp-msg
p#yiv2299495327attach-count span {color:#1E66AE;font-weight:700;}#yiv2299495327
#yiv2299495327ygrp-reco #yiv2299495327reco-head
{color:#ff7900;font-weight:700;}#yiv2299495327 #yiv2299495327ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2299495327 #yiv2299495327ygrp-sponsor
#yiv2299495327ov li a {font-size:130%;text-decoration:none;}#yiv2299495327
#yiv2299495327ygrp-sponsor #yiv2299495327ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2299495327
#yiv2299495327ygrp-sponsor #yiv2299495327ov ul {margin:0;padding:0 0 0
8px;}#yiv2299495327 #yiv2299495327ygrp-text
{font-family:Georgia;}#yiv2299495327 #yiv2299495327ygrp-text p {margin:0 0 1em
0;}#yiv2299495327 #yiv2299495327ygrp-text tt {font-size:120%;}#yiv2299495327
#yiv2299495327ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2299495327
