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