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

saya coba bantu jawab ya..
coba ketik formula dibawah ini pada column E5
=IF(B5="","",VALUE(B5&"."&COUNTIF($B$5:B5,B5)))
mudah2an ini yang dikehendaki bung Achmad.

Salam XL-Mania
-pit-

---

From: ahmad <ahmad@tanabe.co.id>
To: XL-mania@yahoogroups.com
Sent: Wednesday, August 8, 2012 7:55 AM
Subject: ]] XL-mania [[ manambahka angka dibelakang secara otomatis

 

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.