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

['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@yahoogroups.com>:

>
>
> halo master gimna ya caranya memunculkan tanggal akhir berdasarkan masing2
> user....
>
>
> Salam
> Shenly ^^*
>
>  
>

re-expl54.xlsx
Description: MS-Excel 2007 spreadsheet