Hello All,
I am looking some following solution :

Sheet1 Table :
Col_A (Date) Col_B (Name) Col_C (Amt)
01-Jan-2009 Japan 1500
02-Jan-2009 Singapore 2000
05-Jan-2009 Singapore 1700
06-Jan-2009 Japan 1000
10-Jan-2009 Korea 1500

Now I want get in Sheet2 just last date & Pmt Amt like as under :
Japan 06-Jan-2009 1000
Singapore 05-Jan-2009 1700

Is it possible ?

Thanks in advance.