Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing lists
I have two lists I want to "merge". They both have Order Number as a column.
I want to combine them into one list, and each list is over 3000 rows long. How do I do this? Also - the order numbers aren't matching unless I retype them in one of the lists (without changing any formatting). What's with that? John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing lists
John,
Sometimes, numbers get entered as text, which will result in no matches. You need to enter a 1 into a blank cell, copy that cell, select your 'number' cells, and do a pastespecial multiply to convert the text to numbers. Do that to both lists. Then to combine: it depends on what you mean by 'combine' - is the data the same type, or something different. You might be able to use VLOOKUP formulas to match up the tables.... HTH, Bernie MS Excel MVP "John in MN" <John in wrote in message ... I have two lists I want to "merge". They both have Order Number as a column. I want to combine them into one list, and each list is over 3000 rows long. How do I do this? Also - the order numbers aren't matching unless I retype them in one of the lists (without changing any formatting). What's with that? John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two lists of financial data | Excel Discussion (Misc queries) | |||
Comparing two lists in excel that don't match exactly | Excel Worksheet Functions | |||
Comparing lists of map references | Excel Worksheet Functions | |||
Comparing multiple lists | Excel Worksheet Functions | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions |