Removing duplicates based on priority and date

Hello members!

I am working with exel files that contains 3,000+ records and I'm in need to remove duplicates based on 2 things:

• Priority = "Tier 1", "Tier 2" and "Non active"
• Date

Observing the following situations:

• If my Tier 1 priority is the oldest I should keep that record
• If no Tier 1 exists, I should keep the oldest Tier 2
• If no Tier 1 or 2 exists, preferably the record(s) should be deleted or marked in order to delete them manually.
• Sometimes a Tier 2 will have an older date, in this case we should keep the Tier 2 instead of Tier 1, since it's older (Rows 18 and 19 in the attached file)

I've attached an extract of the report and I marked in green the rows that should be kept if a Macro can be created for this situation.

I was trying to adapt Jerry Becauire's approach on this post with no luck since I didn't know how to manage the priorities with the dates

http://www.excelforum.com/excel-prog...-criteria.html

I forgot to mention that my main identifier is Column C

Hopefully someone can help me with this

Thanks!

You've taken the time to explain the tiers and all, but my observations of the sample data are that you are keeping the first instance of each column C value, and the data has already been sorted by date Ascending, so the first instance of each column C value IS the oldest. Yes?