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 Debora [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 rekan2 bagaimana cara menghapus baris dengan "total 0
> (nol)" sebungan dengan data2 tersebut sampai ratusan sehingga kalau
> dikerjakan dengan delete perkolom akan memakan waktu yang sangat banyak,
> Contoh tabelnya seperti di bawah ini
>  Terimakasih atas bantuannya
>
>  [image: Inline image]
>
>  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 and
> intended solely for the use of the individual to whom it is addressed. If
> you have received this email in error please send it back to the person
> that sent it to you. Any views or opinions presented are solely those of
> its author and do not necessarily represent those of NABATI or any of its
> subsidiary companies. Unauthorized publication, use, dissemination,
> forwarding, printing or copying of this email and its associated
> attachments is strictly prohibited.
>
>
>    
>

Kirim email ke