Dear all

Terimakasih smua


Pak Kid...terimakasih...
Horey...berhasil berhasil..agak panjang sih, tapi data2nya tidak ada yg hilang 
dan tetap berurutan kecuali angka nol.Sebenernya sih spt tidak ribet ya Pak, 
asal kita tau aja apa tujuannya...Terimakasih banyak Pak..
 



     On Thursday, November 6, 2014 12:27 PM, "'Mr. Kid' [email protected] 
[belajar-excel]" <[email protected]> wrote:



     Hai Ester,


Mau coba cara ruwet buntet yang gak asik n gak canggih ?


kalo mau ya ayuuuk....
kalo gak mau, silakan ditutup saja imil ini.


Langkah : (dibuang seluruh baris yang kolom tertentunya berisi numerik 0 nya 
ya)1. aktifkan autofilter (ikuti caranya supaya tabel data tidak memiliki 
potensi terpotong
    >> blok kolom tabel data dari A sampai i
    >> klik autofilter (ribbon Data -> group Sort & Filter -> Filter) berulang 
kali sampai muncul segitiga kecil autofilter di header data
2. blok cells yang berformula di kolom i
    >> blok kolom i -> CTRL G -> klik Special -> pilih Formulas -> hilangkan 
semua centang -> centang item Numbers -> klik OK
3. filter yang 0 (jangan klik cell, baris, kolom manapun)
    >> klik segitiga filter kolom i -> hilangkan centang dari item Select all 
-> centang item 0 -> tekan OK
4. pilih cells terfilter (jangan klik cell, baris, kolom manapun)    >> CTRL G 
-> klik Special -> pilih opsi Visible cells only -> OK
5. buang baris yang telah terpilih
    >> klik kanan sebuah cell hasil filter (yang nilainya 0) -> pilih Delete 
atau Delete Row
          -> pilih Entire Row (kalau muncul pertanyaan) -> OK
6. non aktifkan autofilter (lakukan berulang sampai segitiga autofilter telah 
hilanng dari header)
    >> ribbon Data -> group Sort & Filter -> Filter


Wassalam,
Kid.










On Thu, Nov 6, 2014 at 2:22 PM, Ester Debora [email protected] 
[belajar-excel] <[email protected]> wrote:


     Dear all,
Maaf Pak, Maksudnya, tabel tersebut hanya untuk jumlah nilai yang bukan 0 (nol) 
semua barisan yang jumlah 0 (nol) dihapuskan. Jadi bukan hanya nilai 0 (nol)nya 
dihapus..tapi satu baris tersebut ikut dihapus.
Terimakasih


Regards,


Ester



     On Thursday, November 6, 2014 10:06 AM, "Dede [email protected] 
[belajar-excel]" <[email protected]> wrote:



     File terlampir Apakah sesuai harapan ...    From: Ester 
[email protected] [belajar-excel] 
[mailto:[email protected]]
Sent: 06 Nopember 2014 09:58
To: [email protected]
Subject: [belajar-excel] Menghapus nilai 0       Dear all,    Mohon bantuan 
rekan2bagaimana cara menghapus baris dengan "total 0 (nol)" sebungan 
dengandata2 tersebut sampai ratusan sehingga kalau dikerjakan dengan delete 
perkolomakan memakan waktu yang sangat banyak, Contoh tabelnya seperti di bawah 
ini Terimakasih atas bantuannya       
|  No  |  Description  |  Group 1  |  Group 2  |  Group 3  |  Group 4  |  Total 
 |
|  1  |  AA  |  1  |  2  |  3  |  4  |  10  |
|  2  |  AB  |     |     |     |     |  0  |
|  3  |  AC  |     |  3  |  3  |     |  6  |
|  4  |  DE  |     |     |  4  |     |  4  |
|  5  |  GE  |     |     |     |     |  0  |
|  6  |  GD  |     |  4  |  6  |     |  10  |
|  7  |  CD  |  4  |     |     |     |  4  |
|  8  |  ED  |  2  |     |     |  5  |  7  |
|     |  Total  |  7  |  9  |  16  |  9  |  41  |


      Regards,


 Ester  


     This e-mail and any files transmitted with it are confidential andintended 
solely for the use of the individual to whom it is addressed. If youhave 
received this email in error please send it back to the person that sentit to 
you. Any views or opinions presented are solely those of its author anddo not 
necessarily represent those of NABATI or any of its subsidiarycompanies. 
Unauthorized publication, use, dissemination, forwarding, printingor copying of 
this email and its associated attachments is strictly prohibited.


  


  #yiv2971121069 #yiv2971121069 -- #yiv2971121069ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2971121069 
#yiv2971121069ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2971121069 
#yiv2971121069ygrp-mkp #yiv2971121069hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2971121069 #yiv2971121069ygrp-mkp #yiv2971121069ads 
{margin-bottom:10px;}#yiv2971121069 #yiv2971121069ygrp-mkp .yiv2971121069ad 
{padding:0 0;}#yiv2971121069 #yiv2971121069ygrp-mkp .yiv2971121069ad p 
{margin:0;}#yiv2971121069 #yiv2971121069ygrp-mkp .yiv2971121069ad a 
{color:#0000ff;text-decoration:none;}#yiv2971121069 #yiv2971121069ygrp-sponsor 
#yiv2971121069ygrp-lc {font-family:Arial;}#yiv2971121069 
#yiv2971121069ygrp-sponsor #yiv2971121069ygrp-lc #yiv2971121069hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2971121069 
#yiv2971121069ygrp-sponsor #yiv2971121069ygrp-lc .yiv2971121069ad 
{margin-bottom:10px;padding:0 0;}#yiv2971121069 #yiv2971121069actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2971121069 
#yiv2971121069activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2971121069
 #yiv2971121069activity span {font-weight:700;}#yiv2971121069 
#yiv2971121069activity span:first-child 
{text-transform:uppercase;}#yiv2971121069 #yiv2971121069activity span a 
{color:#5085b6;text-decoration:none;}#yiv2971121069 #yiv2971121069activity span 
span {color:#ff7900;}#yiv2971121069 #yiv2971121069activity span 
.yiv2971121069underline {text-decoration:underline;}#yiv2971121069 
.yiv2971121069attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2971121069 .yiv2971121069attach div a 
{text-decoration:none;}#yiv2971121069 .yiv2971121069attach img 
{border:none;padding-right:5px;}#yiv2971121069 .yiv2971121069attach label 
{display:block;margin-bottom:5px;}#yiv2971121069 .yiv2971121069attach label a 
{text-decoration:none;}#yiv2971121069 blockquote {margin:0 0 0 
4px;}#yiv2971121069 .yiv2971121069bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2971121069 
.yiv2971121069bold a {text-decoration:none;}#yiv2971121069 dd.yiv2971121069last 
p a {font-family:Verdana;font-weight:700;}#yiv2971121069 dd.yiv2971121069last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2971121069 
dd.yiv2971121069last p span.yiv2971121069yshortcuts 
{margin-right:0;}#yiv2971121069 div.yiv2971121069attach-table div div a 
{text-decoration:none;}#yiv2971121069 div.yiv2971121069attach-table 
{width:400px;}#yiv2971121069 div.yiv2971121069file-title a, #yiv2971121069 
div.yiv2971121069file-title a:active, #yiv2971121069 
div.yiv2971121069file-title a:hover, #yiv2971121069 div.yiv2971121069file-title 
a:visited {text-decoration:none;}#yiv2971121069 div.yiv2971121069photo-title a, 
#yiv2971121069 div.yiv2971121069photo-title a:active, #yiv2971121069 
div.yiv2971121069photo-title a:hover, #yiv2971121069 
div.yiv2971121069photo-title a:visited {text-decoration:none;}#yiv2971121069 
div#yiv2971121069ygrp-mlmsg #yiv2971121069ygrp-msg p a 
span.yiv2971121069yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2971121069 
.yiv2971121069green {color:#628c2a;}#yiv2971121069 .yiv2971121069MsoNormal 
{margin:0 0 0 0;}#yiv2971121069 o {font-size:0;}#yiv2971121069 
#yiv2971121069photos div {float:left;width:72px;}#yiv2971121069 
#yiv2971121069photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv2971121069 
#yiv2971121069photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2971121069
 #yiv2971121069reco-category {font-size:77%;}#yiv2971121069 
#yiv2971121069reco-desc {font-size:77%;}#yiv2971121069 .yiv2971121069replbq 
{margin:4px;}#yiv2971121069 #yiv2971121069ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2971121069 #yiv2971121069ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2971121069 
#yiv2971121069ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2971121069 
#yiv2971121069ygrp-mlmsg select, #yiv2971121069 input, #yiv2971121069 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2971121069 
#yiv2971121069ygrp-mlmsg pre, #yiv2971121069 code {font:115% 
monospace;}#yiv2971121069 #yiv2971121069ygrp-mlmsg * 
{line-height:1.22em;}#yiv2971121069 #yiv2971121069ygrp-mlmsg #yiv2971121069logo 
{padding-bottom:10px;}#yiv2971121069 #yiv2971121069ygrp-msg p a 
{font-family:Verdana;}#yiv2971121069 #yiv2971121069ygrp-msg 
p#yiv2971121069attach-count span {color:#1E66AE;font-weight:700;}#yiv2971121069 
#yiv2971121069ygrp-reco #yiv2971121069reco-head 
{color:#ff7900;font-weight:700;}#yiv2971121069 #yiv2971121069ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2971121069 #yiv2971121069ygrp-sponsor 
#yiv2971121069ov li a {font-size:130%;text-decoration:none;}#yiv2971121069 
#yiv2971121069ygrp-sponsor #yiv2971121069ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2971121069 
#yiv2971121069ygrp-sponsor #yiv2971121069ov ul {margin:0;padding:0 0 0 
8px;}#yiv2971121069 #yiv2971121069ygrp-text 
{font-family:Georgia;}#yiv2971121069 #yiv2971121069ygrp-text p {margin:0 0 1em 
0;}#yiv2971121069 #yiv2971121069ygrp-text tt {font-size:120%;}#yiv2971121069 
#yiv2971121069ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2971121069


   

Kirim email ke