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. > > > >

