RE: ]] XL-mania [[ Membuat range nilai

 

Selamat Pagi,

Untuk membuat suatu range nilai berdasarkan data pada tabel, sebaiknya tabel rujukan dirubah dahulu formatnya menjadi lebih ‘sederhana’ sehingga kita bisa melakukan sort data secara accending untuk mempermudah pekerjaan seperti contoh terlampir.

Tabel rujukan doblok, trus copy>>paste special value, transpose.

Pada kolom keterangan kita tinggal masukkan kombinasi formula index-match. Namun pada tabel rujukan harus diberi kolom bantu terlebih dahulu supaya formula bisa berjalan normal.

Demikian dan semoga bisa membantu.

 

Regards,

AA

 

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Ruth Adi
Sent: Senin, 15 Maret 2010 15:52
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Membuat range nilai

 

 

Dear all,

mohon bantuan untuk kasus saya berikut ini.

Saya ingim melakukan penilaian terhadap beberapa orang

saya hanya punya nilai berupa angka, dan saya ingin mengetahui nilai orang2 tersebut dalam bentuk huruf/grup tertentu. (bisa dilihat di contoh soal)

nah, rumus apa yg saya pakai untuk menyelesaikan masalah itu

krn jika menggunakan fungsi if ga bisa.

 

Terima kasih.

Tanti

 

 

 

---

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

PT. IAF, Atrium Mulia Building, 5th Floor, Suite 503, Jl. H.R. Rasuna Said Kav B 10 -11, Jakarta, 12910, Tel. +62 21 5225902, Fax. +62 21 252 2605

Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 8.5.435 / Virus Database: 271.1.1/2678 - Release Date: 02/09/10 19:35:00

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 113

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| momods pecas ndaheeee... :( :( :(                                 | 
| 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

.

__,_._,___