Hai Ester,

Mau coba cara ruwet buntet yang gak asik n gak canggih ?

kalo mau ya ayuuuk....
kalo gak mau, silakan ditutup saja imil ini.

Langkah : (dibuang seluruh baris yang kolom tertentunya berisi numerik 0
nya ya)
1. aktifkan autofilter (ikuti caranya supaya tabel data tidak memiliki
potensi terpotong
    >> blok kolom tabel data dari A sampai i
    >> klik autofilter (ribbon Data -> group Sort & Filter -> Filter)
berulang kali sampai muncul segitiga kecil autofilter di header data
2. blok cells yang berformula di kolom i
    >> blok kolom i -> CTRL G -> klik Special -> pilih Formulas ->
hilangkan semua centang -> centang item Numbers -> klik OK
3. filter yang 0 (jangan klik cell, baris, kolom manapun)
    >> klik segitiga filter kolom i -> hilangkan centang dari item Select
all -> centang item 0 -> tekan OK
4. pilih cells terfilter (jangan klik cell, baris, kolom manapun)
    >> CTRL G -> klik Special -> pilih opsi Visible cells only -> OK
5. buang baris yang telah terpilih
    >> klik kanan sebuah cell hasil filter (yang nilainya 0) -> pilih
Delete atau Delete Row
          -> pilih Entire Row (kalau muncul pertanyaan) -> OK
6. non aktifkan autofilter (lakukan berulang sampai segitiga autofilter
telah hilanng dari header)
    >> ribbon Data -> group Sort & Filter -> Filter

Wassalam,
Kid.





On Thu, Nov 6, 2014 at 2:22 PM, 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