| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to compare datas | Excel Programming | |||
| Macro to compare datas | Excel Programming | |||
| Trying to compare the datas... | Excel Worksheet Functions | |||
| How to compare two columns of data to make sure they match | Excel Worksheet Functions | |||
| Compare two columns, delete rows that match? | Excel Programming | |||
Hybrid Mode
