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.