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.   
#yiv8067813899 #yiv8067813899 -- #yiv8067813899ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8067813899 
#yiv8067813899ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8067813899 
#yiv8067813899ygrp-mkp #yiv8067813899hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8067813899 #yiv8067813899ygrp-mkp #yiv8067813899ads 
{margin-bottom:10px;}#yiv8067813899 #yiv8067813899ygrp-mkp .yiv8067813899ad 
{padding:0 0;}#yiv8067813899 #yiv8067813899ygrp-mkp .yiv8067813899ad p 
{margin:0;}#yiv8067813899 #yiv8067813899ygrp-mkp .yiv8067813899ad a 
{color:#0000ff;text-decoration:none;}#yiv8067813899 #yiv8067813899ygrp-sponsor 
#yiv8067813899ygrp-lc {font-family:Arial;}#yiv8067813899 
#yiv8067813899ygrp-sponsor #yiv8067813899ygrp-lc #yiv8067813899hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8067813899 
#yiv8067813899ygrp-sponsor #yiv8067813899ygrp-lc .yiv8067813899ad 
{margin-bottom:10px;padding:0 0;}#yiv8067813899 #yiv8067813899actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8067813899 
#yiv8067813899activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8067813899
 #yiv8067813899activity span {font-weight:700;}#yiv8067813899 
#yiv8067813899activity span:first-child 
{text-transform:uppercase;}#yiv8067813899 #yiv8067813899activity span a 
{color:#5085b6;text-decoration:none;}#yiv8067813899 #yiv8067813899activity span 
span {color:#ff7900;}#yiv8067813899 #yiv8067813899activity span 
.yiv8067813899underline {text-decoration:underline;}#yiv8067813899 
.yiv8067813899attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8067813899 .yiv8067813899attach div a 
{text-decoration:none;}#yiv8067813899 .yiv8067813899attach img 
{border:none;padding-right:5px;}#yiv8067813899 .yiv8067813899attach label 
{display:block;margin-bottom:5px;}#yiv8067813899 .yiv8067813899attach label a 
{text-decoration:none;}#yiv8067813899 blockquote {margin:0 0 0 
4px;}#yiv8067813899 .yiv8067813899bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8067813899 
.yiv8067813899bold a {text-decoration:none;}#yiv8067813899 dd.yiv8067813899last 
p a {font-family:Verdana;font-weight:700;}#yiv8067813899 dd.yiv8067813899last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8067813899 
dd.yiv8067813899last p span.yiv8067813899yshortcuts 
{margin-right:0;}#yiv8067813899 div.yiv8067813899attach-table div div a 
{text-decoration:none;}#yiv8067813899 div.yiv8067813899attach-table 
{width:400px;}#yiv8067813899 div.yiv8067813899file-title a, #yiv8067813899 
div.yiv8067813899file-title a:active, #yiv8067813899 
div.yiv8067813899file-title a:hover, #yiv8067813899 div.yiv8067813899file-title 
a:visited {text-decoration:none;}#yiv8067813899 div.yiv8067813899photo-title a, 
#yiv8067813899 div.yiv8067813899photo-title a:active, #yiv8067813899 
div.yiv8067813899photo-title a:hover, #yiv8067813899 
div.yiv8067813899photo-title a:visited {text-decoration:none;}#yiv8067813899 
div#yiv8067813899ygrp-mlmsg #yiv8067813899ygrp-msg p a 
span.yiv8067813899yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8067813899 
.yiv8067813899green {color:#628c2a;}#yiv8067813899 .yiv8067813899MsoNormal 
{margin:0 0 0 0;}#yiv8067813899 o {font-size:0;}#yiv8067813899 
#yiv8067813899photos div {float:left;width:72px;}#yiv8067813899 
#yiv8067813899photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv8067813899 
#yiv8067813899photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8067813899
 #yiv8067813899reco-category {font-size:77%;}#yiv8067813899 
#yiv8067813899reco-desc {font-size:77%;}#yiv8067813899 .yiv8067813899replbq 
{margin:4px;}#yiv8067813899 #yiv8067813899ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8067813899 #yiv8067813899ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8067813899 
#yiv8067813899ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8067813899 
#yiv8067813899ygrp-mlmsg select, #yiv8067813899 input, #yiv8067813899 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8067813899 
#yiv8067813899ygrp-mlmsg pre, #yiv8067813899 code {font:115% 
monospace;}#yiv8067813899 #yiv8067813899ygrp-mlmsg * 
{line-height:1.22em;}#yiv8067813899 #yiv8067813899ygrp-mlmsg #yiv8067813899logo 
{padding-bottom:10px;}#yiv8067813899 #yiv8067813899ygrp-msg p a 
{font-family:Verdana;}#yiv8067813899 #yiv8067813899ygrp-msg 
p#yiv8067813899attach-count span {color:#1E66AE;font-weight:700;}#yiv8067813899 
#yiv8067813899ygrp-reco #yiv8067813899reco-head 
{color:#ff7900;font-weight:700;}#yiv8067813899 #yiv8067813899ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv8067813899 #yiv8067813899ygrp-sponsor 
#yiv8067813899ov li a {font-size:130%;text-decoration:none;}#yiv8067813899 
#yiv8067813899ygrp-sponsor #yiv8067813899ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8067813899 
#yiv8067813899ygrp-sponsor #yiv8067813899ov ul {margin:0;padding:0 0 0 
8px;}#yiv8067813899 #yiv8067813899ygrp-text 
{font-family:Georgia;}#yiv8067813899 #yiv8067813899ygrp-text p {margin:0 0 1em 
0;}#yiv8067813899 #yiv8067813899ygrp-text tt {font-size:120%;}#yiv8067813899 
#yiv8067813899ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv8067813899


   

Kirim email ke