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
>

Attachment: re-lookup_data_terakhir.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Kirim email ke