How to match and compare multi-columns datas
 

Foe Excel 2003, I have a base data below and I can get the records from some system based on the below data. But for the result records, one base line may produce several records on the right ranges. And for the bsae datas, may some duplicate fund and cusips but differenct interest will be together, so it will produce duplicate results as the system get the results according to the fund and cusip.

So if there is a good solution to match and compary the date between the base data and the results from the system.Thanks

Base data
FUND CCY CUSIP INTEREST
AJQ1 JPY ACI00V9U1 6,093,000.00
AJQ1 JPY ACI00WH48 11,300,000.00
AJQ1 USD 985BSZII0 7,000.00
S908 EUR B1VJWNII8 47,500.00

Results
Funds CUSIP Pay Date
S908 B1VJWNII8 20120321
S9L2 B421JZII1 20120322
S9L2 B421JZII1 20120322

How to match and compare multi-columns datas
 

On Mar 23, 1:41*am, wrote:
Foe Excel 2003, I have a base data below and I can get the records from some system based on the below data. But for the result records, one base line may produce several records on the right ranges. And for the bsae datas, may some duplicate fund and cusips but differenct interest will be together, so it will produce duplicate results as the system get the results according to the fund and cusip.

So if there is a good solution to match and compary the date between the base data and the results from the system.Thanks

Base data
FUND * *CCY * * CUSIP * * * * * *INTEREST
AJQ1 * *JPY * * ACI00V9U1 * * * 6,093,000.00
AJQ1 * *JPY * * ACI00WH48 * * * 11,300,000.00
AJQ1 * *USD * * 985BSZII0 * * * 7,000.00
S908 * *EUR * * B1VJWNII8 * * * 47,500.00

Results
Funds * CUSIP * Pay Date
S908 * *B1VJWNII8 * * * 20120321
S9L2 * *B421JZII1 * * * 20120322
S9L2 * *B421JZII1 * * * 20120322

I don't see a date to compare in the base data.