Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching Lists Where List Size is Unequal
I am currently working on an Economics undergrad thesis regarding the NHL and I have run into a stumbling block that I think can be solved with Excel. I currently have two lists: list A is a list of player names in column A with a statistic measuring their value in column B. List B also has a list of player names in column A with the player's salary in column B. List A and B have most of the players in common but some players in list A are not in list B and some players in list B are not in list A. I want to create a superlist that only has the players in both lists in it, followed by a column with the statistic measuring their value and a column with their salary. Is this possible? One more thing: One of the lists currently has the names as First Name Last Name (no comma) whereas the other list has the names as First Name, Last Name (comma followed by 3 spaces). I am guessing that would have to be fixed before the sorting procedure can take place. If someone could help me out with this, I would really appreciate and you'd probably save me numerous hours of tedious work. Thanks. -- zgall1 ------------------------------------------------------------------------ zgall1's Profile: http://www.excelforum.com/member.php...o&userid=31652 View this thread: http://www.excelforum.com/showthread...hreadid=513410 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change font size in drop down validation lists | Excel Discussion (Misc queries) | |||
How do I increase type size in an Excel drop down list? | Excel Discussion (Misc queries) | |||
maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) | |||
Changing font size in a list box | Excel Discussion (Misc queries) | |||
how to increase the font size in a dropdown list? | Excel Worksheet Functions |