| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to compare multiple lists of data in excel
How to compare two or more lists of data?
For example: Comparing stocks held by different mutual funds I want to identify the stocks which are common in different mutual funds (MFs) i.e. like MF X holds ABC Co. - 500 units DEF Co. - 300 MOP Co - 600 AAA Co.- 200 MF Y holds CBA Co. - 500 units MOP Co. - 900 FED Co - 600 BBB Co.- 200 MF Z holds ABC Co. - 500 units NPL Co. - 300 MOP Co - 100 CCC Co.- 200 Like this there are more than 20 MFs holding more than 35 stocks each. I want to know the common stocks and their units in each for my study RAJEEV MINOCHA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Threaded Mode
