Results 1 to 2 of 2

Thread: Exceptions in two data sets

  1. #1

    Exceptions in two data sets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    Hopefully someone can help me figure out how to accomplish what I'm hoping is possible.

    Every month I need to run a report of fully completed jobs ranked by their completion percentage. Due to backend closing protocols sometimes these jobs will still show 100% completed as they haven't had final invoices processed yet.

    What I'm hoping to do is take my month by month report of 100% completed jobs, and merge last month's with current month, and drop out all entries that exist in both data sets, ie I only want the exceptions between both sets.

    I tried deleting duplicates... which in hindsight does exactly what it says, deleted the duplicates. However I want it to delete BOTH entries that are the same, not just one duplicate and leave the original entry.

    Possible?

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Perhaps you can adapt the response to a somewhat similar question posted on another forum that created lists of the differences of two columns.

    If not, post a sample workbook of what you're working with and I'm sure somebody will help you out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •