Adal gai cara yang lain Mr Liem,
Letakkan formula ini di cell c2 =IF(LEN(B2)>1;B2;C1) Salam DD From: hendrik karnadi [email protected] [belajar-excel] [mailto:[email protected]] Sent: 01 April 2015 13:44 To: [email protected] Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masih kosong Hai Liem, Coba2 begini.... Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan... Salam, HK _____ From: "Liem Suliem [email protected] [belajar-excel]" <[email protected]> To: [email protected] Sent: Wednesday, 1 April 2015, 12:29 Subject: [belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment] dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir... salam liem _____ 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.
