Hello everyone,

I don't know VBA and filtering thousands lines of data won’t cut it.

I have a list of jobs that are being worked on. I want to filter out duplicates based on the Location Status and Serial Number. A location will have a serial number that is a unique number. At a location they may change the plan which will create another line item therefor creating a "duplicate." The old job will show as canceled and the new job will have different Status (ex: Installed or Proposed). Only when there is a duplicate serial number I need the active job in the worksheet and have the cancelled job to be moved to another sheet.

Thank you for any help


Duplicates.xlsx