Mr. Kid, berhasil, terima kasih atas bantuannya.
ttd niky From: "Mr. Kid" <mr.nm...@gmail.com> To: BeExcel <belajar-excel@yahoogroups.com> Date: 20-05-2013 10:32 PM Subject: [Caution: Message contains Suspicious URL content] Re: [belajar-excel] Rumus pengganti fungsi pivot Sent by: belajar-excel@yahoogroups.com Hai Niky, Untuk menyusun kolom kode menggunakan array formula dengan syarat adalah yang lebih tinggi dari nilai kode sebelumnya. Jika kode pertama diletakkan pada cell L29, maka array formula L29 : =IF(N(L28)+(LEFT(L28)="K"),MIN(IF(MID($A$2:$A$14,5,1)*1>N(L28),1*MID($A$2:$A$14,5,1))),"") file terlampir. Wassalam, Kid. On Mon, May 20, 2013 at 3:12 PM, <niky_nugr...@manulife.com> wrote: Dear Para Master, Mohon pencerahan untuk rumus pengganti fungsi pivot. Saya lampirkan filenya dimana biasanya saya menggunakan pivot dengan patokan mengambil angka pada kolom code sebagai patokannya. Terima kasih atas bantuannya. ttd niky n ========================================================== Please consider the environment before printing this email. This message is confidential and may also be privileged. If you are not the intended recipient, please notify me by return e-mail and delete this message from your system. If you are not the intended recipient, any use by you of this message is strictly prohibited. We reserve our right to pursue any available legal action based on the prevailing laws due to any misuse of this e-mail or information contained herein. [attachment "re-Rumus pengganti pivot.xls" deleted by Niky Nugraha/Asia Division/Manulife] ========================================================== Please consider the environment before printing this email. This message is confidential and may also be privileged. If you are not the intended recipient, please notify me by return e-mail and delete this message from your system. If you are not the intended recipient, any use by you of this message is strictly prohibited. We reserve our right to pursue any available legal action based on the prevailing laws due to any misuse of this e-mail or information contained herein.
<<image/gif>>
<<image/gif>>
