Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do I Match Databases?
I have a set of 13 databases containing annual company information, that I would like to match. Each database contains a column of company identification codes and a wide variety of variables for each year, such as monthly returns, market capitalization etc. I want to match the 13 databases into one database, which is sorted on company codes. However, the number of companies differs for each year, since some are liquidated or merged during the course of the year, while others are founded later in the sample period, such that they do not appear in the first databases (the variation in codes is quite big). Normally, I would use pivot tables to match these kind of databases. However, due to the size of the databases (around 2000 entries each) and the large amount of variables in each of the databases this is only possible for about 3 databases at a time, that must be matched manually afterwards. Since this gets very time-consuming, I hope that someone knows a less cumbersome solution (either in excel or another software package). Thanks in advance, RonaldP -- RonaldP ------------------------------------------------------------------------ RonaldP's Profile: http://www.excelforum.com/member.php...o&userid=34620 View this thread: http://www.excelforum.com/showthread...hreadid=543952 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match 2 databases based on a column with same values | Excel Discussion (Misc queries) | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |