Excel 2007 : Automatic Sorting, Duplicate Removal

I am looking for a solution to a sorting problem with a large amount of duplication. The data is coming from an SQL database, and the information of concern is the Location ID, Updated Date, Ticket Number (Unique), and the Location Count (a count of how many times the location appears in the table).

This data comes in an export and I am looking for a way to sort it automatically in a seperate sheet so that the original raw export is still viewable. I am used to sorting a lot of data like this by formula, the problem I am running into is the duplicate removal.

I need to remove all duplicate entries, keeping only the most recent (by updated date), and display the ticket number and count besides the location is. The count has to be the original value of how many times the location ID showed up, since we are removing the other entries. Finally, any entries with less than 3 counts needs to be removed.

I have attached a book with two sheets, one sheet for a raw export example, a second with what it should look like. For size, I skipped the last step (removing less than 3 counts) but that part is simple enough. Any help is much appreciated =)

It was a similar goal, but you have actually given me a solution to both issues. Thank you!

Actually, I did have one more problem. The intent is to view the locations by count, but only those with more than 3 for the count (if they have less than 3, we don't want them on the PT).

I'm not very experienced with PT, but I can't find a way to make it filter the PT by the count without removing that column from the table itself.

Nevermind, I figured it out. Still, thank you for the help =)