Delete Duplicates based on Criteria

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

You've got 3 possible entries under location status.
Which one(s) get moved to another worksheet? (or deleted) I'm assuming that "Installed" stays put.
Pete

Pete,
Thats correct. I just need the ones that have the cell populated with 'Cancelled' to be moved.