Re: ]] XL-mania [[ Fill Blank "0"

 

Halo Kawie,

Dengan formula ataupun VBA, sudah umum.
File terlampir bukan solusi, tetapi iklan fitur Pivot Table. Sponsornya formula di kolom F.

Regards.
Kid.

2011/2/24 Survey, Batulicin <bsurvey@arutmin.com>

 

 

Master Excel,

 

Mohon pencerahannya, bagaimana cara pintas untuk memasukan "0' pada tiap perbedaan code di column pertama

karena selama ini kami masih cara manual, dapat dilihat pada lampiran berikut,

Terimakasih banyak,

 

salam,

kawie

Disclaimer   -   This  message  including any attachments and information contained
herein  ("Message" ) may contain  privileged information  or otherwise is protected
from  disclosure. Any  unauthorized use of this  Message  by any person may lead to
legal consequences.  If  you  receive this   Message  in error, or if the recipient
of this  Message  is not the intended recipient or the employee or agent authorized
for delivering this  Message to the intended recipient you are hereby notified that
any  disclosure,  dissemination, distribution  or copying of this Message or let or
cause this Message to be disclosed,disseminated, distributed, or copied is strictly
prohibited, and please notify the sender by  return message  and immediately delete
this  Message  from your system.   Incoming and outgoing  communications using this
electronic mail may be monitored by PT Arutmin Indonesia,as permitted by applicable
law and regulations. Unless it is made by the authorized person,any views expressed
in this Message  are those of the individual sender and may not necessarily reflect
the views of PT Arutmin Indonesia.
You should check attachments for viruses and defects before opening or using them.
We are not liable to recover any injuries caused by virused or defected attachments.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 96

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| sorry... moderasi super lemot... momods lagi sakit parah...       |
| buku terbaru XL mania: insipartif dan unik, gabungan antara buku  |
| aplikasi bisnis dan buku komputer. isinya tidak biasa!            |
| http://www.xl-mania.com/2011/02/mengapa-boss-benci-chart-anda.html|
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau...  |
| 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              |
+-------------------------------------------------------------------+

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___