Re: ]] XL-mania [[ Efek Cermin di Excel

 

Cara gampang laen dgn formula,
misal : data ada di $A$1:$F$6 ---> atau didefine dgn nama data

trus, hasilnya misal mau ditaruh di A8:F13
di A8 ketik array formula berikut :
=OFFSET(data,ROW()-8,6-COLUMN()) eksekusi dgn Ctrl+Shift+Enter

trus tarik aja formulanya ke kanan sampai F8 dan ke bawah sampai F13.. ato pake copy paste jg boleh..

kalo pengen hasilnya mereplace tabel yg lama ya tinggal copy-paste special value aja..

cheers,
-VD-

siti <setiyowati.devi@gmail.com> Sent by: XL-mania@yahoogroups.com 07/28/2009 08:37 PM Please respond to XL-mania@yahoogroups.com

To XL-mania@yahoogroups.com cc Subject Re: ]] XL-mania [[ Efek Cermin di Excel

 

Dlm pertanyaan tidak ada pembatasan CARA yg ditanyakan; apakah pakai FORMULA, FITURE dlm MENU, atau cara lain; Maka kita pilih cara yg ada & termudah: Select tabel tanpa mengikutkan kolom pertama Selection tsb di SORT dengan opsi LEFT TO RIGHT; Baris pertama yg berisi A, B, C, D.. dst itu dijadikan Row-Kunci Sorting (Sort By) > Descending. 2009/7/26 Asseggaf <seggaf@sbtcgroup.com>   Halo semua,... ada yang bisa bantu gak nih ?   Misalkan ada data seperti ini       A B C D E F 1 Garam Air Kacang Tomat Minyak   2 2 3 4 5   Minyak 3 4 5 6   7 Tomat 4 4 3   2 1 Kacang 5 6   7 8 9 Air 6   7 5 3 1 Garam     Nah aku ingin gimana cara untuk di balik seperti efek cermin dan menjadi hasilnya seperti ini,...     A B C D E F 1   Minyak Tomat Kacang Air Garam 2 Minyak   5 4 3 2 3 Tomat 7   6 5 4 4 Kacang 1 2   3 4 5 Air 9 8 7   6 6 Garam 1 3 5 7     Kira2 bagaimana yah caranya ? *** INTERNET E-MAIL CONFIDENTIALITY *** This message and any attachment hereto may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient, please notify the sender by return e-mail and destroy this message, along with any attachment. You are hereby formally advised that any unauthorized disclosure, copying or distribution of this material, or the taking of any action in relation to the contents is strictly prohibited. Thank you for your cooperation. JGC INDONESIA

__._,_.___

Messages in this topic (4) Reply (via web post) | Start a new topic

Messages

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| XL-mania, berjuang untuk rakyat, pancen oyeeee, LANJUTKAN!        |
| 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              |
+-------------------------------------------------------------------+

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

Recent Activity

•  61
  New Members

Visit Your Group

Give Back

Yahoo! for Good

Get inspired

by a good cause.

Y! Toolbar

Get it Free!

easy 1-click access

to your groups.

Yahoo! Groups

Start a group

in 3 easy steps.

Connect with others.

.

__,_._,___