Hot Fox: Re: ]] XL-mania [[ merubah angka menjadi huruf

quarta-feira, 30 de junho de 2010

Re: ]] XL-mania [[ merubah angka menjadi huruf

Astaghfirullah, ada kekeliruan pada pemasangan absolut reference-nya.
Formula mestinya :
=INDEX($A$2:$D$2,MATCH(J$2,$A3:$D3,0))
jika data dan cell hasil seperti pada file terlampir.

Terimakasih buat mbak Siti yang menyempatkan diri mengingatkan.
Mohon maaf kepada semua pihak yang telah tersesatkan dengan adanya formula yang tempo hari dikirim.

Regards.
Kid.

2010/6/24 Edy Budiardjo <edy_b@gt-tires.com>

Mohon bantuannya untuk merubah bentuk form di bawah ini :

A B C D 1 2 3

1 2 3 0 A B C

1 2 3 0 A B C

1 2 0 3 A B D

1 2 0 3 A B D

1 0 2 3 A C D

0 1 2 3 B C D

0 1 2 3 B C D

3 1 2 0 B C A

3 1 2 0 B C A

3 1 0 2 B D A

3 0 1 2 C D A

3 0 1 2 C D A

0 3 1 2 C D B

0 3 1 2 C D B

2 3 1 0 C A B

2 3 0 1 D A B

2 3 0 1 D A B

2 0 3 1 D A C

2 0 3 1 D A C

0 2 3 1 D B C

1 2 3 0 A B C

1 2 3 0 A B C

1 2 0 3 A B D

1 2 0 3 A B D

1 0 2 3 A C D

0 1 2 3 B C D

0 1 2 3 B C D

3 1 2 0 B C A

3 1 2 0 B C A

3 1 0 2 B D A

3 0 1 2 C D A

sebelumnya terima kasih

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

New Members 134

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| jangan lupa sebelum bertanya, cek dulu www.XL-mania.com dan       |
| http://tech.groups.yahoo.com/group/XL-mania/messages              |
| 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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

Get real-time World Cup coverage on the Yahoo! Toolbar. Download now to win a signed team jersey!

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

__,_._,___

Nenhum comentário:

Postar um comentário

A	B	C	D	1	2	3
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A
3	0	1	2	C	D	A
0	3	1	2	C	D	B
0	3	1	2	C	D	B
2	3	1	0	C	A	B
2	3	0	1	D	A	B
2	3	0	1	D	A	B
2	0	3	1	D	A	C
2	0	3	1	D	A	C
0	2	3	1	D	B	C
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A

A	B	C	D	1	2	3
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A
3	0	1	2	C	D	A
0	3	1	2	C	D	B
0	3	1	2	C	D	B
2	3	1	0	C	A	B
2	3	0	1	D	A	B
2	3	0	1	D	A	B
2	0	3	1	D	A	C
2	0	3	1	D	A	C
0	2	3	1	D	B	C
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A

Hot Fox

quarta-feira, 30 de junho de 2010

Re: ]] XL-mania [[ merubah angka menjadi huruf

Nenhum comentário:

Arquivo do blog

A	B	C	D	1	2	3
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A
3	0	1	2	C	D	A
0	3	1	2	C	D	B
0	3	1	2	C	D	B
2	3	1	0	C	A	B
2	3	0	1	D	A	B
2	3	0	1	D	A	B
2	0	3	1	D	A	C
2	0	3	1	D	A	C
0	2	3	1	D	B	C
1	2	3	0	A	B	C
1	2	3	0	A	B	C
1	2	0	3	A	B	D
1	2	0	3	A	B	D
1	0	2	3	A	C	D
0	1	2	3	B	C	D
0	1	2	3	B	C	D
3	1	2	0	B	C	A
3	1	2	0	B	C	A
3	1	0	2	B	D	A
3	0	1	2	C	D	A