How to match and compare multi-columns datas

  • Thread starter Thread starter mhj88339553
  • Start date Start date
M

mhj88339553

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 linemay 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
 
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
Click to expand...

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