LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
DREAM MERCHANT
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 11:46 AM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM


All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"