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
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
2 matches
Mail list logo