]] XL-mania [[ Digest Number 2460

Microsoft Excel Community Group

1 New Message

Digest #2460

1a Re: manambahka angka dibelakang secara otomatis by "adrian piter" petcures2003

Message

1a

Re: manambahka angka dibelakang secara otomatis

Fri Aug 10, 2012 3:01 am (PDT) . Posted by:

"adrian piter" petcures2003

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.

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

Visit Your Group

>

View All Topics

>

Create New Topic

>

40 New Members

>

We are making changes based on your feedback, Thank you !

Submit Feedback

>

The Yahoo! Groups Product Blog

Check it out!

>

GROUP FOOTER MESSAGE

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Selamat beribadah puasa...                                        |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

CHANGE SETTINGS

>

TERMS OF USE

>

UNSUBSCRIBE

>