Coba file terlampir. Bisa dengan formula maupun dengan pivot table.
Wassalam, Kid. 2012/9/10 megantara <[email protected]> > No job tanggal pelunasan**** > > 1201076 16-May-12**** > > 1203051 19-May-12**** > > 1204005 21-May-12**** > > 1204022 22-May-12**** > > 1201021 23-May-12 >
re-lookup_data_terakhir.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

