Re: [belajar-excel] Denda Finger Print

2018-05-24 Terurut Topik Fatimah Nazmi fatimahna...@gmail.com [belajar-excel]
Terima Kasih atas solusinya Mr.Kid, berdasarkan petunjuk solusi sementara : 1. =IF(AND(A4=A5,K4=K5),D4="",D4) 2. rumus ini masih perlu perbaikan, mohon pencerahan dari Mr.Kid. =IF(AND(INT(C4)VLOOKUP($A4,RINCI,11,0),VLOOKUP($A4,RINCI,10,0)=D4),VLOOKUP($A4,RINCI,9,0),VLOOKUP($A4,RINCI,8,0),"")) 3. =I

Re: [belajar-excel] Deteksi Waktu Tandem

2018-05-24 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
Wa'alaikumussalam wr wb Array formula id_tandem : =MAX((E2=[Matakuliah])*(C2=[Tempat])*(A2<>[0])*(F2>=[Mulai])*(F2<=[Selesai])*[0]) Wassalamu'alaikum wr wb Kid On Thu, May 24, 2018 at 11:04 AM, Eira I Arie cheivory_bri...@yahoo.com [belajar-excel] wrote: > > > Yth. *Mr. Kid * > > > *Assalaa