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 <[email protected]> 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 > >
