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

 

Dear : Aa

Nyontek dari ilmu para suhu :

 

=IF((SUMPRODUCT(MAX(($B$5:D7=B8)*($D$5:D7)))+0,1)<B8;B8+0,1;SUMPRODUCT(MAX(($B$5:D7=B8)*($D$5:D7)))+0,1)

atau

=IF((MAX(INDEX(($B$5:B7=B8)*$D$5:D7;0))+0,1)<B8;B8+0,1;(MAX(INDEX(($B$5:B7=B8)*$D$5:D7;0))+0,1))

 

semoga membantu

Piet

Dari: ahmad <ahmad@tanabe.co.id>
Kepada: XL-mania@yahoogroups.com
Dikirim: Rabu, 8 Agustus 2012 7:55
Judul: ]] 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 | Start a New Topic

Messages in this topic (9)

Recent Activity:

• New Members 42

Visit Your Group

+-:: 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              |
+-------------------------------------------------------------------+

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

.

__,_._,___