Terimakasih BanyakMaster
Pada Senin, 2 November 2015 1:44, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Hairul Alam,
Coba gunakan array formula filtering. Sila lihat disini dan terapkan konsepnya
pada kasus Anda.
Yang perlu diingat, array formula akan terasa berat jika ada banyak data yang
diproses dalam 1 array formulanya dan ada banyak cells yang berisi array
formula tersebut.
Cara lain adalah dengan memanfaatkan pivot table. Sepertinya tempo hari di
kasus yang mirip seperti ini sudah ada contoh penggunaan pivot table. Coretan
tentang pivot table dimulai dari sini.
Cara lainnya lagi, pakai fitur autofilter disisi data dan copas hasilnya ke
sheet hasil.
Cara lainnya lagi, memanfaatkan fitur Advanced Filter dengan menyediakan area
range criteria.
Cara lainnya lagi, pakai VBA, jadi perlu belajar bahasa pemrograman VB for A
Pilih saja yang nyaman untuk dipahami.
Wassalam,
Kid
2015-10-29 20:01 GMT+07:00 HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:
Yth. Master Excel
Saya punya masalah seperti data terlampir, bagaimana caranya agar bekerja
secara otomatis dengan formula dan file excel tidak menjadi besar sehingga
operasi excel menjadi lambat, Terimakasih Pencerahannya, dan Sukses selalu pada
belajar-excel@yahoogroups.com
SalamHairul Alam
#yiv9534975912 #yiv9534975912 -- #yiv9534975912ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9534975912
#yiv9534975912ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9534975912
#yiv9534975912ygrp-mkp #yiv9534975912hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9534975912 #yiv9534975912ygrp-mkp #yiv9534975912ads
{margin-bottom:10px;}#yiv9534975912 #yiv9534975912ygrp-mkp .yiv9534975912ad
{padding:0 0;}#yiv9534975912 #yiv9534975912ygrp-mkp .yiv9534975912ad p
{margin:0;}#yiv9534975912 #yiv9534975912ygrp-mkp .yiv9534975912ad a
{color:#0000ff;text-decoration:none;}#yiv9534975912 #yiv9534975912ygrp-sponsor
#yiv9534975912ygrp-lc {font-family:Arial;}#yiv9534975912
#yiv9534975912ygrp-sponsor #yiv9534975912ygrp-lc #yiv9534975912hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9534975912
#yiv9534975912ygrp-sponsor #yiv9534975912ygrp-lc .yiv9534975912ad
{margin-bottom:10px;padding:0 0;}#yiv9534975912 #yiv9534975912actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9534975912
#yiv9534975912activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9534975912
#yiv9534975912activity span {font-weight:700;}#yiv9534975912
#yiv9534975912activity span:first-child
{text-transform:uppercase;}#yiv9534975912 #yiv9534975912activity span a
{color:#5085b6;text-decoration:none;}#yiv9534975912 #yiv9534975912activity span
span {color:#ff7900;}#yiv9534975912 #yiv9534975912activity span
.yiv9534975912underline {text-decoration:underline;}#yiv9534975912
.yiv9534975912attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9534975912 .yiv9534975912attach div a
{text-decoration:none;}#yiv9534975912 .yiv9534975912attach img
{border:none;padding-right:5px;}#yiv9534975912 .yiv9534975912attach label
{display:block;margin-bottom:5px;}#yiv9534975912 .yiv9534975912attach label a
{text-decoration:none;}#yiv9534975912 blockquote {margin:0 0 0
4px;}#yiv9534975912 .yiv9534975912bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9534975912
.yiv9534975912bold a {text-decoration:none;}#yiv9534975912 dd.yiv9534975912last
p a {font-family:Verdana;font-weight:700;}#yiv9534975912 dd.yiv9534975912last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9534975912
dd.yiv9534975912last p span.yiv9534975912yshortcuts
{margin-right:0;}#yiv9534975912 div.yiv9534975912attach-table div div a
{text-decoration:none;}#yiv9534975912 div.yiv9534975912attach-table
{width:400px;}#yiv9534975912 div.yiv9534975912file-title a, #yiv9534975912
div.yiv9534975912file-title a:active, #yiv9534975912
div.yiv9534975912file-title a:hover, #yiv9534975912 div.yiv9534975912file-title
a:visited {text-decoration:none;}#yiv9534975912 div.yiv9534975912photo-title a,
#yiv9534975912 div.yiv9534975912photo-title a:active, #yiv9534975912
div.yiv9534975912photo-title a:hover, #yiv9534975912
div.yiv9534975912photo-title a:visited {text-decoration:none;}#yiv9534975912
div#yiv9534975912ygrp-mlmsg #yiv9534975912ygrp-msg p a
span.yiv9534975912yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9534975912
.yiv9534975912green {color:#628c2a;}#yiv9534975912 .yiv9534975912MsoNormal
{margin:0 0 0 0;}#yiv9534975912 o {font-size:0;}#yiv9534975912
#yiv9534975912photos div {float:left;width:72px;}#yiv9534975912
#yiv9534975912photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9534975912
#yiv9534975912photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9534975912
#yiv9534975912reco-category {font-size:77%;}#yiv9534975912
#yiv9534975912reco-desc {font-size:77%;}#yiv9534975912 .yiv9534975912replbq
{margin:4px;}#yiv9534975912 #yiv9534975912ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9534975912 #yiv9534975912ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9534975912
#yiv9534975912ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9534975912
#yiv9534975912ygrp-mlmsg select, #yiv9534975912 input, #yiv9534975912 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9534975912
#yiv9534975912ygrp-mlmsg pre, #yiv9534975912 code {font:115%
monospace;}#yiv9534975912 #yiv9534975912ygrp-mlmsg *
{line-height:1.22em;}#yiv9534975912 #yiv9534975912ygrp-mlmsg #yiv9534975912logo
{padding-bottom:10px;}#yiv9534975912 #yiv9534975912ygrp-msg p a
{font-family:Verdana;}#yiv9534975912 #yiv9534975912ygrp-msg
p#yiv9534975912attach-count span {color:#1E66AE;font-weight:700;}#yiv9534975912
#yiv9534975912ygrp-reco #yiv9534975912reco-head
{color:#ff7900;font-weight:700;}#yiv9534975912 #yiv9534975912ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9534975912 #yiv9534975912ygrp-sponsor
#yiv9534975912ov li a {font-size:130%;text-decoration:none;}#yiv9534975912
#yiv9534975912ygrp-sponsor #yiv9534975912ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9534975912
#yiv9534975912ygrp-sponsor #yiv9534975912ov ul {margin:0;padding:0 0 0
8px;}#yiv9534975912 #yiv9534975912ygrp-text
{font-family:Georgia;}#yiv9534975912 #yiv9534975912ygrp-text p {margin:0 0 1em
0;}#yiv9534975912 #yiv9534975912ygrp-text tt {font-size:120%;}#yiv9534975912
#yiv9534975912ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9534975912
