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