Re: [belajar-excel] Memunculkan tgl terakhir ???? [1 Attachment]

2015-06-27 Terurut Topik 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
Hai Shenly, mumpung pertamax... jadi bisa pendekan dikit... Biasanya, pakai lookup jadi begini bunyinya : =LOOKUP(9^9,G4:G18/(H4:H18=B4)) File terlampir... (mode baik hati pakai lampiran) Wassalam, Kid 2015-06-27 22:39 GMT+10:00 Shenly shenly_excelma...@yahoo.co.id [belajar-excel] : > > >

[belajar-excel] Memunculkan tgl terakhir ???? [1 Attachment]

2015-06-27 Terurut Topik Shenly shenly_excelma...@yahoo.co.id [belajar-excel]
halo master gimna ya caranya memunculkan tanggal akhir berdasarkan masing2 user  Salam Shenly ^^* expl54.xlsx Description: MS-Excel 2007 spreadsheet