Re: ]] XL-mania [[ Tulung2.. konversi kode pos ke Kode wilayah.. :D

 

Dear,
Boleh kombinasi fungsi INDEX, MATCH dan LEFT. Silahkan dilihat file terlampir.


Rgrds,
Wahyuddin K.

"rodih" <rodih@artarindo.com> Sent by: XL-mania@yahoogroups.com 02/24/2010 09:33 AM Please respond to XL-mania

To:        XL-mania@yahoogroups.com         cc:                 Subject:        ]] XL-mania [[ Tulung2.. konversi kode pos ke Kode wilayah.. :D

 

Dear All..

Butuh pertolongan neh...
Ane punya data yang di situ ituh ada kode pos ma kode wilayah.. (liat lampiran)

Bagaimana membuat program sederhana untuk menentukan kode kota setelah di ketahui kode pos tanpa mengecek ke tabel yang ada?
 
Thx excel mania..
 
Best Regards,
Rodih Al-Batawie

=========================================================================== This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. The Trakindo Group of Companies do not accept liability for damage caused by this email and may monitor email traffic. Unless expressly stated, any opinions are the sender's and are not approved by the Tiara Marga Trakindo Group of Companies and this email is not an offer, solicitation, recommendation or agreement of any kind. ===========================================================================

__._,_.___

Reply to sender | Reply to group

Messages in this topic (5)

Recent Activity:

• New Members 97

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| huaaaa... momods sakit... *sob*                                   | 
| 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

.

__,_._,___