Terimakasih semuanya yg udah memberikan pencerahan….ternyata banyak jalan 
menuju roma ya…hehehe

 

Regards

CW

 

From: [email protected] [mailto:[email protected]] 
Sent: Kamis, 24 Agustus 2017 06.44
To: [email protected]
Subject: Re: [belajar-excel] Penomoran otomatis

 

  

Dear CepWahyu

Mengulangi perintah Mr Kid, formula ini juga menggunakan IF.

di A11 ketik formula: =IF(LEN(B11)>1;MAX(A$10:$A10)+1;"")

Jabat erat

Nang

On 23/08/2017 19:11, 'Mr. Kid' [email protected] <mailto:[email protected]>  
[belajar-excel] wrote:

  

Hai Cep,

Coba pelajari lagi tentang fungsi IF.

 

Regards,

Kid

 

2017-08-23 15:09 GMT+07:00 'CepWahyu' [email protected] 
<mailto:[email protected]>  [belajar-excel] <[email protected] 
<mailto:[email protected]> >:

  

Dear Be-Exceller,

Bisakah di excel dibuat penomoran otomatis?

Penjelasan detail terlampir.

 

Regards

CW

 

 



Kirim email ke