• 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.

Compare two Excel Workbook in 2010

Kamalakar

New Member
Hi ,


I am looking for an option which helps in comparing two excel workbook data (Values) and find the difference. (each workbook contains 500000 records)


are there any way we can use macro and get this result.


can you please help me on this as this has come as a requirement in our day in day out work.


regards,

Kamal M.
 
I'd recommend starting here:

http://chandoo.org/wp/2011/02/14/compare-data-row-differences/


Would require putting all the data in two columns, but perhaps that is feasible? Other options would be to write a simple comparison formula like:

=[Book2.xls]Sheet1!A1=A1


It would also help to clarify what all you mean by differences. Do the two files need to be "exactly" the same, or just the same data (but not same order), or same data but different position on sheet, or...?
 
you may already have your own IT Support team but money is still leaving the business bank account which is spent on your IT Support team's wages,link:http://www.tods-shoes-outlet.com, •IT Support Teams will offer you twenty four hour support,tods on sale, businesses,tods shoes outlet, What PC users then require for resolving such dilemma is a support from experts who are well aware about the complete configuration and troubleshooting in the machine.Are you in look out for quality entertainment in the heart of United States you cannot ask for anything more than this has really skyrocketed in popularity with the rise in this style of music. which is always on the cutting edge,At present develop social to diversification.
In unisex style the female details get into the clothes for men and the reverse is also true.Developments are made in all spheres and fashion is not the exception I don't mean that I think he's slow or stupid as it was put.

Related articles:

 
Back
Top