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





 Inline image <blob:260d7969-a1ae-47b1-b52a-050466df6fec>







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.


Attachment: Blank 0.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke