Compare WorkSheets – Highlight Non-Duplicate Entries

This utility compare two worksheets in a workbook and highlight non-duplicate entries.It accepts user input in a form as shown below:

Compare Two Excel WorkSheets and highlight  non-duplicate entriesUser is required to enter Workbook (e.g. Demo.xls) and WorkSheet 1 (e.g Sheet1) and WorkSheet 2 (e.g Sheet2) and press Compare button.

This utility compare first column of both the sheets and highlight non-duplicate entries in WorkSheet 1 as shown below:

Ouput of comparing two worksheets and highlight non-duplicate entries

Download this utility Compare_WorkSheets_For_Non_Duplicate_Entries.xls

We provide consultancy services in Microsoft Excel. If you are looking for further enhancements to this utility, feel free to contact us here.

  1. Hello – I created a test spreadsheet and was able to run the utility — at the end it said “6 cells contain different values!” …but then wouldn’t let me close the utility to see where those cells are. I had to force quit excel to get out. (Running Mac Office 2010 Excel v14.3.9).

  2. Sir i have two columns in a excel sheet as shown below.

    Column A Column B
    87 87
    107 107
    108 108
    117 117
    119 119
    153 153
    170 170
    174 174
    209 209
    409106386989 409014007285
    409110099164 174

    Here both columns A and B contains 11 entries.
    Now i have to find out the non identical entries from both columns.
    i.e entries 409106386989 and 409110099164 are present only in Column A but not in B.
    So i have to separate these entries from Column A.

    Like wise entries 409014007285 present only in column B but not in A.
    Also there are two entries 174 in column B but only one entry in column A.
    So i have to separate these two entries i.e 409014007285 and 174 from column B.

    So the Output should be as below.

    Entries present in Column A bu not in Column B Column A Column B Entries present in Column A bu not in Column B
    409106386989 87 87 409014007285
    409110099164 107 107 174
    108 108
    117 117
    119 119
    153 153
    170 170
    174 174
    209 209

    Sir i am doing this process manually which is taking much time when the entries are thousand togather.

    I request you provide me any script which ask only the address of input file and give the output file.

Leave a Reply to Badesab Cancel reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">