rumus untuk mengotomatiskan KodeVendor cukup pendek
=D5&TEXT(COUNTIF(D$5:D5,D5),"000")
tetapi di D5 harus dibuat formula bantuan berupa array-mega-formula yg cukup panjang
=CHOOSE(IF(COUNT(IF(MID(" "&B5,ROW($1:$99),1)=" ",ROW($1:$99)))>3,3,COUNT(IF(MID(" "&B5,ROW($1:$99),1)=" ",ROW($1:$99)))),REPT(LEFT(B5,2),3),LEFT(B5,2)&REPT(MID(B5,SMALL(IF(MID(" "&B5,ROW($1:$99),1)=" ",ROW($1:$99)),2),2),2),LEFT(B5,2)&MID(B5,SMALL(IF(MID(" "&B5,ROW($1:$99),1)=" ",ROW($1:$99)),2),2)&MID(B5,SMALL(IF(MID(" "&B5,ROW($1:$99),1)=" ",ROW($1:$99)),3),2))
rumus yg lebih pendek, akan dikirimkan setelah melihat tanggapan lain (dari penanggap maupun pemilik thread.)
----- Original Message -----
From: Sunny Pardede
To: XL Mania
Sent: Monday, November 02, 2009 04:22PM
Subject: ]] XL-mania [[ Kode Vedor
Para Pakar,
Mohon bantuannya, saya sedang mengerjakan daftar vendor, dan membuat kode vendor
secara otomatis dengan fungsi Left, Mid & Right.
Terlampir file berisikan contoh yg di inginkan.....
Rgds,
SP
Rgds,
SP
__._,_.___
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Pcas ndahe... pcas ndahe... pcas ndahe... pcas ndahe... |
| 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 |
+-------------------------------------------------------------------+
| Pcas ndahe... pcas ndahe... pcas ndahe... pcas ndahe... |
| 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 |
+-------------------------------------------------------------------+
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
.
__,_._,___
Nenhum comentário:
Postar um comentário