Comparing lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function in Excel to count and list number of entries of text valuesin a row. 2
XL2000 CF and Comparing Lists 5
compare and merge lists in separate worksheets 1
XL2000, CF and List Comparisons 3
Multiple List Analysis 0
comparing two worksheets 1
Compare my list to an existing list 1
Return Names From List 2

Back
Top