coba,
kolom bantu:
Kolom Kode:
=TEXT(COUNTIF(D$5:D5,D5),"000")
>semoga bermanfaat
kolom bantu:
=IF(ISNUMBER(FIND(" ",B5)),LEFT(B5,2)&MID(B5,FIND(" ",B5,1)+1,2)&MID(B5,FIND("|",SUBSTITUTE(B5," ","|",MIN(2,LEN(B5)-LEN(SUBSTITUTE(B5," ","")))))+1,2),REPT(LEFT(B5,2),3))
Kolom Kode:
=TEXT(COUNTIF(
>semoga bermanfaat
From: Sunny Pardede <sunny.pardede@
To: XL Mania <xl-mania@yahoogroup
Sent: Mon, November 2, 2009 4:22:09 PM
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
__._,_.___
+-:: 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