Dear all,
Contoh data terlampir
Cara yang demikian bisa tapi karena data ini urutannya harus tetap sama,
berarti harus dinomerin dulu ya, agar setelah didelete bisa disort berdasarkan
nama? atau apakah ada cara yang lain.?
Terimakasih
On Thursday, November 6, 2014 11:15 AM, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> wrote:
Bagaiman akalu disort saja sehingga yang nilainya nol diletakkan paling
bawah,
Blok semua data klik ribbon Data sort, Sort By : column G, Order: Z to A, KLik
OK
Hapus yang tidak dibutuhkan
On Thu, Nov 6, 2014 at 10:22 AM, 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.
#yiv3545976336 #yiv3545976336 -- #yiv3545976336ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3545976336
#yiv3545976336ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3545976336
#yiv3545976336ygrp-mkp #yiv3545976336hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3545976336 #yiv3545976336ygrp-mkp #yiv3545976336ads
{margin-bottom:10px;}#yiv3545976336 #yiv3545976336ygrp-mkp .yiv3545976336ad
{padding:0 0;}#yiv3545976336 #yiv3545976336ygrp-mkp .yiv3545976336ad p
{margin:0;}#yiv3545976336 #yiv3545976336ygrp-mkp .yiv3545976336ad a
{color:#0000ff;text-decoration:none;}#yiv3545976336 #yiv3545976336ygrp-sponsor
#yiv3545976336ygrp-lc {font-family:Arial;}#yiv3545976336
#yiv3545976336ygrp-sponsor #yiv3545976336ygrp-lc #yiv3545976336hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3545976336
#yiv3545976336ygrp-sponsor #yiv3545976336ygrp-lc .yiv3545976336ad
{margin-bottom:10px;padding:0 0;}#yiv3545976336 #yiv3545976336actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3545976336
#yiv3545976336activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3545976336
#yiv3545976336activity span {font-weight:700;}#yiv3545976336
#yiv3545976336activity span:first-child
{text-transform:uppercase;}#yiv3545976336 #yiv3545976336activity span a
{color:#5085b6;text-decoration:none;}#yiv3545976336 #yiv3545976336activity span
span {color:#ff7900;}#yiv3545976336 #yiv3545976336activity span
.yiv3545976336underline {text-decoration:underline;}#yiv3545976336
.yiv3545976336attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3545976336 .yiv3545976336attach div a
{text-decoration:none;}#yiv3545976336 .yiv3545976336attach img
{border:none;padding-right:5px;}#yiv3545976336 .yiv3545976336attach label
{display:block;margin-bottom:5px;}#yiv3545976336 .yiv3545976336attach label a
{text-decoration:none;}#yiv3545976336 blockquote {margin:0 0 0
4px;}#yiv3545976336 .yiv3545976336bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3545976336
.yiv3545976336bold a {text-decoration:none;}#yiv3545976336 dd.yiv3545976336last
p a {font-family:Verdana;font-weight:700;}#yiv3545976336 dd.yiv3545976336last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3545976336
dd.yiv3545976336last p span.yiv3545976336yshortcuts
{margin-right:0;}#yiv3545976336 div.yiv3545976336attach-table div div a
{text-decoration:none;}#yiv3545976336 div.yiv3545976336attach-table
{width:400px;}#yiv3545976336 div.yiv3545976336file-title a, #yiv3545976336
div.yiv3545976336file-title a:active, #yiv3545976336
div.yiv3545976336file-title a:hover, #yiv3545976336 div.yiv3545976336file-title
a:visited {text-decoration:none;}#yiv3545976336 div.yiv3545976336photo-title a,
#yiv3545976336 div.yiv3545976336photo-title a:active, #yiv3545976336
div.yiv3545976336photo-title a:hover, #yiv3545976336
div.yiv3545976336photo-title a:visited {text-decoration:none;}#yiv3545976336
div#yiv3545976336ygrp-mlmsg #yiv3545976336ygrp-msg p a
span.yiv3545976336yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3545976336
.yiv3545976336green {color:#628c2a;}#yiv3545976336 .yiv3545976336MsoNormal
{margin:0 0 0 0;}#yiv3545976336 o {font-size:0;}#yiv3545976336
#yiv3545976336photos div {float:left;width:72px;}#yiv3545976336
#yiv3545976336photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3545976336
#yiv3545976336photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3545976336
#yiv3545976336reco-category {font-size:77%;}#yiv3545976336
#yiv3545976336reco-desc {font-size:77%;}#yiv3545976336 .yiv3545976336replbq
{margin:4px;}#yiv3545976336 #yiv3545976336ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3545976336 #yiv3545976336ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3545976336
#yiv3545976336ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3545976336
#yiv3545976336ygrp-mlmsg select, #yiv3545976336 input, #yiv3545976336 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3545976336
#yiv3545976336ygrp-mlmsg pre, #yiv3545976336 code {font:115%
monospace;}#yiv3545976336 #yiv3545976336ygrp-mlmsg *
{line-height:1.22em;}#yiv3545976336 #yiv3545976336ygrp-mlmsg #yiv3545976336logo
{padding-bottom:10px;}#yiv3545976336 #yiv3545976336ygrp-msg p a
{font-family:Verdana;}#yiv3545976336 #yiv3545976336ygrp-msg
p#yiv3545976336attach-count span {color:#1E66AE;font-weight:700;}#yiv3545976336
#yiv3545976336ygrp-reco #yiv3545976336reco-head
{color:#ff7900;font-weight:700;}#yiv3545976336 #yiv3545976336ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3545976336 #yiv3545976336ygrp-sponsor
#yiv3545976336ov li a {font-size:130%;text-decoration:none;}#yiv3545976336
#yiv3545976336ygrp-sponsor #yiv3545976336ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3545976336
#yiv3545976336ygrp-sponsor #yiv3545976336ov ul {margin:0;padding:0 0 0
8px;}#yiv3545976336 #yiv3545976336ygrp-text
{font-family:Georgia;}#yiv3545976336 #yiv3545976336ygrp-text p {margin:0 0 1em
0;}#yiv3545976336 #yiv3545976336ygrp-text tt {font-size:120%;}#yiv3545976336
#yiv3545976336ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3545976336
Data Excell.xlsx
Description: MS-Excel 2007 spreadsheet

