Finding Duplicates

    I have a list of companies that is a building or on going list - problem that i have is that everytime there is an update to this list they don't just send me the update but they send me the entire list and it's got around 1000 companies so it's getting very cumbersome to look through the whole thing. I tried to use conditional formatting to show me the differences with this =Not(A2=A432) this works if they are the exact same size and in the exact same order . . well they are not always the exact same order because new companies get added in or old ones deleted so it messes it up. .
    Is there a better way of doing this I can post an example if needed
    Thanks.

    Re: Finding Duplicates


    Nichola08,


    Are you perhaps wanting to know what the changes are so you can make the same changes to your list? Is your concern that if you copy and paste the entire list, you will mess up some formulas? Perhaps you could use a dynamic range name to help with your list.


    If you want a quick work around, try this on a clean sheet. Copy and paste both list in one contiguous list. Use the [Data][Filter][Advanced Filter...] command from the Excel menu to copy the unique records to another location.


    Jim

    Re: Finding Duplicates


    The list is for an event and the people on it have registered. The purpose of comparing the updates which I get 2-3 updates a week, is to know who all is on the list that's new from the previous list and if there were any changes to the ones that are on the list. So for example if you look at the 053007 sheet then have to compare it to the 060107 sheet I want to run it so that it will only show me the unique entries or differences so that I may then simply copy them and place into another sheet with multiple links to reports and multiple formulas.

    Re: Finding Duplicates


    Nichola08,


    Let's break this down into steps.


    1) Compare 053007 to 060107 and find out if any person on the 053007 list is left off the 060107 list.
    2) Compare 053007 to 060107 and find out if any person on the 060107 list is left off the 053007 list.
    3) Combine the two results from above and copy and paste them into a third list from which we will do our reporting.


    Is the above correct?
    How are you going to know to delete from the third list?
    Is the 060107 list the most complete list?


    Jim

    Re: Finding Duplicates


    they are by date 05-30-07 (053007) and 06-01-07 (060107) so the 060107 is the newest to date list so yes I want to compare the two and show me the differences in the newest list from the oldest list or to show anything new or different on the 060107 list using the 053007 list as the criteria. I don't have a problem with manually adding the ones that are different to the third list it's more of just a time saver for finding the duplicate entries.

    Re: Finding Duplicates


    Nichola08,


    I can't tell if I got number 1, 2, or 3 correct.


    If the 060107 list is the most current, why not just use it instead of trying to find the differences to add to the third list?


    Jim

    Re: Finding Duplicates


    because the information on the "updates" is not always correct. It's ok if there's not a simple way I don't have time to write VBA for it or I'd have gone that route.

    Re: Finding Duplicates


    Super Simple Solution:


    1) Put one list in a sheet next to the other list.
    2) Make sure both lists have the same column widths.
    3) Make sure both sheets are set at the same zoom level.
    4) Toggle back and forth (CTL+PGUP ... CTL+PGDOWN) between the two really fast.
    (You may be amazed at how good this works for identifying diffs if you've never tried it)


    Jim


    PS - I don't know if there's a better solution since you haven't answered my questions...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login