Re: ]] XL-mania [[ Mencari saldo awal

 

Dear Ruth,

Aktifkan auto filter, kemudian filter pada kolom Nomor Kontrak. Hilangkan centang pada nilai blank. Copy hasil filter ke tempat lain, jika akan membuat salinannya.

Regards.
Kid.

On Thu, Aug 12, 2010 at 5:19 PM, Ruth Adi <ruth.adi@iaf.co.id> wrote:

 

Dear XL-lovers & XL-expert,

Mohon bantuan nih.

Saya punya data (terlampir).

Dari data yang ada saya ingin menentukan saldo awal.

Saldo awal adalah posisi pertama dari sekian nomor kontrak yang sama (seperti yg saya maksud dg cara yg manual).

Ada cara yang lebih mudah kah? Daripada saya copy paste satu2 ke sheet yang lain.

 

Mohon bantuannya ya guys.

 

Thanx a lot..

 

 

Regards,

Ruth

 

 

---

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

__._,_.___

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

Messages in this topic (2)

Recent Activity:

• New Members 82

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| selamat menunaikan ibadah puasa... walau perut lapar, tanya excel |
| jalan terus... malu bertanya telat pulang kantor :D :D :D         |
| 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

.

__,_._,___