• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting two lists and merging

S

Shaun

Member
Hi All


I have two worksheets which I am trying to sort and merge.


In worksheet 1 I have data from column A to K but in column C I have a unique identifying number which correspondes with worksheet 2


In worksheet 2 I have data from column A to E with the matching unique identifying number in column C.

I would like to match the data in worksheet 1 to worksheet 2.


This issue is that worksheet two contains information not present in worksheet 1 and vice versa, so simply sorting column C and copying across does not work. There is approximately 3500 rows of data so manual maatching will take a great deal of time.


Does anyone have any thoughts on how to automate?


Cheers


Shaun
 
Hi Shaun,


Please Upload sample data and also search this forum for this topic.


Regards,

Faseeh
 
Hi Faseeh


Thank you for taking an interest in my problem.


A more extensive search of Chandoo lead me to an awesome article titled "Even faster way to compare 2 lists in Excel". This got me 90% of the way and I was able to complete the rest.


Cheers


Shaun
 
You must log in or register to reply here.
Back
Top