hehehe... kan bisa belajar. Array formula kan magic wand-nya Excel... Coba yang ini deh : =SMALL(INDEX(COUNTIF(LibNas,B7+ROW($1:$100)-1)*10^9+(B7+ROW($1:$100)-1),0),C7)
Wassalam, Kid. 2012/11/16 <[email protected]> > ** > > > ** Selain menggunakan array formula, bisa tidak ya Mr Kid, soalnya kalo > array tiny belum paham cara membaca formulanya :) > > Salam > Tiny > Powered by Telkomsel BlackBerry® > ------------------------------ > *From: * "Mr. Kid" <[email protected]> > *Sender: * [email protected] > *Date: *Fri, 16 Nov 2012 15:39:50 +0700 > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional > > > > Bagaimana kalau bagian Row(blabla) dikurangi 1 ? > =SMALL(IF(COUNTIF(LibNas,B7+ROW($1:$100)-1)=0,B7+ROW($1:$100)-1),C7) > > Wassalam, > Kid. > > 2012/11/16 <[email protected]> > >> ** >> >> >> ** :( hasilnya masih sama dgn yg tadi Mr Kid, bahkan lompat harinya >> lebih jauh, tidak tepat seperti hasil akhir tgl yg diinginkan >> >> Salam >> Tiny >> Powered by Telkomsel BlackBerry® >> ------------------------------ >> *From: * "Mr. Kid" <[email protected]> >> *Sender: * [email protected] >> *Date: *Fri, 16 Nov 2012 13:57:42 +0700 >> *To: *<[email protected]> >> *ReplyTo: * [email protected] >> *Subject: *Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional >> >> >> >> hehehe... >> coba *array formula* : (asumsi : maksimal jumlah *hari tambahan* adalah >> 50. >> Ganti angka *100 *dengan angka lainnya (*2 kali lipat maksimal jumlah >> hari tambahan*)) >> =SMALL(IF(COUNTIF(*LibNas*,B7+ROW($1:$*100*))=0,B7+ROW($1:$*100*)),*C7*) >> Pastikan hari *minggu *masuk dalam daftar *LibNas* >> >> Tapi formula di atas belum dicoba untuk banyak macam posisi hari dan >> *tambahan >> hari* (nilai *C7*) >> >> Wassalam, >> Kid. >> >> On Fri, Nov 16, 2012 at 1:35 PM, <[email protected]> wrote: >> >>> ** >>> >>> >>> ** Tidak mewakili Mr Kid, karena jika saya menggunakan hari kerja 4 >>> hari maka tgl terakhir adalah 28 Okt, sedangkan tgl 28 adalah hari minggu >>> yaitu hari yg tidak diperhitungkan sebagai hari kerja, jadi jika 4 hari >>> seharusnya jatuh pada tgl 29 karena tgl 26 dan 28 adalah tanggal merah. >>> Salam >>> Tiny >>> Powered by Telkomsel BlackBerry® >>> ------------------------------ >>> *From: * "Mr. Kid" <[email protected]> >>> *Sender: * [email protected] >>> *Date: *Fri, 16 Nov 2012 13:30:07 +0700 >>> *To: *<[email protected]> >>> *ReplyTo: * [email protected] >>> *Subject: *Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional >>> >>> >>> >>> Coba pada D7 : >>> =b7 + c7 >>> >>> Wassalam, >>> Kid. >>> >>> On Fri, Nov 16, 2012 at 1:16 PM, <[email protected]> wrote: >>> >>>> ** >>>> >>>> >>>> Dear All, >>>> Saya ingin membuat tanggal jatuh tempo dgn tidak memperhitungkan libur >>>> nasional dan hari minggu, saya ada mengadop VBA dr Alm mba siti, tetapi >>>> hasil yg diinginkan kurang tepat, adakah yg bisa membantu.. >>>> Terima kasih sebelumnya >>>> Salam >>>> Tiny >>>> >>>> Powered by Telkomsel BlackBerry® >>>> >>>> -----Original Message----- >>>> From: Hartini FIN <[email protected]> >>>> Date: Fri, 16 Nov 2012 05:46:30 >>>> To: [email protected]<[email protected]> >>>> Subject: Tidak Memperhitungkan Libur Nasional >>>> >>>> >>>> CONFIDENTIAL NOTE: The information contained in this email is intended >>>> only for the use of the individual or entity named above and may contain >>>> information that is privileged, confidential and exempt from disclosure >>>> under applicable law. If the reader of this message is not the intended >>>> recipient, you are hereby notified that any dissemination, distribution or >>>> copying of this communication is strictly prohibited. If you have received >>>> this message in error, please immediately notify the sender and delete the >>>> mail. Thank you. >>>> >>>> >>> >> > >
