Array formula ? Coba jalan-jalan kesini <http://excel-mr-kid.blogspot.com/2011/03/array-formula-kenalan-yuuuk.html>.
2014-10-16 19:51 GMT+11:00 Samsudin [email protected] [belajar-excel] < [email protected]>: > > > Dear Pak Agus, > > > > Setelah jalankan cara seperti dibawah kenapa masih tetap tidak bisa dan > bagaimana caranya menuliskan rumus array sehingga muncul kurung kurawal > karena di laptop saya ini tidak bisa muncul dan perintah tekan tekan tombol > F2. > > lalu tekan tombol Ctrl dan tombol Shift, jangan dilepas dulu 2 tombol tsb. > (Ctrl+Shift) > > Lalu tekan tombol Enter, juga tidak muncul kurung kurawal. > > > > Bagaimana cara yang bisa dilakukan pada latop saya, sebagai informasi saya > menggunakan Microsoft office 2010. > > > > *Hormat saya,* > > > > *Samsudin, ST* > > *P&M Dept Head* > > > > *[image: Description: Description: cid:[email protected]] **PT. > GUNUNGBAYAN PRATAMACOAL (Bayan Group Resources)* > > O: +62 542 875 860 Ext :61519 | > > M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected] > > P Save a tree & save energy. Don't print this e-mail unless it's > really necessary. Go Green !!! > > ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 > > > > *From:* [email protected] [mailto: > [email protected]] > *Sent:* Thursday, October 16, 2014 4:21 PM > > *To:* [email protected] > *Subject:* Re: [belajar-excel] menginput data secara otomatis dengan satu > key > > > > > > > > Pak Samsudin; > > > > Ini adalah Array formula.. > > jadi setelah rumusnya dirubah jangan hanya ditekan Enter saja, tekan 3 > tombol (Ctrl+Shift+Enter) > > > > Coba pada pada M5, tekan tombol F2. > > lalu tekan tombol Ctrl dan tombol Shift, jangan dilepas dulu 2 tombol tsb. > (Ctrl+Shift) > > Lalu tekan tombol Enter. > > maka formulanya akan ada tambahan kurung kurawal {} > > > > Oia, jika indexnya dirubah menjadi $D$2:$D$1026, maka pada row juga > demikian row($C$2:$C$1026) > > > > > > Wassalam > > ~ Bagus ~ > > ----- Original Message ----- > > *From:* Samsudin [email protected] [belajar-excel] > <[email protected]%20[belajar-excel]> > > *To:* [email protected] > > *Sent:* Thursday, October 16, 2014 2:25 PM > > *Subject:* RE: [belajar-excel] menginput data secara otomatis dengan satu > key [1 Attachment] > > > > > > Dear Master Excel, > > Pada kolom 2 rumus aslinya : > =IFERROR(INDEX(D$2:D$112,SMALL(IF($M$1=$C$2:$C$112,ROW($C$2:$C$112)-ROW($C$1)),ROW(1:1))),"") > diubah menjadi = > =IFERROR(INDEX(D$2:D$1026,SMALL(IF($M$1=$C$2:$C$1026,ROW($C$2:$C$112)-ROW($C$1)),ROW(1:1))),"") > dst disini diubah karena penambahan data, akan tetapi setelah kita cek > ternyata tampilan berbeda dengan sebelum data ditambah dan rumus diubah, > mohon pencerahannya. > > *Hormat saya,* > > *Samsudin, ST* > > *P&M Dept Head* > > > > *[image: Description: Description: cid:[email protected]] **PT. > GUNUNGBAYAN PRATAMACOAL (Bayan Group Resources)* > > O: +62 542 875 860 Ext :61519 | > > M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected] > > P Save a tree & save energy. Don't print this e-mail unless it's > really necessary. Go Green !!! > > ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] > *Sent:* Thursday, October 16, 2014 10:46 AM > *To:* [email protected] > *Subject:* Re: [belajar-excel] menginput data secara otomatis dengan satu > key [1 Attachment] > > > > > > Wa'alaykum salam warohmatullohi wabarokatuhu > > Pak Samsudin; > > Sila lihat file terlampir > > semoga sesuai harapan > > Wassalam > > ~ Bagus ~ > > ----- Original Message ----- > > *From:* Samsudin [email protected] [belajar-excel] > <[email protected]%20[belajar-excel]> > > *To:* [email protected] > > *Sent:* Thursday, October 16, 2014 9:14 AM > > *Subject:* [belajar-excel] menginput data secara otomatis dengan satu key > [1 Attachment] > > > > *وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ عَلَيْكُمْ السَّلاَمُ* > > Dikarenakan saya baru bergabung dengan milis belajar-excel dan saya tidak > mengerti bagaimana cara mengirim posting seputar masalah excel maka saya > mengirim melalui email ini dan berikut masalah saya hadapi. > > Data ini berasal dari pemakaian harian dan saya ingin mengetahui pemakaian > barang dengan kunci pencarian GIN, dimana form tersebut tersedia hanya 15 > item nama barang : > > *GIN* > > GIN14-4580 > > *Control No* > > PGS400-15 > > *Date* > > 01-Sep-2014 > > *Category* > > FIL > > *No* > > *Code No* > > *Descriprion* > > *Qty* > > *Unit* > > *Cost* > > 1 > > 2 > > 3 > > 4 > > 5 > > 6 > > 7 > > 8 > > 9 > > 10 > > 11 > > 12 > > 13 > > 14 > > 15 > > *Total* > > *$ - * > > Bagaimana caranya data tersebut bisa dinput kedalam form tersebut secara > otomatis dari data sebelahnya. > > Sebelumnya saya mengucapkan terima kasih. > > *وَبَرَكَاتُهُ اللهِ وَرَحْمَةُ َلَيْكُمْ السَّلاَمُوَ* > > *Samsudin, ST* > > *P&M Dept Head* > > > > *[image: Description: Description: cid:[email protected]] **PT. > GUNUNGBAYAN PRATAMACOAL (Bayan Group Resources)* > > O: +62 542 875 860 Ext :61519 | > > M: +62 811 2810 068 | +62 813 6914 7150 | email: [email protected] > > P Save a tree & save energy. Don't print this e-mail unless it's > really necessary. Go Green !!! > > ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007 > > *From:* [email protected] [ > mailto:[email protected] <[email protected]>] > *Sent:* Thursday, October 16, 2014 8:04 AM > *To:* [email protected] > *Subject:* Re: [belajar-excel] UserForm Login [1 Attachment] > > > > Coba file ini dibuka, salah satu passwordnya "Tempe" :D > > kemudian coba isi sheet form, trus simpan, lakukan bersamaan di beberapa > kompie. > > > > On 15/10/2014 22:17, belajar excell [email protected] > [belajar-excel] wrote: > > > > Pak DP, > > > > > > File yang saya buat untuk di share itu ekstensinya itu .xlsm dan .xlsb, > dan ternyata tidak bisa untuk di share karena mengandung unsur VBnya, > > maaf pak, tapi saya belum ngerti dengan maksud bpk yang ini : " kalau > ingin menambahkan code VBA musti di matikan dulu fitur shared nya, baru > ditambahkan code vba / formnya, kemudian baru di share lagi ". > > > > > > Mohon penjelasannya ya Pak..maklum saya belajar excel hanya tabrak sana > dan tabrak sini,,hehe > > > > > > Terima kasih > > On Wednesday, October 15, 2014 9:40 AM, "De Premor [email protected] > [belajar-excel]" <[email protected]> > <[email protected]> wrote: > > > > Apakah format file workbook yang di shared tersebut mendukung makro (xlsm > atau xlsb) ? > Pada Shared workbook vba nya tidak dapat diedit, kalau ingin menambahkan > code VBA musti di matikan dulu fitur shared nya, baru ditambahkan code vba > / formnya, kemudian baru di share lagi. > > Rgds, > [dp] > > > > On 14/10/2014 18:56, belajar excell [email protected] > [belajar-excel] wrote: > > > > Pak Kid, > > it works, terima kasih bnyk ya pak atas bantuannya.. > > o ia pak..tujuan saya buat login form adalah untuk mengkombinasikan dengan > workbook yang di shared..namun ternyata worksbook yang di shared tidak dpat > membaca kode VBAnya ya.. > > Bgamaimana caranya pak agar excel ini dpt di pakai multi user, tapi di > kombinasikan dengan login form yang kita sudah buat ? > > Salam, > > R > > On Monday, October 13, 2014 7:52 PM, "belajar excell > [email protected] [belajar-excel]" <[email protected]> > <[email protected]> wrote: > > > > trima kasih banyak Pak NangAgus untuk bantuannya.. > > untuk nomor dua itu mksd saya ada tanda "x" pada user name Pak, jadi pada > saat kita klik tanda x itu, workbook akan otomatis tertutup dengan > sendirinya, > > Mohon bantuannya ya Pak.. > > Regards > > Ronny S > > On Monday, October 13, 2014 8:30 AM, "Nang Agus [email protected] > [belajar-excel]" <[email protected]> > <[email protected]> wrote: > > > > Dear Belajar Excel, > > 1. Coba dibuat pada object workbook dengan prosedur open: > Private Sub Workbook_Open() > Sheet1.visible = xlSheetVeryHidden > Sheet3.visible = xlSheetVeryHidden > Sheet4.visible = xlSheetVeryHidden > Sheet5.visible = xlSheetVeryHidden > Sheet6.visible = xlSheetVeryHidden > > end sub > > 2. > > Private sub userform_terminate () > > Me.Hide > > End sub > > Wasalam > > NangAgus > > 2014-10-12 19:28 GMT+07:00 belajar excell [email protected] > [belajar-excel] <[email protected]>: > > > > Selamat malam rekan2 pecinta excel, > > Pada saat ini saya sedang membuat userform, tapi ada beberapa kendala yang > saya temui, > > 1. Bgaimana caranya agar Pada saat pertama kli userform muncul, > hanya sheet > Hal Dep saja yang keliatan, dan sheet yang lainnya tersembunyi ? > > 2. Untuk terminate userform, saya hanya memakain VBA code seperti > di bawah ini : > > Private sub userform_terminate () > > Thisworkbook.close 1 > > End sub > > Tapi pada saat saya mengisi user name dan juga password, > yang ada malah excel langsung tertutup. > > Mohon bantuannya ya teman2 smuanya, > > Terima kasih sebelummnya.. > > --------------------------------------------------------------------------------------------------- > > > > This message (including any attachments) contains confidential information > intended > > for a specific individual and purpose, and is protected by law. If you are > not the > > intended recipient, you should delete this message and hereby notified that > any > > disclosure, copying, or distribution of this message (or any part thereof), > or the > > taking of any action based on it, is strictly prohibited. No liability or > responsibility > > is accepted if information or data is, for whatever reason corrupted or does > not reach > > its intended recipient. No warranty is given that this email is free of > viruses. The > > views expressed in this email are, unless otherwise stated, those of the > author and > > not those of the Company or its management. The Company reserves the right to > monitor, > > intercept and block emails addressed to its users or take any other action in > accordance > > with its email use policy. > > --------------------------------------------------------------------------------------------------- > > > > This message (including any attachments) contains confidential information > intended > > for a specific individual and purpose, and is protected by law. If you are > not the > > intended recipient, you should delete this message and hereby notified that > any > > disclosure, copying, or distribution of this message (or any part thereof), > or the > > taking of any action based on it, is strictly prohibited. No liability or > responsibility > > is accepted if information or data is, for whatever reason corrupted or does > not reach > > its intended recipient. No warranty is given that this email is free of > viruses. The > > views expressed in this email are, unless otherwise stated, those of the > author and > > not those of the Company or its management. The Company reserves the right to > monitor, > > intercept and block emails addressed to its users or take any other action in > accordance > > with its email use policy. > > > --------------------------------------------------------------------------------------------------- > > This message (including any attachments) contains confidential information > intended > for a specific individual and purpose, and is protected by law. If you are > not the > intended recipient, you should delete this message and hereby notified that > any > disclosure, copying, or distribution of this message (or any part thereof), > or the > taking of any action based on it, is strictly prohibited. No liability or > responsibility > is accepted if information or data is, for whatever reason corrupted or does > not reach > its intended recipient. No warranty is given that this email is free of > viruses. The > views expressed in this email are, unless otherwise stated, those of the > author and > not those of the Company or its management. The Company reserves the right to > monitor, > intercept and block emails addressed to its users or take any other action in > accordance > with its email use policy. > > >
