Comparing Data Between Tow Excel Documents

There might be a situation when you need to compare specific data between multiple Excel documents.  For example you might have a list of users in two different documents and you would like to know if these users are duplicating in the other Excel document as well. To do that you can follow these instructions or Video is coming soon

1.       Open the main document

2.       Next to the column which contains data of the usernames (in my scenario) insert a new column and name it “Results”

3.       For the first row enter this formula:

=IF(COUNTIF( A$2:A2,Big!A2)>0, "Duplicate", "Unique")

a.       A$2:A2 – The range to compare with (Source)

b.      Big! – Will call out a window to ask for the other document that you want to compare against

c.       A2 – The Fields to compare against in the second document

d.      >0 – Specifies how many times can the name repeat, in my scenario is 0 as I don’t want it to repeat and create a duplicate

e.      "Duplicate", "Unique" – If the record has a duplicate then the “Duplicate” will show if not then “Unique”

4.       Once the formula is entered (Please specify the correct “Source” and fields that you are going to compare against) press, Enter. The Windows will pop-out asking for the document to compare against. Once you have chosen the document, it will ask you for the sheet with which you want to compare. Press OK to continue.

5.       Select the cell that has the result and click and hold on the bottom right corner of the cell and drag for all necessary rows or if you need all rows in the specified column then double click on the bottom left corner of the cell (if you do this option Note that the formula will be copied to the lower cell only as far as there is data in the neighbouring cell)

6.       Review the results and make you adjustments