RE: ]] XL-mania [[ Konversi Text Angka ke Bilangan terurut menaik.

 

Dear Bu Guru,

Jikalau boleng menggunakan dummy, maka sepertinya saya boleh ngikut kali yah walaupun formulanya Puannnjaang. Sambil mengunggu hasil dari para master.

 

Thanks & Regards,

 

AHMAD ADRIANSYAH

TRAC - ASTRA RENT A CAR

---

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of siti Vi
Sent: Friday, November 27, 2009 1:40 PM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Konversi Text Angka ke Bilangan terurut menaik.

 

 

Dear XL-maniawan / XL-maniawati...

Daripada bengong.. ini ada hiburan "CelengPalsu(1) edisi Akhir Nov 09:

 

Bagaimana cara mengkonversi data seperti di bawah ini

Data Referensi (INPUT) : Text gabungan banyak angka dlm 1 cell, tanda pemisah "-"

Data Hasil (OUTPUT) : Bilangan dlm cell terpisah terurut menaik.

 

data	contoh hasil yang diinginkan
38-44-23-19-02-15-91-01-45-32	1	2	15	19	23	32	38	44	45	91
05-89-43-11-56-03-25-81-67-29	3	5	11	25	29	43	56	67	81	89
11-93-42-81-10-01-97-36-17-72	1	10	11	17	36	42	72	81	93	97
87-15-22-73-23-46-09-03-38-17	3	9	15	17	22	23	38	46	73	87
38-44-23-19-02-15-91-01-45-32-22	1	2	15	19	22	23	32	38	44	45	91
05-89-43-11-56-03-25-81-67-29-41-05-34	3	5	5	11	25	29	34	41	43	56	67	81
11-93-42-81-10-01-97-36-17	1	10	11	17	36	42	81	93	97
87-15-22-73-23-46-09	9	15	22	23	46	73	87

 

~ctv~

mari kita [belajar-excel]

Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 8.5.425 / Virus Database: 270.14.74/2515 - Release Date: 11/20/09 08:02:00

__._,_.___

Reply to sender | Reply to group

Messages in this topic (4)

Recent Activity:

• New Members 71

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Momods lagi hanimuuunnn...                                        |
| 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

Going Green: Your Yahoo! Groups resource for green living

---

Parenting Zone: Your community resource for family and home

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

.

__,_._,___