RE: ]] XL-mania [[ manambahka angka dibelakang secara otomatis

Di cell D5 diketik formula : =IF($B5="";"";$B5&"."&COUNTIF($B$5:$B5;$B5))

Kemudian dicopy ke bawah

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of ahmad
Sent: 08 Agustus 2012 7:56
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ manambahka angka dibelakang secara otomatis
Importance: High

 

 

Dear All,

 

Mohon pencerahannya seperti data dibawah ini

 

 

Terimakasih.

 

Salam hormat,

Aa

 

Information provided in this email, including any attachments, is intended for the addressee named and deemed confidential property of PT. Tanabe Indonesia. Any use of information provided herein, including but not limited to the registered PT. Tanabe Indonesia name and logo are prohibited without the written permission of PT. Tanabe Indonesia. If you are not the intended recipient, any use, printing, copying or distribution of this e-mail or of any attachments to it is strictly prohibited. If you received this e-mail in error, please advise the sender immediately and delete the e-mail and any attachments from your system. Thank you.